UNIX for Advanced & Expert Users

Hi Era,


If "9” is in column 21 and ‘00000000’ in column 123 then i need to Change the ‘00000000’ starting in column 123 to ‘19000101’.
This needs to works irrespective of if there are any spaces or not in the file.

The tried your code and it does not give me the required output.

The file is as below:

0011200ALN00000000009EGYPT 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000062 004O000000000000000000000000000000000000000000000000390440000000000000450140460440000000000000190010 000000000000000000

This is just an example record and spaces vary in the file. But the "9” in column 21 and ‘00000000’ in column 123 remain in the saem positions irrespective of wherever the space is.

Can you please relook into this one.

Will be very helpfull.

If the offsets are different then change them. Based on what you posted before, the script looks for "9" in column 21 and "1999" in columns 42-45 (starting at 42, 4 positions). It's easy enough to change those.

Again, please use code tags when posting examples with significant spaces.

Hi era,

Thanks so much for the quick reply

I made the required chnages as below in ur code:

awk 'substr($0,21,1)==9 && substr($0,123,8)==00000000{print substr($0,0,122) "19000101" substr($0, 131); next }1'

But this does not give me a result.


Can you please guide me on how i can use code tags when posting examples. Sorry but i am using this for the first time.

I linked to this up in my earlier reply: The UNIX Forums - vB Code List

You might need to put the 000000 in double quotes. (My mawk doesn't require that, but it seems like a possible problem.)

Hi era,

I have attached the file to this post.

the file name is 123F.txt

Thanks,
Sandeep

It doesn't give a result because your file has no record that fits the condition.

Hi Era,

Your are correct "" was the issue that was not allowing the file to be chnaged. I made the chnage and it worked.

Thanks a ton

Regards,
Sandeep