Shell Programming and Scripting

Hi,

I have data which is having '|' as delimiter and have lobfilename/locations in the data.
Ex:

Code:

1200|name1|lobfilename.0.600|abcd
1201|name2|lobfilename.600.1300|abcd

My requirement is to print part of the line till the lobfilename and write to a different file and also print the remaining part
So output should be

Code:

1200|name1|abcd
1201|name2|abcd

This lobfilename column can be variable- it could be in the middle of the data or the end of the data for different files.
So I want to be able to write a generic script to identify the no. of the lobfilename column (n) and print everything upto that point (1 to n-1 columns data) and also after the lobfilename column (n+1 till end of data) for all lines in the file.
Could you please help me with the same ?

What defines the lob field?
Is it the existence of
text.number.number ?

Hi Joeyg,

Yes, lobfield is defined by lobfilename.lob.<startposition>.<length>
startposition and length is the substr of chars in the actual lobfile.

Code:

 $ ruby -F"\|" -ane 'puts $F.select{|x|!x[/^lobfile/]}.join("|")' file 
1200|name1|abcd 
1201|name2|abcd

Code:

nawk -F"\|" '{x=$1;for(i=2;i<=NF;i++){x=($i~/^lob.*\.[0-9]+\.[0-9]+$/)?x:x FS $i};print x}' infile