Sample Header Ad - 728x90

convert an excel file to pipe delimiter file in Linux using script

1 vote
1 answer
2207 views
Need to convert an excel file to pipe delimiter file in Linux using shell script. pls help I'm new to shell script. I saw a post to convert comma to pipe using the below code... awk '{for(i=1; i<=NF; i+=2) gsub(",","|",$i)}1' FS=\" OFS= file how to change this command for excel file to pipe?
Asked by user3844609 (11 rep)
Jul 10, 2019, 05:48 AM
Last activity: Jul 12, 2019, 08:38 AM