10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
I have two files of the following form. I would like to remove from File.A where the first three colum matches values in File.B to give the output in File.C
121 54321 PQR CAT
122 765431 ABC DOG
124 98765 ZXY TIGER
125 86432 GEF LION
122 765431 ABC
125 86432 GEF... (4 Replies)
Discussion started by: Gussifinknottle
2. UNIX for Beginners Questions & Answers
I Want to merge multiple lines based on the 1st field and keep into single record.
'AAA_POC_DB','TAB1','TAB2','TAB3','TAB4'... (10 Replies)
Discussion started by: raju2016
3. Shell Programming and Scripting
Dear Unix gurus
I need help with a command or script to merge 2 lines where ever we find the string.
I have attached scanned document.
First line has string value: VSIN, immediate line has value: SETTLEMENT
Where it finds the 2 string values in the whole file, one below the other,... (8 Replies)
Discussion started by: Karunyam
4. UNIX for Dummies Questions & Answers
I have a file which I'd like to merge lines based on duplicates in one column while keeping the info for other columns. Let me simplify it by an example:
ESR1 ANASTROZOLE NA FDA_approved
ESR1 CISPLATIN NA FDA_approved
ESR1 DANAZOL agonist NA
ESR1 EXEMESTANE NA FDA_approved... (3 Replies)
Discussion started by: JJ001
5. Shell Programming and Scripting
I have following input file. I wish to retain those lines which match multiple search criteria. The search criteria is stored in a variable seperated from each other by comma(,).
SEARCH_CRITERIA = "REJECT, DUPLICATE"
ERROR,MYFILE_20130214_11387,9,37.75... (3 Replies)
Discussion started by: angshuman
6. Shell Programming and Scripting
I need to select lines from a txt file, I have got a line starting with ZMIO:MSISDN= and after a few line I have another line starting with 'MOBILE STATION ISDN NUMBER' and another one starting with 'VLR-ADDRESS' I need to copy these three lines as three different columns in a separate... (3 Replies)
Discussion started by: Tlcm sam
7. Shell Programming and Scripting
A bit of background: I am trying to create a script that formats SQL statements. I have gotten so far as to add new lines based on certain match criteria like commas, keywords etc. In the process, I end up adding newlines where I don't want.
For example: substr(colName, 1, 10)... (3 Replies)
Discussion started by: jayarkay
8. Shell Programming and Scripting
I'll try explain this as best I can. Let me know if it is not clear.
I have large text files that contain data as such:
143593502 09-08-20 09:02:13 xxxxxxxxxxx xxxxxxxxxxx 09-08-20 09:02:11 N line 1 test
line 2 test
line 3 test
143593503 09-08-20 09:02:13... (3 Replies)
Discussion started by: jesse
9. Shell Programming and Scripting
Please guide for Solution.
INPUT FILE (has 2 columns ID and score)
OUTPUT FILE (It shudn't contain the line ' BP132435_4 29.5 ' as BP132435 is repeated... (2 Replies)
Discussion started by: smriti_shridhar
10. Shell Programming and Scripting
Is there any way to merge two lines based on specific occurance of a character in a file.
I am having a flat file which contains multiple records.
Each row in the file should contain specified number of delimiter.
For a particular row , if the delimiter count is not matched with... (2 Replies)
Discussion started by: mohan_tuty