Find exact string


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Find exact string
# 1  
Old 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
# 2  
Old 09-09-2008
sed -ne '/^Price/p' filename | sed -e 's/^ *[^ ]* //'
try this.. and don't use cat when you are using command like grep,awk and sed
# 3  
Old 09-09-2008
this does not work if i use it in the for Loop. In fact it search the string in the beginning and there are lines where the beginning string matches. there this one does not work.

Last edited by Swapna173; 09-09-2008 at 11:09 AM..
# 4  
Old 09-09-2008
var=search string
nawk -v v=var 'if($1==$v)
{$1="";$0=substr($0,2)}1'
try something like this not sure because not tested :-)
# 5  
Old 09-09-2008
Try :

Code:
var=Price
awk '/^'$var'/{ $1=""; print; }' < StrykerData_Cubes.csv

Output:

Quote:
/home/ans >awk '/^'$var'/{ $1=""; print; }' < StrykerData_Cubes.csv
Average Selling Price - Actual
# 6  
Old 09-10-2008
Exact match

Sorry i made a mistake mine is a comma separated file, so i need to print col2 corresponding to search in col1. and will this one match the exact string means not the substring of a string
# 7  
Old 09-10-2008
Quote:
Originally Posted by Swapna173
Sorry i made a mistake mine is a comma separated file, so i need to print col2 corresponding to search in col1. and will this one match the exact string means not the substring of a string
then it made your work more easy..
awk -F"," then compare $1 with your required value and print $2
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Grep to find an exact string

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

2. Shell Programming and Scripting

Help match the exact string

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

3. Shell Programming and Scripting

Grep exact string from main string

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

4. Shell Programming and Scripting

grep exact string from files and write to filename when string present in file

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

5. Shell Programming and Scripting

QUESTION1: grep only exact string. QUESTION2: find and replace only exact value with sed

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

6. Shell Programming and Scripting

Sed find exact string and delete line with variable

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

7. UNIX for Dummies Questions & Answers

foreach with exact string

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

8. Shell Programming and Scripting

How to use grep to get an exact string?

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

9. Shell Programming and Scripting

what is the find command to find exact dir from the root

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

10. Solaris

Find an exact string

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
Login or Register to Ask a Question