KHUB

transform을 이용한 특수문자,숫자,공백 제거 샘플 스크립트

Writer 오창민

Description	참고: http://zeus.konantech.com/browse/SGBOARD-5922 ``` string remove_spcs(string fdval) { return ''.join( map(lambda(y)(y[0]), // 투플 값에서 실제 문자열만 추출 filter( lambda(x)(x[1] not in ['NUM','SYM','SPC']), // 숫자(NUM),특수기호(SYM),공백(SPC) 제외 fdval.splitkc('utf8')) // 토큰으로 분할 => [('문자열','타입'),...] 리턴 ) ); } void main() { create volume test_vol; use volume test_vol; create table tab( file_name string verbatim null, fnam_trim string verbatim null, fnam_md5 string null, ); fopen("mytest.fgf","w+b") << "<__file_name__>주간보고_R1_20171231.ppt <__file_name__>함량 비교 분석 결과@SIMS_공수진_Rev00_150720.ppt <__file_name__>주간보고_R1_20171231.ppt (주간보고 R1 ppt) <__file_name__>주간보고_R0_20171231.ppt (주간보고 R0 ppt)"; import files . mytest.fgf to tab format file_name = "<__file_name__>" transform fnam_trim = remove_spcs(file_name), fnam_md5 = md5(file_name) operation store; select * from tab; printz KQL_STATEMENT_OUT; } ``` ``` $ ./kql -f kql.rc -x "run remove-spcs-sample.k;" ---------- 0 of total 4 (ROWID 0) --------- file_name (28): 주간보고_R1_20171231.ppt fnam_trim (16): 주간보고Rppt fnam_md5 (32): 3fb08cf3e9ea77a6fe1f4cd755d12a88 ---------- 1 of total 4 (ROWID 1) --------- file_name (59): 함량 비교 분석 결과@SIMS_공수진_Rev00_150720.ppt fnam_trim (43): 함량비교분석결과SIMS공수진Revppt fnam_md5 (32): ba1f9bc8267aaf9697f565bc36a4fc59 ---------- 2 of total 4 (ROWID 2) --------- file_name (50): 주간보고_R1_20171231.ppt (주간보고 R1 ppt) fnam_trim (32): 주간보고Rppt주간보고Rppt fnam_md5 (32): c8c03d030c3dddd2593e9346a3e97bbd ---------- 3 of total 4 (ROWID 3) --------- file_name (50): 주간보고_R0_20171231.ppt (주간보고 R0 ppt) fnam_trim (32): 주간보고Rppt주간보고Rppt fnam_md5 (32): 867d894fc3702c505bbc093fe36b7b9a Total 4 records. ```
Tag	transform splitkc
Module Name
Attachments

Comments

© Konan Technology Inc., All rights reserved.