11-30-2010
Hi,
When I tried the command I received the following error:
$ cat InputFile.csv
ColA|ColB|ColC|ColD|ColE|ColF
1|A|B|Asia|E|F
1||C|Asia|E|F
2|B|C|Casablanca|E|F
3|B|C|Brando|E|F
$ awk -F"|" 'BEGIN { B["Asia"]=B["Casablanca"]=B["Brando"]=1; } $2 && ($4 in B) ' InputFile.csv > outfile
awk: syntax error near line 1
awk: bailing out near line 1
Please help me in this. Thanks in Advance!!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I need to extract lines based on some conditions as explained below:
File format details:
notes:
1. each set starts with AAA only
2. number of columns is fixed
3. number of rows per set may vary (as one set is upto DDD - 4 rows)
Now, if any BBB's 5th column is blank then then... (4 Replies)
Discussion started by: prvnrk
4 Replies
2. Shell Programming and Scripting
i have a file in unix in which the records are like this
aaa 123 233
aaa 234 222
aaa 242 222
bbb 122 111
bbb 122 123
ccc 124 222
In the output i want only the below records
aaa
ccc
The validation logic is 1st column and 2nd column need to be considered
if both columns values are... (8 Replies)
Discussion started by: trichyselva
8 Replies
3. Shell Programming and Scripting
Hi
I am having files with date and time stamp as the folder names like 200906051400,200906051500,200906051600 .....hence everyday 24 files will be generated
i need to do certain things on this 24 files daily
file contains the data like
200906050016370 0 1244141195225298lessrv3 ... (13 Replies)
Discussion started by: aemunathan
13 Replies
4. Shell Programming and Scripting
I have a ";" delimited file.Whcih conatins a number fileds of length 4 charcters in 8th position
But there is a alphanumeric charcters like :
space, ";" , "," , "/" , "23-1" ,
"23 1" , "aqjhdj" , "jun-23" , "APR-04" , "4:00AM" , "-234" , "56784 ", "." , "+"
"_" , "&" , "*" , "^" , "%" , "!"... (2 Replies)
Discussion started by: indusri
2 Replies
5. Shell Programming and Scripting
I have a csv file that I need to extract some data from depending on another field after reading info from another text file.
The text file would say have 592560 in it.
The csv file may have some data like so
Field 1 Field2 Field3 Field4 Field5 Field6
20009756 1 ... (9 Replies)
Discussion started by: GroveTuckey
9 Replies
6. Emergency UNIX and Linux Support
Hi guys,
I need help in making a command to find some data.
I have multiple files in which multiple records are present.. Each record is separated with a carriage return and in each record there are multiple fields with each field separated by "|"
what i want is that I want to extract... (1 Reply)
Discussion started by: m_usmanayub
1 Replies
7. Shell Programming and Scripting
Hi,
I look for a awk one liner for below issue.
input file
ABC 1234 abc 12345
ABC 4567 678 XYZ
xyz ght 678
ABC 787 yyuu
ABC 789 7890 777
zxr hyip hyu
mno uii 678 776
ABC ty7 888
All lines should be started with ABC as first field. If a record has another value for 1st... (7 Replies)
Discussion started by: ratheesh2011
7 Replies
8. UNIX for Dummies Questions & Answers
Hi Guys,
I am new to shell script.I need your help to write a shell script.
I need to write a shell script to extract data from a .csv file where columns are ',' separated.
The file has 5 columns having values say column 1,column 2.....column 5 as below along with their valuesm.... (1 Reply)
Discussion started by: Vivekit82
1 Replies
9. Shell Programming and Scripting
Please help me to write a script
Match with ACNO & NAME if it matched calculate the total val1 val2 val3 and val4 and GT is total of ACNO wise.please check the output
Table
-----------------
1005|ANDP|ACN|20|50|10|30
1005|ANDP|ACN|20|10|30|40
1001|AND|NAC|40|50|40|50... (22 Replies)
Discussion started by: kalia4u
22 Replies
10. Shell Programming and Scripting
I have been reading old posts and trying to come up with a solution for the below: Use a tab-delimited input file to assign
point to variables that are used to update a specific field, Rank. I really couldn't find too much in the way of assigning points
to variable, but made an attempt at an awk... (4 Replies)
Discussion started by: cmccabe
4 Replies
LEARN ABOUT SUSE
finance::quote::yahoo::asia
Finance::Quote::Yahoo::Asia(3) User Contributed Perl Documentation Finance::Quote::Yahoo::Asia(3)
NAME
Finance::Quote::Yahoo::Asia - Fetch quotes from Yahoo Asia
SYNOPSIS
use Finance::Quote;
$q = Finance::Quote->new;
%info = $q->fetch("asia","CREA.SI"); # Failover to other methods ok.
%info = $q->fetch("yahoo_asia","CREA.SI"); # Use this module only.
DESCRIPTION
This module fetches information from Yahoo Asia. Symbols should be provided in the format "SYMBOL.EXCHANGE", where the exchange code is
one of the following:
SI - Singapore
BO - Bombay
JK - Jakarta
HK - Hong Kong
NS - India
KS - Korea
KL - Kuala Lumpur
NZ - New Zealand
SS - Shanghai
SZ - Shenzhen
TW - Taiwan
TH - Thailand
This module provides both the "asia" and "yahoo_asia" methods. The "asia" method should be used if failover methods are desirable. The
"yahoo_asia" method should be used you desire to only fetch information from Yahoo Europe.
Stocks are returned in the currency of the local exchange. You can use Finance::Quote's set_currency() feature to change the currency in
which information is returned.
This module is loaded by default by Finance::Quote, but can be loaded explicitly by specifying the parameter "Yahoo::Asia" to
Finance::Quote->new().
Information obtained by this module may be covered by Yahoo's terms and conditions. See http://sg.finance.yahoo.com/ for more details.
LABELS RETURNED
This module returns all the standard labels (where available) provided by Yahoo. See Finance::Quote::Yahoo::Base for a list of these. The
currency label is also returned.
BUGS
The currency of each exchange has not been thoroughly confirmed. If you find an exchange is returning in an incorrect exchange, please use
the bug tool at http://sourceforge.net/projects/finance-quote to report it.
SEE ALSO
Yahoo Asia, http://sg.finance.yahoo.com/
Finance::Quote::Yahoo::Base
perl v5.12.1 2009-10-05 Finance::Quote::Yahoo::Asia(3)