UNIX for Dummies Questions & Answers

I just need to print value 12 digit number after the key *MI*. My big concern is the below lines are not fixed format or length so cant cut based on the position.


XSA*00**00**XZ*DA-Paper*30*942411167****MI*010001990802~AEE
XSA*00**00**ZZ*EA-aper*30*94169****MI*010001960802~SDRE*ER
SSA*00**00**CZ*BA-Paper*30*2411167****MI*010001790802~AD*a*
XSA*00**00**ZZ*DA-Raper*30*942167****MI*010001980802~A*c8*
XSA*00**00**ZA*DA-Raper*30*9424111****MI*010001880802~ae*ae

Basically I need the output as
*010001990802~
*010001960802~
*010001790802~
*010001980802~

Thanks in advance

Code:

awk -F'MI|~' '{print $2"~"}' file

Or if you need just the numbers:

Code:

awk -F'MI[*]|~' '{print $2}' file

Thanks Rubin !!! It works !!!



I have the file size of few 100 MB's. and I am getting error

awk: Input line TransformUtils trans cannot be longer than 3,000 bytes

Is there any workaround for this problem ?


I really appreciate your help...

I see ..., most likely you're running an old version of awk, maybe you can use a different tool like cut or sed, that might support more bytes in the input line.

Try with Perl:

Code:

perl -nle'print/\*MI(\*.*?~)/' file

this might work..
not sure as its not tested

Code:

sed -e 's/\(\*MI\)\(\*.*~\)/\2/g' filename

Thank you. It works