10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
Hi,
i have 2 files , the data i need to match is in masterfile and i need to pull out column 3 from master if column 1 and 2 match and output entire row to new file
I have tried with join and awk and i keep getting blank outputs or same file
is there an easier way than what i am... (4 Replies)
Discussion started by: axis88
4 Replies
2. Shell Programming and Scripting
Hi I want to replace only the last occurance of "union all" in input file with ";"
I tried with sed 's/union all/;/g' in my input file, it replaced in all lines of input file
Eg:
select column1,column2 from test1 group by 2 union all
select column1,column2 from test2 group by 2 union all
... (9 Replies)
Discussion started by: antosr7
9 Replies
3. Shell Programming and Scripting
I have a situation where a file "config.txt" looks like this
Servername:
OS:
Serername:
OS:
Servername:
OS:
....
....
...
Servername:
OS:
looking for the sed syntax to replace the "Nth" occurrence of Servername (i would apply the same logic to OS as well), want to replace the Nth... (4 Replies)
Discussion started by: alldbest
4 Replies
4. Shell Programming and Scripting
Good morning everyone and hello unix.com!
I'm trying to solve a problem and was unable to find a solution after a forum research. So hopefully you can help me get this solved.
I have these two csv files:
file1.csv
ID,REFERENCE,STATUS
1,2,0
2,4,1
3,1,0
file2.csv... (2 Replies)
Discussion started by: RKos
2 Replies
5. Shell Programming and Scripting
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)
Discussion started by: paniklas
1 Replies
6. Shell Programming and Scripting
File A
B07 U51C 4434 L662C 4412
B07 L64U 612 L651B 4434
B07 L11C 4434 R151B 4434
B05 L12Z 612 L51B 4434
B01 651Z 612 L651C 4434
B04 A51Z 612 L51A 4434
L07 B08D 4434 B1B 4434
B07 RU8D 4434 L51A 4434
B07 L58D 4434 B51C 4434
B07 LA8D 4434 L4B 4434
Now i want File B Output
B07... (2 Replies)
Discussion started by: asavaliya
2 Replies
7. Shell Programming and Scripting
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)
Discussion started by: poweroflinux
8 Replies
8. Shell Programming and Scripting
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)
Discussion started by: timothyha22
0 Replies
9. Shell Programming and Scripting
My input file:
data_5 Ali 422 2.00E-45 102/253 140/253 24
data_3 Abu 202 60.00E-45 12/23 140/23 28
data_1 Ahmad 256 7.00E-45 120/235 140/235 22
data_4 Aman 365 8.00E-45 15/65 140/65 20
data_10 Jones 869 9.00E-45 65/253 140/253 18... (12 Replies)
Discussion started by: patrick87
12 Replies
10. Shell Programming and Scripting
HI please let me know if there is any command to search and replace only the last occurence of a string in aline.
Eg:
" This cat is a cat with a tail longer of all cat."
I need to replace only the last "cat" in the above line.
thanks (3 Replies)
Discussion started by: harikris614
3 Replies