Replace dashes positions 351-357 & 024-043 with 0 & replace " " if exis with 04 at position 381-382 Post: 302708281

Sponsored Content

Top Forums Shell Programming and Scripting Replace dashes positions 351-357 & 024-043 with 0 & replace " " if exis with 04 at position 381-382 Post 302708281 by lancesunny on Monday 1st of October 2012 10:40:18 AM

10-01-2012

Registered User

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.

InputFile.zip (340 Bytes)

Last edited by lancesunny; 10-01-2012 at 11:55 AM..

lancesunny

View Public Profile for lancesunny

Find all posts by lancesunny

10 More Discussions You Might Find Interesting

1. What is on Your Mind?

[[ $(date +%Y) == 2007 ]] && echo "Happy New Year"

Same as the Title! :)

2. Shell Programming and Scripting

How to replace "\&" with "&"?

I want to remove the backslash in the front of &, and want to use gsub, how to do that? echo "Free \& Long" | awk '{gsub(/\\&/, "&"); print}' This one is not working, and I think it takes the second "&" in gsub as the substitute of "\\&". Thanks a lot!

3. Shell Programming and Scripting

Append && echo "success" to all commands

I am learning to build from SVN and other tools, with a lot of copying and pasting from forums. I like to append && echo "success" to all commands so that I can see at a glance if things went all right. Is there a way that I can have the bash shell append this to all commands? Thanks!

4. Shell Programming and Scripting

What does this really mean? "tty -s && stty istrip"

I am having hard time understanding what this really do to the environment? I do understand this part "tty -s && stty " but not "istrip" # stty command is executed only if a tty is attached to the process. # stty istrip : Strip input characters to 7 bits tty -s && stty istrip I am...

5. Shell Programming and Scripting

awk command to replace ";" with "|" and ""|" at diferent places in line of file

Hi, I have line in input file as below: 3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL My expected output for line in the file must be : "1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL" Can someone...

6. UNIX for Dummies Questions & Answers

replace """ with "&"

I'm trying to replace the string """ with "&". I have tried this: echo """ | sed 's/"/&/g' Is it impossible for sed and awk to output "&"?

7. Red Hat

files having Script which works behind "who" & "w" commands

Dear All, plz print the path of files which have the script of "who" & "w" commands. thnx in advance.

8. Shell Programming and Scripting

Remove dashes if exist between positions 351-357 and then add - at the 357th position

I need to remove dash (i.e. -) if present from positions 351-357, and then add - (dash) at 357th position. For example in following first and 3rd record we got Before processing 1) 1st Record positions 351-357 = 0-12345 2) 3rd Record positions 351-357 = 00-4567 After processing:- 1) 1st...

9. Shell Programming and Scripting

finding the strings beween 2 characters "/" & "/" in .txt file

Hi all. I have a .txt file that I need to sort it My file is like: 1- 88 chain0 MASTER (FF-TE) FFFF 1962510 /TCK T FD2TQHVTT1 /jtagc/jtag_instreg/updateinstr_reg_1 dff1 (TI,SO) 2- ...

10. Shell Programming and Scripting

How to replace multiple " " entry with in <td> tag into single entry using sed?

I have the input file like this. Input file: 12.txt 1) There are one or more than one <tr> tags in same line. 2) Some tr tags may have one <td> or more tna one <td> tags within it. 3) Few <td> tags having "<td>   </td>". Few having more than one " " entry in it. <tr> some td...

10 More Discussions You Might Find Interesting

1. What is on Your Mind?

[[ $(date +%Y) == 2007 ]] && echo "Happy New Year"

Discussion started by: ripat

2. Shell Programming and Scripting

How to replace "\&" with "&"?

Discussion started by: freelong

3. Shell Programming and Scripting

Append && echo "success" to all commands

Discussion started by: dotancohen

4. Shell Programming and Scripting

What does this really mean? "tty -s && stty istrip"

Discussion started by: kchinnam

5. Shell Programming and Scripting

awk command to replace ";" with "|" and ""|" at diferent places in line of file

Discussion started by: shis100

6. UNIX for Dummies Questions & Answers

replace """ with "&"

Discussion started by: locoroco

7. Red Hat

files having Script which works behind "who" & "w" commands

Discussion started by: saqlain.bashir

8. Shell Programming and Scripting

Remove dashes if exist between positions 351-357 and then add - at the 357th position

Discussion started by: lancesunny

9. Shell Programming and Scripting

finding the strings beween 2 characters "/" & "/" in .txt file

Discussion started by: Behrouzx77

10. Shell Programming and Scripting

How to replace multiple " " entry with in <td> tag into single entry using sed?

Discussion started by: thomasraj87