Ggtcf

I have a file with 2k data as below .I want to get only number values of updr/udrl/imgr/imgl fields as 41110.00 120 996.00 523 with tab separated where updr/updl/imgr/imgl fileds present.

I have tried with single pattern replacement till brackets but after that not able to apply another pattern to get numbers.

echo `sed -n 's/^[.*][^0-9]*[[:space:]]* //p' client_stat.txt > client_stat_onlyData.csv` ; echo `sed -i 's/ /t/g' client_stat_onlyData.csv`

I am getting o/p as like below but i do not want to print udpr/updl/imgr/imgl strings i want to print only number values.

updr 48358.00 updl 120 imgr 1015.00 imgl 523
updr 48562.00 updl 120 imgr 1169.00 imgl 523
updr 48305.00 updl 121 imgr 1210.00 imgl 523
updr 48285.00 updl 121 imgr 1135.00 imgl 523
updr 48459.00 updl 121 imgr 1210.00 imgl 523
updr 48246.00 updl 120 imgr 881.00 imgl 523
updr 48439.00 updl 120 imgr 1109.00 imgl 523

Number of Connection Count = 1
Creating RSSL connection Host: 192.168.120.1 Port: 14002
UPA server component version: ads3.2.2.L1.linux.tis.rrg 64-bit
Setting rmds connection 0x10a8900
Connection list count is 1
SupportStandby: 0
SupportBatchRequests Initial Open: Yes
SupportBatchRequests Reissue: Yes
SupportBatchClose: Yes
SupportViewRequests: Yes
SupportOptimizedPauseResume: 0

[Tue Feb 19 14:42:50.415] updr 41110.00 updl 120 imgr 996.00 imgl 523
 [Tue Feb 19 14:42:51.415] updr 49368.00 updl 121 imgr 845.00 imgl 523

Status Received <388> Status Text: Stale Status for Item REC1000017 Text: F7: Item Preempted
[Tue Feb 19 14:42:52.415] updr 48542.00 updl 121 imgr 1170.00 imgl 523

Status Received <1166> Status Text: Stale Status for Item REC1000410 Text: F7: Item Preempted
[Tue Feb 19 14:42:53.415] updr 47942.00 updl 120 imgr 1133.00 imgl 523

Status Received <1133> Status Text: Stale Status for Item REC1001609 Text: F7: Item Preempted
[Tue Feb 19 14:42:54.415] updr 48513.00 updl 120 imgr 1100.00 imgl 523

Could you please try following(it will show the number next to strings whichever OP mentioned to search for).

awk 'for(i=1;i<=NF;i++)if($i ~ /^(updr;print val;val=""' Input_file

Or adding a non-one liner form of solution.

awk '

 for(i=1;i<=NF;i++)
 if($i ~ /^(updr
 print val
 val=""

' Input_file

In case you want to save output ito Input_fie itself append > temp_file && mv temp_file Input_file in above code. Also in case your Input_file is TAB delimited and you want to have output as TAB delimited format then change awk to awk 'BEGINFS="OFS="t" keep from {for.... code as it is as mentioned above.

Explanation: Adding explanation for above code.

awk ' ##Starting awk program here.
 ##Startig conditions BLOCK here.
 for(i=1;i<=NF;i++)imgr ##Closing BLOCK for for loop here.
 print val ##Printing value of variable val here.
 val="" ##Nullifying variable val value here.
 ##Closing main BLOCK now.
' Input_file ##Mentioning Input_file name here.

EDIT: Example of run of code.

awk 'for(i=1;i<=NF;i++)if($i ~ /^(updr;print val;val=""' Input_file
48358.00 1015.00 523
48562.00 1169.00 523
48305.00 1210.00 523
48285.00 1135.00 523
48459.00 1210.00 523
48246.00 881.00 523
48439.00 1109.00 523

Using Perl one-liner

 perl -ne ' while( /(updr|udrl|imgr|imgl)s+(S+)/g ) print "$2 " print "n" ' file

with your given inputs

$ cat vijaya.txt
updr 48358.00 updl 120 imgr 1015.00 imgl 523
updr 48562.00 updl 120 imgr 1169.00 imgl 523
updr 48305.00 updl 121 imgr 1210.00 imgl 523
updr 48285.00 updl 121 imgr 1135.00 imgl 523
updr 48459.00 updl 121 imgr 1210.00 imgl 523
updr 48246.00 updl 120 imgr 881.00 imgl 523
updr 48439.00 updl 120 imgr 1109.00 imgl 523

$ perl -ne ' while( /(updr|udrl|imgr|imgl)s+(S+)/g ) print "$2 " print "n" ' vijaya.txt
48358.00 1015.00 523
48562.00 1169.00 523
48305.00 1210.00 523
48285.00 1135.00 523
48459.00 1210.00 523
48246.00 881.00 523
48439.00 1109.00 523

$