Guest User

Untitled

a guest
Jul 23rd, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. awk -F'"' -v OFS='' '{ for (i=2; i<=NF; i+=2)
  2. if ($i == 12 || $i == 17)
  3. print substr($i,index($0,$9))
  4. else gsub(",", "", $i)
  5. } 1' $1 > testTREATED.csv
  6.  
  7. ID,ID_CUSTOMER,CUSTOMER_FULLNAME,TYPE_DOCUMENT,NUM_DOCUMENT,CUSTOMER_NAME,LASTNAME1_CUSTOMER,LASTNAME2_CUSTOMER,F_UID,L_UID,ID_LIST,ID_ACCOUNT,DATE_OF_BIRTH,CASE,ANALIST,COMMENTS,COMMENTS2,START_DATE,ORGUNIT_ID,AMOUNT,TYPE
  8. 0001,,SWISS CHOCOLATE LTD,,,,SWISS CHOCOLATE LTD,,,000000-000000,XX,,,,,,,"25/06/2007 23:45:65, 000000000",0,,
  9.  
  10. 25/06/2007
Add Comment
Please, Sign In to add comment