Need to find a string, check the next line, and if it matches certain criteria, replace it with a s
Hey Fellas.
I am new to scripting. I have searched through the forums and found a lot of good info, but I can't seem to get any of it to work together. I am trying to find a particular sting in a file, and if the next string matches certain criteria, replace it with a string from a csv file. Roughly about 1500 times in the file. I have been trying to do this with awk/sed, but i haven't had the best of luck.
example:
find the string that starts with data7
if the string on the next line has the word prisoner then replace it with the string in line one on the csv file.
the next instance of the pattern would be replaced by the string in line 2 of the csv file. and so on.
the word prisoner appears multiple times in the file, but i only want to replace the ones that directly follow the string containing "data7"
does this make sense?
When i say i'm brand new to scripting i mean BRAND new. I'm taking some classes, but i need to get this done as soon as possible and what i have learned so far hasn't gotten me much closer. any help ya'll can give would be greatly appreciated.
Thanks!
I don't have my linux box handy, and thats where all my code snippets are, i'll post them when i get home tonight. Here are some examples of the files:
File 1:
i don't have a copy of the csv file yet. as far as i know it will only consist of two columns.
There will be about 1500 instances that will need changed, if not more.
I appreciate the quick replies, I'll post the code that i have as soon as i get home tonight.
Thanks again
Thanks FRANS! This looks a lot simpler than I thought it would be. I'll try it out as soon as i get on my linux box.
I for the most part understand whats happening here. Could you explain the purpose of the ":0:5" in this line? I found what the curly brackets do, but as of yet, not the colons.
Thanks for all the help!
---------- Post updated at 12:05 PM ---------- Previous update was at 10:43 AM ----------
As far as samples go, i have a file (format unknown). There are about 15000 lines or so that contain the word "prisoner". Each prisoner will be assigned a number that will be pulled from a .csv file. The input file looks like this (only right around 44000 lines long):
The output would then look something like this:
Notice that only the "prisoner" string underneath the "Type: SystemDeclarationData;7" string changed.
The .csv file will end up being either a one or two column file depending on whether or not they want names along with the numbers.
I don't know if that helps or not. don't have much to contribute as far as a real sample goes at the moment. They pretty much gave me basic structure, a goal, and said have fun. heh.
---------- Post updated at 01:03 PM ---------- Previous update was at 12:05 PM ----------
Frans:
We are on the right track!! I modified the scropt that you posted a little bit:
The only problem i'm having is that it's deleting the line that contains "SystemDeclarationData". otherwise it's working great. can you tell me what i'm doing wrong?
Thanks FRANS! This looks a lot simpler than I thought it would be. I'll try it out as soon as i get on my linux box.
I for the most part understand whats happening here. Could you explain the purpose of the ":0:5" in this line? I found what the curly brackets do, but as of yet, not the colons.
it extracts 5 characters from position 0 (the first)
Quote:
The only problem i'm having is that it's deleting the line that contains "SystemDeclarationData". otherwise it's working great. can you tell me what i'm doing wrong?
The script is wrong i'll modify it to work properly.
In a couple of minutes, OK?
The script
Last edited by frans; 11-16-2009 at 02:37 PM..
Reason: script provided
I got it working with an echo command. essentially, i guess both are doing the same thing, just outputting in a different format?. Yours is a whole lot cleaner!! heh. I can't thank you enough for the help. Credit goes to you my friend!
I have a list of value , and need to replace that in my file.
Eg:
File1
tcname:fail
tcname: Pass
tcname:skipped
File2:
01,02,03
Output:
File 1
01:fail
02: Pass
03:Skipped (8 Replies)
I have a file comp.pkglist which mention package version and release . In 'version change' and 'release change' line there are two versions 'old' and 'new' Version Change: --> Release Change: -->
cat comp.pkglist
Package list: nss-util-devel-3.28.4-1.el6_9.x86_64
Version Change: 3.28.4 -->... (1 Reply)
Hello
Take this file...
Test01
Ref test
Version 01
Test02
Ref test
Version 02
Test66
Ref test
Version 66
Test99
Ref test
Version 99
I want to substitute every occurrence of Test{2} with a unique random number, so for example, if I was using sed, substitution would be something... (1 Reply)
Need a script that can find text in a file and replace it accordingly.
This is the file I have:
while IFS=',' read -r f1 f2 f3
do
{
nohup /home/testuser/dbmaintenance/sys_offline_maintenance.sh $f1 $f2 $f3 > $f2.out &
}
done < "/home/testuser/dbmaintenance/week1offlineserver.txt"
In... (4 Replies)
I'm new to shell programming, I have a huge text file in the following format, where columns are separated by single space:
ACA MEX 4O_ $98.00 $127.40 $166.60 0:00 0:00 0 ;
ACA YUL TS_ $300.00 $390.00 $510.00 0:00 0:00 0 ;
ACA YYZ TS_ $300.00 $390.00 $510.00 0:00 0:00 0 ;
ADZ YUL TS_ $300.00... (3 Replies)
Dear Friends,
I am looking for a way to replace a string (multiple lines) starting with something and ending with something (these two values do not change) with blank. Basically I want to delete this code injection accross many sites and folders.
Search Code (across files and folders) that... (2 Replies)
Hello,
I have a 100 line code. I have given a sample of it below:
ABC*654654*1*54.54*21.2*87*1*654654654654
CCC*FS*FS*SFD*DSF
GGG*FGH*CGB*FBDFG*FGDG
ABC*654654*1*57.84*45.4*88*2*6546546545
CCC*WSF*SG*FGH*GHJ
ADA*AF*SFG*DFGH*FGH*FGTH
I need to select the line starting with "ABC" its... (3 Replies)
Hello,
I have a 100 line code. I have given a sample of it below:
ABC*654654*1*54.54*21.2*87*1*654654654654
CCC*FS*FS*SFD*DSF
GGG*FGH*CGB*FBDFG*FGDG
ABC*654654*1*57.84*45.4*88*2*6546546545
CCC*WSF*SG*FGH*GHJ
ADA*AF*SFG*DFGH*FGH*FGTH
I need to select the line starting with "ABC" its... (6 Replies)
Hey guys, I have a file that I've slowly been awking, seding, and greping for data entry. I am down to pull the addresses out to insert them into an excel file. Each address is a few lines, but i want to put a semicolon delimiter in between each address so I can export the text file into excel and... (6 Replies)