It's great that its working for my attached files but hwen I used twoo ther files with different data to do the same thin means to put same conditon it doesnt wrk(output s blank)
I haev attached sample of those two as well.
Please explain me if possible. Thanks a lot!
You need to specify your input file formats and stick to them.
In your first set of input files, the first file has the value you want to match followed by a <space> and a <newline>; and the second file has fields (some of which contain <space> characters) separated by <tab> characters.
In your second set of input files, the first file has the value you want to match followed by a <carriage-return> and a <newline>; and the second file has fields (all of which contain <space> characters, including some trailing <space> characters) separated by zero or more <space> characters followed by a <tab> character.
The following script works for either set of inputs and could probably be updated to accept other garbage in your input (but if that needs to be done I will leave it as an exercise for you to do yourself):
Note that the second file in both tests is named second.txt, but they are not the same file. You supplied two files to download named second.txt, but they are not even close to containing the same data and do not contain data in the same format.
This User Gave Thanks to Don Cragun For This Post:
Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2
file 1 sample
SNDK 80004C101 AT
XLNX 983919101 BB
NETL 64118B100 BS
AMD 007903107 CC
KLAC 482480100 DC
TER 880770102 KATS
ATHR 04743P108 KATS... (7 Replies)
Hi
i have a file which have a pattern like this
Nov 10 session closed
Nov 10 Nov 9 08:14:27 EST5EDT 2010 on tty .
Nov 10 Oct 19 02:14:21 EST5EDT 2010 on pts/tk .
Nov 10 afrtetryytr
Nov 10 session closed
Nov 10 Nov 10 03:21:04 EST5EDT 2010
Dec 8 Nov 10 05:03:02 EST5EDT 2010
... (13 Replies)
Hi all,
I have ot match sentence list and word list anf fetch similar words in a separate file
second file with 2 columns
So I want the output shuld be 2 columns like this (3 Replies)
Hi all,
I have 7 words
Now I have 1 file which contain data in large number of rows and columns
and 6th column contain any of these words or may be more than one words among above 7 words:
I want
script should search for the above mentioned 7 words in the 6th column
... (9 Replies)
Hi all,
I have 2 files
one file contain data like this in one column
AST3
GSTY4
JST3
second file containign data like this in 2 columns
AST3(PAXXX),GSTY4(PAXXY) it is used in diabetes
KST4 it is used in blood... (6 Replies)
Hi all
I have following file which I have to edit for research purpose
file:///tmp/moz-screenshot.png body, div, table, thead, tbody, tfoot, tr, th, td, p { font-family: "Liberation Sans"; font-size: x-small; } Drug: KRP-104 QD Drug: Placebo Drug: Metformin|Drug:... (15 Replies)
Hi guys
As my previous one is not working now I have a different problem with me
one file with entries
F2
F3
YUH
SUH
second fiel several columns like excel sheet (8-9) but my file in text
F2 fgf gfhjhjghjghj dhgfhgfh 234324
F3 ... (6 Replies)
Hi Solved these kind of issues using these codes But these are not wrking for my attached files can anybody check........
awk 'NR==FNR{X++;next}{if(X){print}}' file1 file2
awk 'NR==FNR{X=$0;next}{n=split($1,P," ");sub($1,"",$0);for(i=1;i<=n;i++){if(X]){print P,$0}}}' file1 FS="\t" file2
... (6 Replies)
Hi Friends,
How to fetch current hour data from a log file, given below?
I want all lines after the match "Wed Aug 13 16:"
I have tried below command, but not working. If I put exact string, then it is working.
cat /iscp/user/monitor/ORA_errors |awk '/`date +%h" "%d" "%h`/,printed==999 {... (7 Replies)