Search Results

This only looks at $NF's last char. This awk -F, '{if ($NF~/[0-9A-Za-z][0-9A-Za-z][0-9A-Za-z]/) print >"goodfile"; else print>"badfile}' samp.txtwill work on the example, but it does not take into...

perl -F, -lane 'print join(",",@F[0..7]),",",join("|",@F[8..10]),",",$F[-1]' inputfile

$ nawk -F\" -v OFS=\" '{gsub(/,/,"\|",$10)}1' input.txt
"ABCD","I",23,0,9,,"23/12/2012","OK","Street|State| 91135",0
"ABCD","I",23,0,9,,"23/12/2012","OK","Street|State| 91135",0

Try:
awk 'NR%2-1{gsub(/,/,"|")}1' RS=\" ORS=\" infile
"ABCD","I",23,0,9,,"23/12/2012","OK","Street|State| 91135",0
"ABCD","I",23,0,9,,"23/12/2012","OK","Street|State| 91135",0



--
Here is...

[root@node2 ~]# sed -n '/C$/!p' infile
def,adc,asdf,123,12A
[root@node2 ~]# sed -n '/C$/p' infile
bca,adc,asdf,123,12C
bca,adc,asdf,123,13C

why don't you use regular expressions? Something like
$NF ~ /.*C$/ { print > "splitC.csv" }

awk -F, '$NF ~ /C$/ {print > "splitC.csv";next}1' inputfile > splitother.csv

If the values where truly different:
awk -F, -v vA="12C,13C" 'BEGIN{split(vA,a,",");for (i in a){b[a[i]]++}}{fic= $NF in b ? "splitC.csv" : "splitB.csv" ; print $0>>fic}' infile.csv

Using the last character in each line...$ cat Something.csv
bca,adc,asdf,123,12C
bca,adc,asdf,123,13C
def,adc,asdf,123,12A

$ awk '{print substr($0,length)}' Something.csv
C
C
A

$ awk...