Shell Programming and Scripting

I need to replace dashes (i.e. -) if present from positions 351-357 with zero (i.e. 0), I also need to replace dash (i.e “-“) if present between position 024-043 with zero (i.e. 0) & I replace " " (i.e. 2 space characters) if present at position 381-382 with "04". Total length of record is 413.
Here is the example of the one record
B123456Aero 12345678901234-1234 abcd Abcdef 1234 Abc Rd Ste 1 Abc Treak WI12345 0000123 0-1234567890 000000000
B223456Bero 09876543214321-2345 abcd Abcdef 1234 Abc Rd Ste 1 Abc Treak WI12345 0000123 002345678901 02 000000000
B323456Cero 23456789012345-3236 abcd Abcdef 1234 Abc Rd Ste 1 Abc Treak WI12345 0000123 00-456789012 000000000
B423456Dero 32345678901234-4237 abcd Abcdef 1234 Abc Rd Ste 1 Abc Treak WI12345 0000123 004567890123 01 000000000

any help on this will be appreciated.
Thanks in advance.

How long is the longest record.
What OS and shell are you using? (some tools are limited as to the max size of a record)

The OS used is redhat linux and every record length = is 421. We are using bash shell.

Code:

awk -F "" '{for(i=1;i<=NF;i++){if((i>=351 && i<=357) || (i>=24 && i <=43)){gsub("-","0",$i);} else if(i>=381 && i<=382){gsub("  ","04",$i);}}}1' OFS="" input_file

Hey msabhi,
awk '{if((NR>=351 && NR<=357) || (NR>=24 && NR <=43)){gsub("-","0");} else if(NR>=381 && NR<=382){gsub(" ","04");}}1' input_file
is not working.
We need to replace character - (i.e. dash) with 0 if exist between position 351 to 357. we also need to replace character - (i.e. dash) with 0 if exist between position 24 to 43. And we also need to replace two blank characters " " with 04 if exist between position 381 to 382 in same record. Each record length is 413.
I have attached input file with this thread. If we open this file with notepad++ or any other editor we can see presence of dashes at 351 to 357 & 24 to 43. for some or all records and presence " " at 81 to 382 for some records.
Thanks for you help in advance.

Hi msabhi,

I think lancesunny is talking about position of the string..

so NR can be used like this...

i know this is not the efficient way..
try..

Code:

while read line
do
echo "$line" | sed -e 's/.\{1\}/&\n/g' | awk '{if((NR>=351 && NR<=357) || (NR>=24 && NR <=43)){gsub("-","0");} else if(NR>=381 && NR<=382){gsub("  ","04");}}1' | paste -sd ""
done<file

I got you guys pamu and lancesunny
my vision

Lancesunny : I have updated new untested code in my previous post...Can you please check once..