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
LEARN ABOUT DEBIAN
ltpretty
LTPRETTY(1p) User Contributed Perl Documentation LTPRETTY(1p)
NAME
ltpretty - Use LaTeX::Table from within your text editor.
SYNOPSIS
ltpretty < lazytable
DESCRIPTION
This program takes a lazy formatted LaTeX table from STDIN (typically piped from Vim or emacs) and outputs a completely formatted table.
LAZY FORMAT
The first line must contain the LaTeX::Table options (separated by semicolons ";") in the format "optionname=value". The second line must
contain the header, the following lines the data. Columns are separated by "&". Trailing empty lines are ignored, other empty lines
generate horizontal rules (as in LaTeX::Table).
EXAMPLE
theme=Meyrin;label=test;position=htb
Item:2c & Price
Gnat& per gram& 13.65
& each& 0.01
Gnu& stuffed& 92.59
Emu& stuffed& 33.33
Armadillo& frozen& 8.99
VIM
1. Select the text in "VISUAL LINE" mode ("shift+v").
2. Type "!ltpretty"
EMACS
1. Select the text
2. Press "alt+|"
3. Now "Shell command on region" should appear. Type "ltpretty"
OUTPUT
% theme=Meyrin;label=test;position=htb
% Item:2c & Price
% Gnat& per gram& 13.65
% & each& 0.01
%
% Gnu& stuffed& 92.59
% Emu& stuffed& 33.33
% Armadillo& frozen& 8.99
egin{table}[htb]
centering
egin{tabular}{llr}
oprule
multicolumn{2}{c}{Item} & Price \
midrule
Gnat & per gram & 13.65 \
& each & 0.01 \
midrule
Gnu & stuffed & 92.59 \
Emu & stuffed & 33.33 \
Armadillo & frozen & 8.99 \
ottomrule
end{tabular}
label{test}
end{table}
CONFIGURATION AND ENVIRONMENT
"ltpretty" does not support configuration files or environment variables.
DEPENDENCIES
LaTeX::Table
BUGS AND LIMITATIONS
Our lazy format does not support multi-line headers. Just add the other header lines afterwards. More importantly, it currently does not
support non-scalar LaTeX::Table options like for example "columns_like_header". A future version may add this functionality.
Please report any bugs or feature requests to "bug-latex-table@rt.cpan.org", or through the web interface at <http://rt.cpan.org>.
LICENSE AND COPYRIGHT
Copyright (c) 2006-2010, "<limaone@cpan.org>".
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. See perlartistic.
DISCLAIMER OF WARRANTY
BECAUSE THIS SOFTWARE IS LICENSED FREE OF CHARGE, THERE IS NO WARRANTY FOR THE SOFTWARE, TO THE EXTENT PERMITTED BY APPLICABLE LAW. EXCEPT
WHEN OTHERWISE STATED IN WRITING THE COPYRIGHT HOLDERS AND/OR OTHER PARTIES PROVIDE THE SOFTWARE "AS IS" WITHOUT WARRANTY OF ANY KIND,
EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE OF THE SOFTWARE IS WITH YOU. SHOULD THE SOFTWARE PROVE DEFECTIVE, YOU ASSUME THE COST OF
ALL NECESSARY SERVICING, REPAIR, OR CORRECTION.
IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN WRITING WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MAY MODIFY AND/OR
REDISTRIBUTE THE SOFTWARE AS PERMITTED BY THE ABOVE LICENSE, BE LIABLE TO YOU FOR DAMAGES, INCLUDING ANY GENERAL, SPECIAL, INCIDENTAL, OR
CONSEQUENTIAL DAMAGES ARISING OUT OF THE USE OR INABILITY TO USE THE SOFTWARE (INCLUDING BUT NOT LIMITED TO LOSS OF DATA OR DATA BEING
RENDERED INACCURATE OR LOSSES SUSTAINED BY YOU OR THIRD PARTIES OR A FAILURE OF THE SOFTWARE TO OPERATE WITH ANY OTHER SOFTWARE), EVEN IF
SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.
perl v5.10.1 2010-10-27 LTPRETTY(1p)