Looking into file !


Login or Register for Dates, Times and to Reply

 
Thread Tools Search this Thread
# 1  
MySQL Looking into file !

Hi All,

I am in a situation wherein I have one look-up file or say mapping file which has two columns of data , suppose:

LookupFile.txt:
col1 col2
6589 7879
8787 0909
4343 4576

Now in the file which has to be processed has following format:

to_be_processed_file.txt
col1 col2 col3
676787989800996589 65656576687878
788757657675768787 88787878756446
323247656876984343 42341242542345

Now suppose in row 1 I need to append 6589 with respective value from mapping file i.e 7879. Similarly 8787 should be replaced as 0909.
The new value should fill the space in the col2:
So after processing it should look like this:

col1 col2 col3
6767879898009965897879 65656576687878
7887576576757687870909 88787878756446
3232476568769843434576 42341242542345

Kindly Help !
# 2  
are all the value in column1 of 'LookupFile.txt' of the same 4-character length OR can they all be of different length?
# 3  
given a 4-character lookup key in the 'LookupFile.txt' file...
nawk -f rahul.awk LookupFile.txt to_be_processed_file.txt

rahul.awk:
Code:
FNR==NR {f1[$1]=$2; next}
{
  s=substr($1, length($1)-3)
  if ( s in f1)
     $1 = $1 f1[s]
}
1

# 4  
lookup key is of length 10 and it does not vary , will this work then ?
# 5  
Quote:
Originally Posted by rahul303
lookup key is of length 10 and it does not vary , will this work then ?
Code:
FNR==NR {f1[$1]=$2; next}
{
  s=substr($1, length($1)-9)
  if ( s in f1)
     $1 = $1 f1[s]
}
1

# 6  
If tried getting character 28 to 37 from column:
s= substr($1,28,10)
This didn't work:
As I need to replace character 28to 37 in first column with value from mapping file.
Plz help !
# 7  
Quote:
Originally Posted by rahul303
If tried getting character 28 to 37 from column:
s= substr($1,28,10)
This didn't work:
As I need to replace character 28to 37 in first column with value from mapping file.
Plz help !
this is different requirement with no sample input and desired output - replacing is not the same as 'suffixing' .pls provide both
Login or Register for Dates, Times and to Reply

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #55
Difficulty: Easy
The term UPS stands for 'Universal Power Source'.
True or False?

3 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell script (sh file) logic to compare contents of one file with another file and output to file

Shell script logic Hi I have 2 input files like with file 1 content as (file1) "BRGTEST-242" a.txt "BRGTEST-240" a.txt "BRGTEST-219" e.txt File 2 contents as fle(2) "BRGTEST-244" a.txt "BRGTEST-244" b.txt "BRGTEST-231" c.txt "BRGTEST-231" d.txt "BRGTEST-221" e.txt I want to get... (22 Replies)
Discussion started by: pottic
22 Replies

2. Shell Programming and Scripting

Compare 2 text file with 1 column in each file and write mismatch data to 3rd file

Hi, I need to compare 2 text files with around 60000 rows and 1 column. I need to compare these and write the mismatch data to 3rd file. File1 - file2 = file3 wc -l file1.txt 58112 wc -l file2.txt 55260 head -5 file1.txt 101214200123 101214700300 101250030067 101214100500... (10 Replies)
Discussion started by: Divya Nochiyil
10 Replies

3. Shell Programming and Scripting

Match list of strings in File A and compare with File B, C and write to a output file in CSV format

Hi Friends, I'm a great fan of this forum... it has helped me tone my skills in shell scripting. I have a challenge here, which I'm sure you guys would help me in achieving... File A has a list of job ids and I need to compare this with the File B (*.log) and File C (extend *.log) and copy... (6 Replies)
Discussion started by: asnandhakumar
6 Replies

Featured Tech Videos