Match words and fetch data in front of it in second column
Hi all,
I have 2 files
one file contain data like this in one column
second file containign data like this in 2 columns
I have match column of first file with second file and if similarty of symbol which are made up of capital alphabets is there then it shuld copy the sentence in front of it
The Expected out put is
If it possible to remove the bracket then it will be good in expected output
---------- Post updated at 08:25 AM ---------- Previous update was at 02:37 AM ----------
Quote:
Originally Posted by manigrover
Hi all,
I have 2 files
one file contain data like this in one column
second file containing data like this in 2 columns
I have match column of first file with second file and if similarty of symbol which are made up of capital alphabets is there then it shuld copy the sentence in front of it
If it possible to remove the bracket then it will be good in expected output
Last edited by manigrover; 08-16-2012 at 10:24 AM..
pls help
Input:
file1
word1
text1
word2
text2
word3
text3
file2
word1
text11
word3
text13
can u pls help in getting the same
output:
file1 text1 text2 text3 (1 Reply)
Dear All,
I am new to this forum and please ignore my little knowledge :p
I have two types of data (a subset is given below)
data version 1:
439798 2 1
451209 1 2
508696 2 1
555760 2 1
582757 1 2
582889 1 2
691827... (2 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)
Hello experts,
Please help me in achieving this in an easier way possible. I have 2 csv files with following data:
File1
08/23/2012 12:35:47,JOB_5330
08/23/2012 12:35:47,JOB_5330
08/23/2012 12:36:09,JOB_5340
08/23/2012 12:36:14,JOB_5340
08/23/2012 12:36:22,JOB_5350
08/23/2012... (5 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 all
I have 2 files:
first file
AABC
TTYP
JKBH
CVBN
NHJK
KJHM
Second file is
AABC,XCYU,JUHD Alllele1 GACXT It is approved study
TTYP,JKBH Allele2 PPRD It is clinical trial study
JKBH Allele2 PPRD ... (5 Replies)