Swapping fields

Shell Programming and Scripting
1

Hallo Team,

This is the command that i am running :

grep ",Call Forward Not Reachable" *2013*

this is the output that i am getting (i did a head -10 but the files can be more than 1000)

BW-CDR-20130607092500-2-AC162DB137C8-027539-000.csv_rejected_3852983-20130611224135.log:0020234179AC162DB137C820130607071938.5530+020000,MCCARTHY,Normal,+27745102865,,Originating,+27745102865,Anonymous,0123345500,20130607071938.553,0+020000,Yes,20130607071951.278,20130607072049.539,016,VoIP,,0123345500,private,,,,remote,Group,,G729/8000,,,,,,HIP-TOYOTA-DIV-OFFICE,PA (HIP-TOYOTA-DIV-OFFICE),,,+27123345569,Public,unavailable,+27123345569,Public,unavailable,n,,,633053325:0A,633053373:0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0123345569@isvoip.net,PORTIA SETLHARE,Public,,,,,,,,,,,,,,,,,,,,,,,,633053325:0,Call Forward Not Reachable,,,,,,,,,58.261,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Group,,,,,,,,,,,,,,,,+27123345569,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,|Y,ACCOUNT NOT FOUND (9)
BW-CDR-20130610124000-2-AC162DB137C8-028442-000.csv_rejected_3852410-20130611223822.log:0023344926AC162DB137C820130610103222.7980+020000,SEESA,Normal,+27343264503,,Originating,+27343123909,Public,0873509090,20130610103222.798,0+020000,Yes,20130610103239.895,20130610103557.501,016,VoIP,,0873509090,private,,,,remote,Group,,G729/8000,,,,,,HIP-SEESA-NEWCASTLE,Admin (HIP-SEESA-NEWCASTLE),,,+27343264503,Public,unavailable,+27343123909,Public,unavailable,n,,,645911949:0A,645911953:0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0343123909@isvoip.net,Rina Visser,Public,,,,,,,,,,,,,,,,,,,,,,,,645911949:0,Call Forward Not Reachable,,,,,,,,,197.605,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Group,,,,,,,,,,,,,,,,+27343123909,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,|Y,ACCOUNT NOT FOUND (9)
BW-CDR-20130611111000-2-AC162DB137C8-028712-000.csv_rejected_3853572-20130611224551.log:0025103889AC162DB137C820130611090905.9390+020000,MCCARTHY,Normal,+27123238041,,Originating,+27123238041,Public,0123345500,20130611090905.939,0+020000,Yes,20130611090909.598,20130611090914.139,016,VoIP,,0123345500,private,,,,remote,Group,,G729/8000,,,,,,HIP-TOYOTA-DIV-OFFICE,Debtors (HIP-TOYOTA-DIV-OFFICE),,,+27123345534,Public,unavailable,+27123345534,Public,unavailable,n,,,652445523:0A,652445527:0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0123345534@isvoip.net,PORTIA SETLHARE,Public,,,,,,,,,,,,,,,,,,,,,,,,652445523:0,Call Forward Not Reachable,,,,,,,,,4.540,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Group,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,|Y,ACCOUNT NOT FOUND (9)
BW-CDR-20130611112000-2-AC162DB137C8-028714-000.csv_rejected_3853390-20130611224431.log:0025137049AC162DB137C820130611091711.4950+020000,MCCARTHY,Normal,+27123345534,,Originating,+27123238041,Public,0123345500,20130611091711.495,0+020000,Yes,20130611091718.015,20130611091723.068,016,VoIP,,0123345500,private,,,,remote,Group,,G729/8000,,,,,,HIP-TOYOTA-DIV-OFFICE,Debtors (HIP-TOYOTA-DIV-OFFICE),,,+27123238041,Public,unavailable,+27123345534,Public,unavailable,n,,,652553811:0A,652553815:0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0123345534@isvoip.net,PORTIA SETLHARE,Public,,,,,,,,,,,,,,,,,,,,,,,,652553811:0,Call Forward Not Reachable,,,,,,,,,5.052,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Group,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,|Y,ACCOUNT NOT FOUND (9)
BW-CDR-20130611112000-2-AC162DB137C8-028714-000.csv_rejected_3853390-20130611224431.log:0025137607AC162DB137C820130611091628.3410+020000,SEESA,Normal,+27343123909,,Originating,+27820967774,Public,0873509090,20130611091628.341,0+020000,Yes,20130611091632.905,20130611091731.831,016,VoIP,,0873509090,private,,,,remote,Group,,G729/8000,,,,,,HIP-SEESA-NEWCASTLE,Admin (HIP-SEESA-NEWCASTLE),,,+27820967774,Public,unavailable,+27343123909,Public,unavailable,n,,,652544549:0A,652544553:0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0343123909@isvoip.net,Rina Visser,Public,,,,,,,,,,,,,,,,,,,,,,,,652544549:0,Call Forward Not Reachable,,,,,,,,,58.923,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Group,,,,,,,,,,,,,,,,+27343123909,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,|Y,ACCOUNT NOT FOUND (9)
BW-CDR-20130611112500-2-AC162DB137C8-028715-000.csv_rejected_3852909-20130611224109.log:0025153759AC162DB137C820130611092113.8390+020000,MCCARTHY,Normal,+27123238041,,Originating,+27123238041,Public,0123345500,20130611092113.839,0+020000,Yes,20130611092122.634,20130611092128.481,016,VoIP,,0123345500,private,,,,remote,Group,,G729/8000,,,,,,HIP-TOYOTA-DIV-OFFICE,Debtors (HIP-TOYOTA-DIV-OFFICE),,,+27123345534,Public,unavailable,+27123345534,Public,unavailable,n,,,652607275:0A,652607279:0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0123345534@isvoip.net,PORTIA SETLHARE,Public,,,,,,,,,,,,,,,,,,,,,,,,652607275:0,Call Forward Not Reachable,,,,,,,,,5.846,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Group,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,|Y,ACCOUNT NOT FOUND (9)
BW-CDR-20130611113500-2-AC162DB137C8-028717-000.csv_rejected_3853523-20130611224527.log:0025193103AC162DB137C820130611092825.8640+020000,SEESA,Normal,+27741411224,,Originating,+27741411224,Anonymous,0873509090,20130611092825.864,0+020000,Yes,20130611092831.376,20130611093049.536,016,VoIP,,0873509090,private,,,,remote,Group,,G729/8000,,,,,,HIP-SEESA-NEWCASTLE,Admin (HIP-SEESA-NEWCASTLE),,,+27343123909,Public,unavailable,+27343123909,Public,unavailable,n,,,652705171:0A,652705175:0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0343123909@isvoip.net,Rina Visser,Public,,,,,,,,,,,,,,,,,,,,,,,,652705171:0,Call Forward Not Reachable,,,,,,,,,138.159,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Group,,,,,,,,,,,,,,,,+27343123909,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,|Y,ACCOUNT NOT FOUND (9)
BW-CDR-20130611115500-2-AC162DB137C8-028721-000.csv_rejected_3852889-20130611224105.log:0025292959AC162DB137C820130611095426.4120+020000,MCCARTHY,Normal,+27123621921,,Originating,+27123621921,Public,0123345500,20130611095426.412,0+020000,Yes,20130611095442.216,20130611095444.860,016,VoIP,,0123345500,private,,,,remote,Group,,G729/8000,,,,,,HIP-TOYOTA-DIV-OFFICE,Debtors (HIP-TOYOTA-DIV-OFFICE),,,+27123345534,Public,unavailable,+27123345534,Public,unavailable,n,,,653055085:0A,653055089:0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0123345534@isvoip.net,PORTIA SETLHARE,Public,,,,,,,,,,,,,,,,,,,,,,,,653055085:0,Call Forward Not Reachable,,,,,,,,,2.643,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Group,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,|Y,ACCOUNT NOT FOUND (9)
BW-CDR-20130611121000-2-AC162DB137C8-028724-000.csv_rejected_3852301-20130611223740.log:0025345156AC162DB137C820130611100743.3810+020000,SEESA,Normal,+27835550491,,Originating,+27835550491,Public,0873509090,20130611100743.381,0+020000,Yes,20130611100748.020,20130611100816.376,016,VoIP,,0873509090,private,,,,remote,Group,,G729/8000,,,,,,HIP-SEESA-NEWCASTLE,Admin (HIP-SEESA-NEWCASTLE),,,+27343123909,Public,unavailable,+27343123909,Public,unavailable,n,,,653224439:0A,653224443:0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0343123909@isvoip.net,Rina Visser,Public,,,,,,,,,,,,,,,,,,,,,,,,653224439:0,Call Forward Not Reachable,,,,,,,,,28.355,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Group,,,,,,,,,,,,,,,,+27343123909,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,|Y,ACCOUNT NOT FOUND (9)
BW-CDR-20130611123500-2-AC162DB137C8-028729-000.csv_rejected_3852265-20130611231111.log:0025433349AC162DB137C820130611103158.7230+020000,NATIONAL GAMBLING BOARD,Normal,+27720554307,,Originating,+27720554307,Public,0722600158,20130611103158.723,0+020000,Yes,20130611103208.712,20130611103253.498,016,VoIP,,0722600158,national,mobi,0722600158,,remote,10.0.108.21:5060,BW123158724110613-129535791@196.35.130.5,G729/8000,,,,,,HIP-NGB-ECOPARK,Centurion (HIP-NGB-ECOPARK),,,+27100033480,Public,unavailable,+27100033480,Public,unavailable,y,public,,653515435:0A,,,,,,,,,,,,,,cigZYFId~WPLAAIDBXHMBVJClgE-,10.31.36.37,pst.vodacom.co.za,pst.vodacom.co.za,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0100033480@isvoip.net,,,,,,,,,,,,,,,,,,,,,,,,,,653515435:0,Call Forward Not Reachable,,,,,,,,,54.385,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Network,,,,,,,,,,,,,,,,+27100033480,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,|Y,ACCOUNT NOT FOUND (9)

I would like to swap field4 with filed36 and field36 with field4. The names of the files and everything should remain as it is except field 4 and 36.

I thank you in advance and many blessings.

2 
awk -F"," -v OFS="," '{ T=$4 ; $4=$36 ; $36=T } 1'
1 Like
3 
grep ",Call Forward Not Reachable" *2013* | awk 'BEGIN{OFS=FS=","}; {a=$4; $4=$36; $36=a;}1'
1 Like
4

Come to think of it, if you're using awk, you don't need grep too.

awk '/",Call Forward Not Reachable"/, { T=$4 ; $4=$36 ; $36=T } 1' *2013*
5

Did you mean-

awk -F","  '/",Call Forward Not Reachable"/, { T=$4 ; $4=$36 ; $36=T } 1' *2013*

Input appears to be a csv file.

2 Likes
6 
-bash-3.2$ awk -F","  '/",Call Forward Not Reachable"/, { T=$4 ; $4=$36 ; $36=T } 1' *2013*
awk: /",Call Forward Not Reachable"/, { T=$4 ; $4=$36 ; $36=T } 1
awk:                                  ^ syntax error
7

Excellent!! A very good example of how powerful awk is! :b:

8

I guess that should be the problem!! :slight_smile:

9 
perl -F, -lane '($F[3],$F[35])=($F[35],$F[3]);print join(",",@F);' filename