I’m trying to remove the first 0 from the third column in my CSV file
tel.csv –
JavaScript
x
test,01test,01234567890
test,01test,09876054321
I have been trying to use the following with no luck –
JavaScript
cat tel.csv | sed 's/^0*//'
Advertisement
Answer
Something like:
JavaScript
sed 's/^([^,]*),([^,]*),0(.*)$/1,2,3/' file.csv
Or awk
JavaScript
awk 'BEGIN{FS=OFS=","}{sub(/^0/, "", $3)}1' file.csv