This question already has an answer here:
I'm using IBM AIX which doesn't have much support like
sed -i and sed with
\t is not working in my case.
I would like to replace replace
NotApplicable string with a
single space ' ' then replace
@@@ multi-char-delimiter with a
tab delimiter, in a specified order using single command be it awk, or sed.
I tried using sed as following but it didn't work. Couldn't add search and replace for NotApplicable with a ' ' single space in below command.
sed 's/@@@/\t/g' file.csv > file.xls
cola@@@colb@@@colbc test@@@test@@@test test@@@NotApplicable@@@test 123@@@145@@@567 333@@@444@@@NotApplicable cola colb colbc test test test test test 123 145 567 333 444