Awk Command not able to read French/Spanish characters from a file
Awk Command not able to read French/Spanish characters from a file
(OP)
Using Awk Commmand I am trying to get value of a column in .csv file which contains French/Spanish characters. When Viewing file through View command French/Spanish characters are printed properly but using awk/head command it removes French/Spanish . Sample Data - Vinêâêîôûcédille characters.
Awk Command Output - Vin▒▒▒▒▒▒c▒dille
Head Command output - "Vin▒▒▒▒▒▒c▒dille
Expected Output - Vinêâêîôûcédille
Please see code and output snippet below
view Package_UTF8.txt
"dE82WVJ","CmFX","COMPLETED","false","Vinêâêîôûcédille TEST","en","PACKAGE","2022-07-20T18:15:13Z","","Vinêâêîôûcédille","2022-07-20T18:16:04Z","true","Electronic Disclosures and Signatures Consent","false","default-consent","tO6YRDDweek5","Vi","Ma","","","vi.ma@xyz.com","null","en","","","tO6YRDDweek5","0","null","2022-06-23T17:04:10Z","2022-06-29T21:50:14Z","ACTIVE","REGULAR","false","Vi_Ma_tO6YRDDweek5_Vinêâêîôûcédille_20220720T181513Z"
awk -F "," 'NR==2 {print ($34) }' Package_UTF8.txt;
"Vi_Ma_tO6YRDDweek5_Vin▒▒▒▒▒▒c▒dille_20220720T181513Z"
'head -2 Package_UTF8.txt'
"dE82WVJ","CmFX","COMPLETED","false","Vin▒▒▒▒▒▒c▒dille TEST","en","PACKAGE","2022-07-20T18:15:13Z","","Vin▒▒▒▒▒▒c▒dille","2022-07-20T18:16:04Z","true","Electronic Disclosures and Signatures Consent","false","default-consent","tO6YRDDweek5","Vi","Ma","","","vi.ma@xyz.com","null","en","","","tO6YRDDweek5","0","null","2022-06-23T17:04:10Z","2022-06-29T21:50:14Z","ACTIVE","REGULAR","false","Vi_Ma_tO6YRDDweek5_Vin▒▒▒▒▒▒c▒dille_20220720T181513Z"
Awk Command Output - Vin▒▒▒▒▒▒c▒dille
Head Command output - "Vin▒▒▒▒▒▒c▒dille
Expected Output - Vinêâêîôûcédille
Please see code and output snippet below
view Package_UTF8.txt
"dE82WVJ","CmFX","COMPLETED","false","Vinêâêîôûcédille TEST","en","PACKAGE","2022-07-20T18:15:13Z","","Vinêâêîôûcédille","2022-07-20T18:16:04Z","true","Electronic Disclosures and Signatures Consent","false","default-consent","tO6YRDDweek5","Vi","Ma","","","vi.ma@xyz.com","null","en","","","tO6YRDDweek5","0","null","2022-06-23T17:04:10Z","2022-06-29T21:50:14Z","ACTIVE","REGULAR","false","Vi_Ma_tO6YRDDweek5_Vinêâêîôûcédille_20220720T181513Z"
awk -F "," 'NR==2 {print ($34) }' Package_UTF8.txt;
"Vi_Ma_tO6YRDDweek5_Vin▒▒▒▒▒▒c▒dille_20220720T181513Z"
'head -2 Package_UTF8.txt'
"dE82WVJ","CmFX","COMPLETED","false","Vin▒▒▒▒▒▒c▒dille TEST","en","PACKAGE","2022-07-20T18:15:13Z","","Vin▒▒▒▒▒▒c▒dille","2022-07-20T18:16:04Z","true","Electronic Disclosures and Signatures Consent","false","default-consent","tO6YRDDweek5","Vi","Ma","","","vi.ma@xyz.com","null","en","","","tO6YRDDweek5","0","null","2022-06-23T17:04:10Z","2022-06-29T21:50:14Z","ACTIVE","REGULAR","false","Vi_Ma_tO6YRDDweek5_Vin▒▒▒▒▒▒c▒dille_20220720T181513Z"
Talk To Other Members
RE: Awk Command not able to read French/Spanish characters from a file
I used this file
Package_UTF8.txt
CODE
and got this result
You didn't mention what OS you are using.