I have a bit of a complex problem that I would like to solve with
. It is essentially a 2-part problem.
I have a large directory of files with the same format, each with 266 lines.
The first 206 lines of each file are filled with attribute information.
Then the following 60 lines consist of 202 values separated by commas.
The first position in each of these sixty lines is a word (string value), and the last position in each of these sixty lines is a number (1 or 0).
Is it possible to change the last slot ($202) numeric value of lines that contain certain strings that are indicated in a separate file?
To visualize the problem.
My data file looks like this:
I have a second file with a list of words (1 per line):
I want to change the final numeric value on those lines that contain a word in the second file to 0, so that my file result is:
Is this possible to do with
? Any suggestions of how to tackle this problem?
Perhaps something like this:
which I found HERE can be modified?
Last edited by owwow14; 10-16-2014 at 07:09 AM..
Reason: formatting - add information
Hi Shell Tigers,
I am trying to acheive search and replace strings within a setup file.
Help much appreciated.
test.setup
ORACLE_HOME=/oracle/product/11.0.0/home01
PATH1=/perm_loc/3222/FTP/cfg1
PATH2=/perm_loc/3222/FTP/cfg2/bin
PATH3=/perm_loc/3222/FTP/cfg3/bin
So... (3 Replies)
I have a file which requires modification via a shell script.
Need to do the following: 0. take input from user for new text. 1. search for a keyword in the file. 2. going forward, search for another keyword. 3. Replace this line with user supplied input.
for e.g., my file has the following... (6 Replies)
Hi,I have 2 files master.txt & reference.txt as shown below & i require o/p as mentioned in file 3 using awk but content is not replacing properlymaster.txt:... (15 Replies)
Hello.
I have written the following script to search and replace from one file into another.
#awk script to search and replace from file a in file b
NR == FNR { A=$2; next }
{ for( a in A ) sub(a, A)}1 file2 file1
While the function works pretty well, I want
a. The word in File 2 to... (8 Replies)
I am writing a c++ program that has many calls of pow(input,2). I now realize that this is slowing down the program and these all should be input * input for greater speed.
There should be a simple way of doing this replacement throughout my file with awk, but I am not very familiar with awk.... (2 Replies)
Suchen und Ersetzen mit AWK
hello,
i'm not good in scripting and asking for your help.
With this script i change some text parts in diffent datafiles. It works without problems, but i need to get some informations about what changes in wich datafiles happend. This could be in character of a... (3 Replies)
Hi, I am really confused with this problem that I am facing .
I have a file that contains entries in the form :
option1 Value1
option2 Value2
option3 Value3
option4 Value4
.
.
.
I want to search for the keyword "option4" and replace "value4" by another value, say "value5".
My main... (2 Replies)
Hello,
I really would appreciate some help with a bash script for some string manipulation on an SQL dump:
I'd like to be able to rename "sites/WHATEVER/files" to "sites/SOMETHINGELSE/files" within the sql dump.
This is quite easy with sed:
sed -e... (1 Reply)
Dear All,
I want to search and replace the text in file using awk. but facing hard luck in that.
Please help me out!!!!
> grep Abc.De.ync.rate /tmp/sdosanjh.txt
Abc.De.ync.rate 6 write
Now, I want to replace the "6" with value say "2".
I... (5 Replies)
Hi,
I have been trying to use awk with variables that needs to search for a pattern and replace it with another pattern, the patterns are supplied in a variable. I have tried several different ways without success and hope that someone can help me. Here are the details
echo $UPC
07007457809... (2 Replies)