cut --output-delimiter="|" -c 1-15,18-30,50-55,58-63,66-72,95-181 | sed 's/ *$//' | sed 's/\s*$//' | sed 's/\([^ ]*\) *|/\1|/g' | cut -d"|" --output-delimiter=$'\t' -f1-
- 입력(fixed length)
Field Type Collation Null Key Default Extra Privileges Comment --------------- ------------- --------------- ------ ------ ------- ------ ---------- --------------------------------------------------------------------------------------- partnerId varbinary(9) (NULL) NO PRI (NULL) select 거래처ID partnerName varchar(100) utf8_general_ci NO MUL (NULL) select 거래처명 bizNum varchar(12) utf8_general_ci NO (NULL) select 사업자번호
- 출력(tab delimiter)
Field Type Null Key Default Comment --------------- ------------- ------ ------ ------- --------------------------------------------------------------------------------------- partnerId varbinary(9) NO PRI (NULL) 거래처ID partnerName varchar(100) NO MUL (NULL) 거래처명 bizNum varchar(12) NO (NULL) 사업자번호
last modified 2013-11-18 18:02:54
Processing time 0.0058 sec