Sponsored Content
Full Discussion: Find exact string
Top Forums UNIX for Dummies Questions & Answers Find exact string Post 302234193 by Swapna173 on Tuesday 9th of September 2008 09:28:55 AM
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
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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
YahooQuote(3pm) 					User Contributed Perl Documentation					   YahooQuote(3pm)

NAME
Finance::YahooQuote - Get stock quotes from Yahoo! Finance SYNOPSIS
use Finance::YahooQuote; # setting TIMEOUT and PROXY is optional $Finance::YahooQuote::TIMEOUT = 60; $Finance::YahooQuote::PROXY = "http://some.where.net:8080"; @quote = getonequote $symbol; # Get a quote for a single symbol @quotes = getquote @symbols; # Get quotes for a bunch of symbols useExtendedQueryFormat(); # switch to extended query format useRealtimeQueryFormat(); # switch to real-time query format @quotes = getquote @symbols; # Get quotes for a bunch of symbols @quotes = getcustomquote(["DELL","IBM"], # using custom format ["Name","Book Value"]); # note array refs DESCRIPTION
This module gets stock quotes from Yahoo! Finance. The getonequote function will return a quote for a single stock symbol, while the getquote function will return a quote for each of the stock symbols passed to it. getcustomquote allows to specify a format other than the default to take advantage of the extended range of available information. The download operation is efficient: only one request is made even if several symbols are requested at once. The return value of getonequote is an array, with the following elements: 0 Symbol 1 Company Name 2 Last Price 3 Last Trade Date 4 Last Trade Time 5 Change 6 Percent Change 7 Volume 8 Average Daily Vol 9 Bid 10 Ask 11 Previous Close 12 Today's Open 13 Day's Range 14 52-Week Range 15 Earnings per Share 16 P/E Ratio 17 Dividend Pay Date 18 Dividend per Share 19 Dividend Yield 20 Market Capitalization 21 Stock Exchange If the extended format has been selected, the following fields are also retrieved: 22 Short ratio 23 1yr Target Price 24 EPS Est. Current Yr 25 EPS Est. Next Year 26 EPS Est. Next Quarter 27 Price/EPS Est. Current Yr 28 Price/EPS Est. Next Yr 29 PEG Ratio 30 Book Value 31 Price/Book 32 Price/Sales 33 EBITDA 34 50-day Moving Avg 35 200-day Moving Avg If the real-time format has been selected, the following fields are also retrieved: 36 Ask (real-time) 37 Bid (real-time) 38 Change in Percent (real-time) 39 Last trade with time (real-time) 40 Change (real-time) 41 Day range (real-time) 42 Market-cap (real-time) The getquote function returns an array of pointers to arrays with the above structure. The getonequote function returns just one quote, rather than an array. It returns a simple array of values for the given symbol. The setQueryString permits to supply a new query string that will be used for subsequent data requests. The useExtendedQueryFormat and useRealtimeQueryFormat are simpler interfaces which append symbols to the default quote string, as detailed above. The getcustomquote returns an array of quotes corresponding to values for the symbols supplied in the first array reference, and the custom fields supplied in the second array reference. Here the custom fields correspond to the 'named' fields of the list below. Beyond stock quotes, Finance::YahooQuote can also obtain quotes for currencies (from the Philadephia exchange -- however Yahoo! appears to have stopped to support the currency symbols in a reliable manner), US mutual funds, options on US stocks, several precious metals and quite possibly more; see the Yahoo! Finance website for full information. Finance::YahooQuote can be used for stocks from the USA, Canada, various European exchanges, various Asian exchanges (Singapore, Taiwan, HongKong, Kuala Lumpur, ...) Australia and New Zealand. It should work for other markets supported by Yahoo. You may optionally override the default LWP timeout of 180 seconds by setting $Finance::YahooQuote::TIMEOUT to your preferred value. You may also provide a proxy (for the required http connection) by using the variable $Finance::YahooQuote::PROXY. Furthermore, authentication-based proxies can be used by setting the proxy user and password via the variables $Finance::YahooQuote::PROXYUSER and $Finance::YahooQuote::PROXYPASSWD. Two example scripts are provided to help with the mapping a stock symbols as well as with Yahoo! Finance server codes. The regression tests scripts in the t/ subdirectory of the source distribution also contain simple examples. The available custom fields The following list contains all the available data fields at Yahoo! along with the corresponding format string entry: Symbol s Name n Last Trade (With Time) l Last Trade (Price Only) l1 Last Trade Date d1 Last Trade Time t1 Last Trade Size k3 Change and Percent Change c Change c1 Change in Percent p2 Ticker Trend t7 Volume v Average Daily Volume a2 More Info i Trade Links t6 Bid b Bid Size b6 Ask a Ask Size a5 Previous Close p Open o Day's Range m 52-week Range w Change From 52-wk Low j5 Pct Chg From 52-wk Low j6 Change From 52-wk High k4 Pct Chg From 52-wk High k5 Earnings/Share e P/E Ratio r Short Ratio s7 Dividend Pay Date r1 Ex-Dividend Date q Dividend/Share d Dividend Yield y Float Shares f6 Market Capitalization j1 1yr Target Price t8 EPS Est. Current Yr e7 EPS Est. Next Year e8 EPS Est. Next Quarter e9 Price/EPS Est. Current Yr r6 Price/EPS Est. Next Yr r7 PEG Ratio r5 Book Value b4 Price/Book p6 Price/Sales p5 EBITDA j4 50-day Moving Avg m3 Change From 50-day Moving Avg m7 Pct Chg From 50-day Moving Avg m8 200-day Moving Avg m4 Change From 200-day Moving Avg m5 Pct Chg From 200-day Moving Avg m6 Shares Owned s1 Price Paid p1 Commission c3 Holdings Value v1 Day's Value Change w1, Holdings Gain Percent g1 Holdings Gain g4 Trade Date d2 Annualized Gain g3 High Limit l2 Low Limit l3 Notes n4 Last Trade (Real-time) with Time k1 Bid (Real-time) b3 Ask (Real-time) b2 Change Percent (Real-time) k2 Change (Real-time) c6 Holdings Value (Real-time) v7 Day's Value Change (Real-time) w4 Holdings Gain Pct (Real-time) g5 Holdings Gain (Real-time) g6 Day's Range (Real-time) m2 Market Cap (Real-time) j3 P/E (Real-time) r2 After Hours Change (Real-time) c8 Order Book (Real-time) i5 Stock Exchange x FAQs How can one figure out the format string? Provided a My Yahoo! (http://my.yahoo.com) account, go to the following URL: http://edit.my.yahoo.com/config/edit_pfview?.vk=v1 Viewing the source of this page, you will come across the section that defines the menus that let you select which elements go into a particular view. The <option> values are the strings that pick up the information described in the menu item. For example, Symbol refers to the string "s" and name refers to the string "l". Using "sl" as the format string, we would get the symbol followed by the name of the security. The example script examine_server.sh shows this in some more detail and downloads example .csv files using GNU wget. What about different stock symbols for the same corporation? This can be issue. For the first few years, Yahoo! Finance's servers appeared to be cover their respective local markets. E.g., the UK- based servers provided quotes for Europe, the Australian one for the Australia and New Zealand and so on. Hence, one needed to branch and bound code and map symbols to their region's servers. It now appears that this is no longer required, which is good news as it simplifies coding. However, some old symbols are no longer supported -- yet other, and supported, codes exist for the same company. For example, German stocks used to quoted in terms or their cusip-like 'WKN'. The main server does not support these, but does support newer, acronym-based symbols. The example script examine_server.sh helps in finding the mapping as e.g. from 555750.F to DTEGN.F for Deutsche Telekom. COPYRIGHT
Copyright 1998 - 2002 Dj Padzensky Copyright 2002 - 2007 Dirk Eddelbuettel This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. The information that you obtain with this library may be copyrighted by Yahoo! Inc., and is governed by their usage license. See http://www.yahoo.com/docs/info/gen_disclaimer.html for more information. AUTHOR
Dj Padzensky ("djpadz@padz.net"), PadzNet, Inc., wrote the original version. Dirk Eddelbuettel ("edd@debian.org") provided several extensions based on DJ's original work and is the current maintainer. SEE ALSO
The Finance::YahooQuote home pages are found at http://www.padz.net/~djpadz/YahooQuote/ and http://dirk.eddelbuettel.com/code/yahooquote.html. The smtm (Show Me The Money) program uses Finance::YahooQuote for a customisable stock/portfolio ticker and chart display, see http://dirk.eddelbuettel.com/code/smtm.html for more. The beancounter program uses it to store quotes in a SQL database, see http://dirk.eddelbuettel.com/code/beancounter.html. perl v5.10.1 2010-03-27 YahooQuote(3pm)
All times are GMT -4. The time now is 10:53 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy