Need help on find and replacement on specific line and position


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need help on find and replacement on specific line and position
# 15  
Old 01-16-2014
Quote:
Originally Posted by Chubler_XL
How about this:

Code:
awk '
    BEGIN{
      F="ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123446789"
      T="ZYXWVUTSRQPONMLKJIHGFEDCBAzyxwvutsrqponmlkjihgfedcba9876443210"
      for(i=1;i<length(F);i++)N[substr(F,i,1)]=substr(T,i,1);
    }
    NR == 18 {
      out=x
      for(i=1;i<length;i++) {
         c=substr($0,i,1)
         out=out (i>10&&(c in N)?N[c]:c)
      }
      $0=out
    }
    1
' infil



Based on ur code

the output is

NM1*IL*1*LBMXSDROORZNNRI97914


Where the * ( stars) ? it should be unchanged .. alpha should be alpha and numbers should be numbers.
# 16  
Old 01-16-2014
Yes found that Issue and corrected the posted code - please try again
This User Gave Thanks to Chubler_XL For This Post:
# 17  
Old 01-16-2014
Quote:
Originally Posted by Chubler_XL
Yes found that Issue and corrected the posted code - please try again
it works. thanks a lot !

---------- Post updated at 05:29 PM ---------- Previous update was at 04:29 PM ----------

Quote:
Originally Posted by Chubler_XL
Yes found that Issue and corrected the posted code - please try again
sorry to bother you again. Do you have any restriction in your code on maximum length in file

My input

N3*PO BOX 4703


ouput is

N3*KL YLC 529


Note : in this im converting from 4 th position to rest of the line

Code:
awk  -v k3="$k3" '
    BEGIN{
      F="ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789"
      T="ZYXWVUTSRQPONMLKJIHGFEDCBAzyxwvutsrqponmlkjihgfedcba9876543210"
      for(i=1;i<length(F);i++)N[substr(F,i,1)]=substr(T,i,1);
    }
    NR == k3 {
      out=x
      for(i=1;i<length;i++) {
         c=substr($0,i,1)
         out=out (i>3&&(c in N)?N[c]:c)
      }
      $0=out
    }
    1
' $file


Last edited by Rajesh_us; 01-16-2014 at 07:37 PM..
# 18  
Old 01-16-2014
Many versions of awk limit the length of a line to LINE_MAX bytes. The value of LINE_MAX on your system can be found using getconf LINE_MAX). But it looks like there is an off by one error that is causing your problem here. Try changing:
Code:
      for(i=1;i<length;i++) {

to:
Code:
      for(i=1;i<=length;i++) {

This User Gave Thanks to Don Cragun For This Post:
# 19  
Old 01-16-2014
Quote:
Originally Posted by Don Cragun
Many versions of awk limit the length of a line to LINE_MAX bytes. The value of LINE_MAX on your system can be found using getconf LINE_MAX). But it looks like there is an off by one error that is causing your problem here. Try changing:
Code:
      for(i=1;i<length;i++) {

to:
Code:
      for(i=1;i<=length;i++) {

i think i got what i need for

but i noticed 9 remains same

Input )
Code:
NM1*IL*1*AYNCH*AILLIAM****AI*R02089540

outpu )
Code:
NM1*IL*1*ZBMXS*ZROORZN****ZR*I97919459

Moderator's Comments:
Mod Comment Please use CODE tags. Trying to line up input and output is hard enough without the problems caused by variable width fonts used outside of CODE tags.

Last edited by Don Cragun; 01-16-2014 at 11:13 PM.. Reason: Add CODE tags again.
# 20  
Old 01-16-2014
So there were two off by one errors. Also change:
Code:
      for(i=1;i<length(F);i++)N[substr(F,i,1)]=substr(T,i,1);

to:
Code:
      for(i=1;i<=length(F);i++)N[substr(F,i,1)]=substr(T,i,1);

This User Gave Thanks to Don Cragun For This Post:
# 21  
Old 01-16-2014
Very Very thanks don cragun ! you guys rocks like anyhting.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Count specific character of a file in each line and delete this character in a specific position

I will appreciate if you help me here in this script in Solaris Enviroment. Scenario: i have 2 files : 1) /tmp/TRANSACTIONS_DAILY_20180730.txt: 201807300000000004 201807300000000005 201807300000000006 201807300000000007 201807300000000008 2)... (10 Replies)
Discussion started by: teokon90
10 Replies

2. Shell Programming and Scripting

Remove line break at specific position

Hi, I need to remove line breaks from a file, but only the ones at specific position. Input file: this is ok this line is divided at posit ion 30. The same as this one, also position 30 the rest of lines are ok with different lengths The longest ones are always s plitted at same... (15 Replies)
Discussion started by: qranumo
15 Replies

3. Shell Programming and Scripting

Find and replace with 0 for characters in a specific position

Need command for position based replace: I need a command to replace with 0 for characters in the positions 11 to 20 to all the lines starts with 6 in a file. For example the file ABC.txt has: abcdefghijklmnopqrstuvwxyz 6abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz... (4 Replies)
Discussion started by: thangabalu
4 Replies

4. Shell Programming and Scripting

How to concatene files and put each line of files on a specific position ?

Hi, I have some files that i want to concatene and put each of lines of this files on a specific position : File1 AAAAAAA BBBBBBB CCCCCCC File2 DDDDDDD EEEEEEE FFFFFFF File3 GGGGGG HHHHHH IIIIII New file (6 Replies)
Discussion started by: apippo70
6 Replies

5. Shell Programming and Scripting

Printing characters at specific position in line

Hi, I am trying to get an output like : +----------------------------------+ ----------- + + some variable substitution + some text + Is there a way I can specify in printf (in ksh) the particular position I want to print a character, and also repeat a character from... (1 Reply)
Discussion started by: neil.k
1 Replies

6. Shell Programming and Scripting

Find the position of a pattern on a line from a csv file

hello I'm doing a unix program and i'm using many file csv.in each csv file the colums are separated by ";" I would like to know the position of a pattern. For example for a line yyyy, bbbb, cccc; ddddd;eeee. I will like for example by finding the position of the pattern "cccc" and the response is... (6 Replies)
Discussion started by: papis
6 Replies

7. Shell Programming and Scripting

Search in specific position and print the whole line

I have two files abc.dat and sant.dat (Big file 60k rows) for every line's 1,4 of abc.dat need to seach if this is present on 28,4 of sant.dat every line. if its present the output needs to go to bde.dat Example: contents abc.dat aaaa bbbb cccc dddd contents sant.dat this is... (4 Replies)
Discussion started by: ssantoshss
4 Replies

8. Shell Programming and Scripting

search a line and insert string into specific at position

Hi, guys. I have one question: How can I search for a line with certain string in it and then insert a string into this line? For example: There is a file called shadow, the contents of it are below: ************************** ... yuanz:VIRADxMsadfDF/Q:0:0:50:7:::... (9 Replies)
Discussion started by: daikeyang
9 Replies

9. Shell Programming and Scripting

Deleting Characters at specific position in a line if the line is certain length

I've got a file that would have lines similar to: 12345678 x.00 xx.00 x.00 xxx.00 xx.00 xx.00 xx.00 23456781 x.00 xx.00 xx.00 xx.00 xx.00 x.00 xxx.00 xx.00 xx.00 xx.00 34567812 x.00 xx.00 x.00 xxx.00 xx.00 xx.00 xx.00 45678123 x.00 xx.00 xx.00 xx.00 xx.00 x.00 xxx.00 xx.00 xx.00 xx.00 xx.00... (10 Replies)
Discussion started by: Cailet
10 Replies

10. Shell Programming and Scripting

check position of end of line for some specific lines

-------------------------------------------------------------------------------- Have to check in a file that the lines starting with 620 and 705 are ending at same posiotin. 82012345 62023232323 70523949558 62023255454 9999 In the above lines, i have to check the lines starting... (1 Reply)
Discussion started by: senthil_is
1 Replies
Login or Register to Ask a Question