Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
data_analysis:work:corp_code [2020/03/04 02:22] – ↷ Page moved from data_analysis:b2b_enterprise_analysis:corp_code to data_analysis:work:corp_code prgram | data_analysis:work:corp_code [2025/07/07 14:12] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 3: | Line 3: | ||
{{tag> | {{tag> | ||
- | [[data_analysis: | + | [[data_analysis: |
===== R ===== | ===== R ===== | ||
Line 30: | Line 30: | ||
Reg2 | Reg2 | ||
} | } | ||
+ | </ | ||
+ | |||
+ | |||
+ | ===== SQL ===== | ||
+ | <code sql> | ||
+ | case | ||
+ | when length([사업자번호]) <> 10 then ' | ||
+ | when [사업자번호] is null then ' | ||
+ | when substr([사업자번호], | ||
+ | when substr([사업자번호], | ||
+ | when substr([사업자번호], | ||
+ | when substr([사업자번호], | ||
+ | when substr([사업자번호], | ||
+ | when substr([사업자번호], | ||
+ | when substr([사업자번호], | ||
+ | when substr([사업자번호], | ||
+ | when substr([사업자번호], | ||
+ | when substr([사업자번호], | ||
+ | else ' | ||
+ | end | ||
</ | </ | ||