Shell Programming and Scripting

I have a huge file with lot of rows... with each row around 400 characters.. with spaces as well..

(e.g)
Line1:
"AC254600606 USDMI000001Anom01130073981 0000000000000.002005040720991231 999 NNNNdir01130073981 dir0113007 MEDE DEF CO Y MR. NN "

I wanted to replace the characters from '12 - 22' in each line..
(i.e) old value " USD"
new value " 1100USD"

Can anyone please help me with this.

Thanks in advance.
Gopi

Try:

Code:

perl -pe 's/(?<=.{11}).{11}/    1100USD/' file

Hi,

Thanks for the reply.. The code worked.. but i have a lil diffrent reqt...

Actually.. The lines will contain different values...

Characters in between 12 -22 in each line... i m giving an example below...
OLD Values:

Code:

"        USD"
"        EUR"
"        JPY"
"     USDUSD"
"     INRINR"
"         UN"

New Values:

Code:

"    1100USD"
"    1100EUR"
"    1100JPY"
" 1100USDUSD"
" 1100INRINR"
"     1100UN"

I need to add "1100" just before each of these words within "11 - 22" positions, in each line.... There will be 4 spaces for sure.... but the point is there can be more spaces also.. but i should add "1100" just before the existing word.. and keep the remaining as spaces..
Please help.

Thanks.
Gopi

See if this works for you:

Code:

sed 's/    \([^ ]\)/1100\1/' inp_file

Thanks a ton for this...
It worked...

Code:

sed 's/    \([^ ]\)/1100\1/' File

But i don't understand how it changed exactly in the same position and not in other positions..
Also i have a requirement... where in i have to do such changes in other positions as well...
So please let me know the meaning behind this... as i wanted to replace certain things.. near 150,225 th position's in each line.. in the file..

Thanks in advance..
Gopi

Hi, Gopi

In the future, please take the time to detail the problem in its entirety to the best of your ability in the first post. Doing so will help those that are trying to help you not waste time on suboptimal approaches.

Regards,
Alister

As an example to replace four spaces proceeding the next word from column 150 with a value of "8251", you would do this (Note requires sed that supports the -E option):

Code:

sed -E 's/^(.{150}.*)    ([^ ])/\18251\2/' infile

Input:

Code:

      1         1         1
      4         5         6
...789012345678901234567890123456
---------------------------------
...567484   498.23      EF  funny
...  8484    32.58     FAU  funky
... 14841  1234.60       R  happy

Output:

Code:

      1         1         1
      4         5         6
...789012345678901234567890123456
---------------------------------
...567484   498.23  8251EF  funny
...  8484    32.58 8251FAU  funky
... 14841  1234.60   8251R  happy