Replace a value using a reference data from other file
Gents,
Can you please help me to solve this case
In my input file I have a values in column 49 which always need to be one, but sometimes the system create a value 2, in this case I need to go to search in the original file and replace the values in the row where the value 2 is and in the previous.
Example input file
Code:
X 4708 3310 69521.00 19353.001 932 9331 69668.00 19572.00 19574.001
X 4708 3310 69521.00 19353.001 934 9352 69668.00 19576.00 19576.001
The situation is when the value in column 49 changes to value = 2, then I need to change some values in row where it is value 2 and previous row.
changes need to be done in previous row , column 46 , 72
next row , column 41, 49, 52
using the values in original file.
Values in original file
Code:
X 69523.00 19353.001 932 9341 69668.00 19572.00 19576.001
X 69523.00 19353.001 935 9351 69680.00 19576.00 19576.001
Desire output file
Code:
X 4708 3110 69523.00 19353.001 932 9341 69668.00 19572.00 19576.001
X 4708 3110 69523.00 19353.001 935 9351 69680.00 19576.00 19576.001x
OK I will do my best to explain what I need help with.
I am trying to format an ldif file so I can import it into Oracle oid.
I need the file to look like this example. Keep in mind there are 3000 of these in the file.
changetype: modify
replace: userpassword
dn:... (0 Replies)
Hi All,
I have two files one of which having some mobile numbers and corresponding value whose sample content as follows:
9058629605,8.0
9122828964,30.0
And in second file complete details of all mobile numbers and sample content as follows and delimeter used is comma(,):
... (8 Replies)
Dears,
I'm new to shell scripting and i was wondering if you can help me with following matter.
I have a file containing 400,000 records. The file contains two columns like:
00611291,0270404000005453
25262597,1580401000016155
25779812,1700403000001786
00388934,1200408000000880... (1 Reply)
Dear All,
I am struggling with the following task and would appreciate some help. I have a large table (file1.txt). The first column of this table contains an ID. I would like to replace the ID with a label according to a reference file.
Here is an example:
cat infile.txt
0 AJ2312 310 ... (7 Replies)
Basically want to replace any field in input file from the refernce file ...
for example.
clar_2400:3113 in input file will be replaced by clar_2400:3113
Input file field seperator is ","
Field which is not found in reference will stay as it is ...
Input File
... (3 Replies)
Gents,
Please can you help with this.
I have a big file (file2) which contends many records increment every 25 rows ( column 1 ).
Then I have other file as reference (file1).. column 1 to 11.
I want to compare that all values in file2 (column 2 to 12.) match with values in... (2 Replies)
Hi,
I'd be grateful for your help with the following:
I have a file with a single column (file1). Let's say the values are:
a
b
c
5
d
I have a second, reference file (ref_file), which is colon-delimited, and is effectively a key. Let's say the values in it are:
a:1
b:2
c:3
d:4... (4 Replies)
11-24-2014
