Search Results

A bit of Perl

perl -plaF'\|' -e '$F[-1] =~ s/(\d+)/$F[3]$1/g; s/[\d,]+$/$F[-1]/' file.txt
USS|AWCC|AFGAW|93|9370
USSAA|Roshan TDCA|AFGTD|93|9372,9379
ALB|Vodafone|ALBVF|355|35569...

$ awk -F"|" -v OFS="|" ' $NF { $NF=","$NF; gsub(",",","$(NF-1),$NF); sub(",","",$NF) } 1 ' file
USS|AWCC|AFGAW|93|9370
USSAA|Roshan TDCA|AFGTD|93|9372,9379
ALB|Vodafone|ALBVF|355|35569...

Hello umarsatti,

Following is the explanation for same.

awk -vs1="," -F"|" '{ ######## taking a variable named s1 whose value is comma(,) and setting field separator to |
A=$(NF-1); ...

Since for index in array_name produces the index list in an unspecified order, the order of the output subfields will not necessarily be in the same order as the subfields in the input when using...

Hello umarsatti,

Could you please try following and let me know if this helps.

awk -vs1="," -F"|" '{A=$(NF-1);split($NF, B,",");for(i in B){C=C?C s1 A B[i]:A B[i];$NF=C;}C=""} 1' OFS="|" ...

Given that RavinderSingh13 interpreted your new data file correctly, this might work as well:sed 's/ *:.*:SSN: /,/; s:/KEYVALUE>::' file

---------- Post updated at 19:47 ---------- Previous update...

Note: --re-interval is a GNU command line option so that interval expressions ({m.n}) can be used with GNU awk 3 or lower.
It is not needed with GNU awk 4 and up. It will not work will other awk's....

Hello umarsatti,

Seems your attachment provided Input_file is having different input values compare to sample shown in your very first post, following may help you in same.

awk --re-interval...

Hello umarsatti,

Following may help you in same.

awk --re-interval '{match($0,/[0-9]{12}+/);B=substr($0,RSTART,RLENGTH);match($0,/RemoteSPC: [0-9]+/);print B OFS...

Please use code tags https://www.unix.com/images/editor/code.png, not icode https://www.unix.com/images/icode.png tags for multiline code samples.

What have you tried so far?

---------- Post...

Use nawk on Solaris.

Hello Umar
I really admire your enthusiasm for shell scripting and thanks for your contribution towards this forum. you can solve this by putting following in crontab:

bash -l script

use awk, if you dont have nawk


$ nawk '/Node/,/<\/Node/{if($0~/Apple/)a=1;}{if($0~/Value3/ && a){sub("Value3","Value4");a=0}}1' test.txt
<Node>Apple
<B>Value1</B>
<B>Value2</B>...