Search Results

Original File

slsins,/data/application-nr/slsins/MYRIAD/MYRIAD_RISK_03,10,IEE1
slsins,/data/application-nr/slsins/MYRIAD/MYRIAD_RISK_02,10,IEE1...

Hi ...

It most likely won't ..
Example it could be something like this .. input i mean

level1,/level2/level3/level4/ora001,10,IBB23
level1,/level2/level3/level4/ora002,,IBB24...

Hi ..

level1,/level2/level3/level4/ora003,4,IBB25
level1,/level2/level3/level4/ora003/ddu1,,

In this case ... $4 is not same ... so both lines get copied to file2

Hi ,

I have only tried basic shell looping .. if then else stuff ... was looking for something more efficient as there are more than 20,000 lines


Thanks

Thx ...

my bad ... i edited the question ..

Hi All,

Need some help in parsing a directory listing .. output into 2 files

Input file
level1,/level2/level3/level4/ora001,10,IBB23
level1,/level2/level3/level4/ora001/blu1,,IBB23 ...

Format output with blocks - Awk


ZONESET_A,DBP02_HBA0,DC01,20:00:00:25:b5:b9:a0:28,10,port-channel20,01-VB2
ZONESET_A,DBP02_HBA0,DC01,50:00:14:42:a0:72:74:00,10,fc4/30,O1-CORE-D
...

https://www.unix.com/shell-programming-and-scripting/264504-filter-blocks-awk.html

Can't see it anymore ..

Thanks !

The first one if you please .... thx

Thanks Don ! .. worked as expected ...
I have another question for u .. , not related to above though

Basically wherever there is a ";" in front of or after a field , change it to ...

They may or may not be adjacent .
The output order does not matter .
Linux ,bourne ,gawk ...

Thanks

Input

NJ090237_0263_GRP,NJ090237_0263_VIEW,NJ090237_0263_PSGRP,NJ090237_0263_GOLD_CSGRP,06E:0_08E:0_09E:0_11E:0,0CE5...

Hi Scrutinizer ..

I get this error
gawk: fatal: Unmatched [ or [^: /[][:]/


Do I need to escape something ?

thanks ...

getting this ...


M1_CRE03_SV AM112_A, initiators AM112_A, AM112_B, KEC12_C, ABL12_D, BL13_A, BL13_B, ZBL13_C, ZBL13_D, BL14_A, ZBL14_B, ZBL14_C, BL14_D
M1P5_T2_SV G105_A, initiators...

/clusters/cluster-1/exports/storage-views/M1_CRE03_SV:
Name Value
------------------------ ...

Hi,

for now I am able to replace fields in file1 $3 with any one reference file ..which does not fit the output needed though
$ gawk -F"," 'NR==FNR{a[$2]=$1;next}{for (i in a)...

You are right ... my Bad .. I fixed it ..

basically $2 from ref1 and ref2 will never be same

Thanks

Guys ... need some help with this please
FILE1
XYZ,123,1234_1122,AQQ
XXX,345,5678,FFG
YYY,123,3344_5566_7788,YYTT
UUU,567,7799_1111,RRR
EEE,333,8866,III ref1

ZONE1122_A,1234...

Perfect .... Thx !!

So what does this statement does ?

if (!CNT) SNAME[++CNT]=""

Thx .....works fine ,except for part where "storage-view:" does not exist in the block of data


virtual-volume: device_CLARiiON247_LUN_00696_1_vol (34G, local @ cluster-1, unexported)
...

INPUT FILE


storage-view: PU04B_SV (cluster-1)
storage-view: PU04A_SV (cluster-1)
storage-view: PU03B_SV (cluster-1)
storage-view: PU03A_SV (cluster-1)
storage-view: PU02B_SV (cluster-1)
...

Hi Don ,

Thanks for all the effort ... looks like its working fine ,,,,


I am getting this output ..with the modified FILE2 , which is what I wanted


...

Thanks Don,
it works fine for the above scenario ... but there could be a case in file2 like this


CG01_ds00d11_drs,rs1_ds00d11_0CD3_114D,000566,114D
...

I was using a regular "loop" method ... but wanted to use a simpler AWK version for a bigger file


> /tmp/output
for i in `cat /tmp/file1`
do
VAR1=`echo $i |awk -F, '{print $NF}'`
...

ALL,

Please help with this ...


File1

000433,ds00d11,tdev,ds00d11_view,0CD3
000433,ds00d12_34,tdev,ds00d12_view,132D
File2
CG01_ds00d11_drs,rs1_ds00d11_0CD3_114D,000433,0CD3 ...