09-09-2008
Find exact string
Hi Guys,
File is containing data
Col1 Col2
ListPrice List Price
Price Average Selling Price - Actual
ProjPrice Average Selling Price
ProjPrice Launch Price
ProjCost Cost
Now i need to print col2 on the basis of col1
i.e if i Pass Price it should display only "Average Selling Price - Actual"
I tried using grep which print first 4 lines like.
cat StrykerData_Cubes.csv |grep "Price" | cut -d "," -f2 | tr -s " " "_"
even sed command like
cat StrykerData_Cubes.csv |grep -w "Price" | sed /^Price/p
10 More Discussions You Might Find Interesting
1. Solaris
Hii,.,
Can some one guide me ...how to find a exact word or string using "grep" not a part of some other string.
say if i need 321 it should not give me 3210 nor 1321 it should only give me line containing string 321
Thanks and Regards,
Joy (2 Replies)
Discussion started by: gr8pals
2 Replies
2. Shell Programming and Scripting
I want to find a dir called STOP from the root.so what is the find command.
Thanks & Regards
Rajkumar (1 Reply)
Discussion started by: rajkumar_g
1 Replies
3. Shell Programming and Scripting
Hi there,
I've search this forum and find this problem could have been solved by,
grep -ho "num=*" input_data
The input_data is,
1\11\num1=100\num2=200\newnum1=220\\@
however, what I have got is ,
num1=100
num1=220
how to get the exact string, (4 Replies)
Discussion started by: liuzhencc
4 Replies
4. UNIX for Dummies Questions & Answers
Hello,
I have the following foreach loop in a csh script:
foreach f ( example good example)
cat $n | grep $f
END
And I would like to grep "example" and "good example", the problem is that when I add " to the foreach loop it doesn't work well and looks for good and then example. How can... (2 Replies)
Discussion started by: moyzZ
2 Replies
5. Shell Programming and Scripting
All,
I am trying to read in a variable and search a file then delete based on that string, but i want to match exact word.
This works but it matches all, i don't want to match anthing that contains the string, just the exact string.
sed -i "/$feedname/d" file
I tried
sed... (1 Reply)
Discussion started by: markdjones82
1 Replies
6. Shell Programming and Scripting
QUESTION1:
How do you grep only an exact string. I am using Solaris10 and do not have any GNU products installed.
Contents of car.txt
CAR1_KEY0
CAR1_KEY1
CAR2_KEY0
CAR2_KEY1
CAR1_KEY10
CURRENT COMMAND LINE: WHERE VARIABLE CAR_NUMBER=1 AND KEY_NUMBER=1
grep... (1 Reply)
Discussion started by: thibodc
1 Replies
7. Shell Programming and Scripting
I am attempting to grep an exact string from a series of files within a directory and append that output to the filename when it is present in the file. I've been after this all day with no luck. Thanks for your help in advance :wall:. (4 Replies)
Discussion started by: JC_1
4 Replies
8. Shell Programming and Scripting
Hi ,
am getting output file, it sontains the below values.
./hawk_DOM1_FIRST_ENV
./hawk_DOM2_SECOND_ENV
./hawk_DOM3_THIRD_ENV
Now I need to grep the word "DOM1_FIRST_ENV","DOM2_SECOND_ENV"
like that.
I tired with cut -d "_". Its not working with any deleimiter.
Can you please help to... (3 Replies)
Discussion started by: ckchelladurai
3 Replies
9. Shell Programming and Scripting
I just want to match "binutils1_test" only, and print the match line only
lyang001@lyang001-OptiPlex-9010:/tmp$ cat file
zbinutils1_test
bbinutils1_test
binutils1_test
w-binutils1_test
lyang001@lyang001-OptiPlex-9010:/tmp$ cat file |grep -w 'binutils1_test'
... (7 Replies)
Discussion started by: yanglei_fage
7 Replies
10. Shell Programming and Scripting
Hi all,
I tried searching the forum for this, and I read numerous suggestions here and even on other forums, and I cannot get this to want the way that I need it to. I tried grep -W / -f to no luck. Here is what I have. I have a list of file names-
FILE1-FILE1TEST,FILE1RELATION... (7 Replies)
Discussion started by: jeffs42885
7 Replies