10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Have three files. Any other approach with regards to file concatenation or splitting, etc is appreciated
If column55(billngtype) of file1 contains YMNC or YPBC then pick the value of column13(documentnumber). Now find this documentnumber in column1(Billdoc) of file2 and grep the corresponding... (4 Replies)
Discussion started by: as7951
4 Replies
2. Shell Programming and Scripting
how to search and replace string in column in file with command sed or other
search "INC0000003.in" and replace column 4 = "W"
$ cat file.txt
INC0000001.in|20150120|Y|N|N
INC0000002.in|20150120|Y|N|N
INC0000003.in|20150120|Y|N|N
INC0000004.in|20150120|Y|N|Noutput... (4 Replies)
Discussion started by: ppmanja3
4 Replies
3. Shell Programming and Scripting
Hi,
I am new to sed scriping but do have some basic scripting skills. I have a properties file props.conf with name/value pairs written in it. Sample is
Name1=test
Name2=notest
Then I have a template file (can be xml or simple text) which will have 'keys' embedded in it. Keys can... (2 Replies)
Discussion started by: tigerinopen
2 Replies
4. Shell Programming and Scripting
Hi Gurus,
I did an exhaustive search for finding the script using "sed" to exclude the first line of file during find and replace.
The first line in my file is the header names.
Thanks for your help.. (4 Replies)
Discussion started by: ks_reddy
4 Replies
5. UNIX for Dummies Questions & Answers
Hi All
I have a simple text file and I want to be able to replace any alpha character and comma combination with any other symbol of my choice
here is the text file I want to replace:
pear
apple
ban,ana
grape
",g1234,"
te,st1
here is how it should look afterwards:
pear... (4 Replies)
Discussion started by: greg_b
4 Replies
6. Shell Programming and Scripting
Hi everyone,
basically I am been cleaning data by using simple sed commands
So what i have below has been working for me.
sed 's/="//g' trade.csv > tradeb.csv
sed 's/"//g' tradeb.csv > trade2.csv
but now i don't want to remove all the quotes just the ones if i encounter this ... (1 Reply)
Discussion started by: raz0r
1 Replies
7. UNIX for Dummies Questions & Answers
Hello -
I have a very large file in which a certain numbers are repeated. I find that using vi to edit the entire file is useless.
How should i use sed to find a replace such as this text:
To replace: 145.D25.D558
With: 215.22.45.DW
I tried this command:
sed... (4 Replies)
Discussion started by: DallasT
4 Replies
8. Shell Programming and Scripting
hi,
im new for sed, anyone can help me to these in sed command
my output file.txt
"aaa",a1,bbb
"ddd",a1,ccc
"eee",a1,www
need to change a1, to "a1","
output i need
"aaa","a1","bbb
"ddd","a1","ccc
"eee","a1","www
thanks in advance
fsp (2 Replies)
Discussion started by: fspalero
2 Replies
9. UNIX for Dummies Questions & Answers
Hello,
I have a file and in that, I want to search for a aprticular word and then replace another word in the same line with something else.
Example: In file abc.txt, there is a line
<host oa_var="s_hostname">test</host>
I want to search with s_hostname text and then replace test with... (2 Replies)
Discussion started by: sshah1001
2 Replies
10. UNIX for Dummies Questions & Answers
Hello Folks,
Anyone know how I can replace this line in file.xml
<oacore_nprocs oa_var="s_oacore_nprocs">8</oacore_nprocs>
with this line
<oacore_nprocs oa_var="s_oacore_nprocs">1</oacore_nprocs>
using sed or awk ?
Thanks for your time.
Cheers,
Dave (7 Replies)
Discussion started by: d__browne
7 Replies