I am tryng to read from a csv file and based on some grep command output I will modify one of the column in the same csv.
Example:-
Input CSV:-
Intermediate Step:- If 2nd column of input csv is noneAA then I have to run a grep and and store the result of the grep command and then update the 2nd column with the stored value received from the grep.
Output CSV:-
Thanks in advance.
Moderator's Comments:
Please use code tags when posting data and code samples!
Last edited by kmajumder; 09-07-2012 at 06:59 PM..
Reason: code tags, please!
Can someone please help me to write script for following scenario :
1> script should read a input .csv file of format : EmpName, PF, Leave, Basic ,HRA
2> another config file ( may be again a .csv file ) has format EmpName and EmpID
3> script should read another config file for each EmpName in... (3 Replies)
Hi buddies i have doubt. I 'm new to unix script and learning. I have a req.
I need to find the values mentioned in the double quoutes of each line and write it into a csv file. How do I handle this? Please help me.
SCTY_ISS_ID (SCTY_ISS_ID:Dec18Fixed.0:): "37927320080309"
TRD_DT... (6 Replies)
Hi ,
Can anyone please help me to read the value from the .csv file?
This is my .csv file:
dirnames: first,second
i want to get the two names and create directories correspondingly (1 Reply)
HI All
I have csv file containing the data like this
Electrical Equipment,ElecEquip
"Engineering, Machinery & Equipment",Engineerin
Entertainment & Broadcasting,Entertain
The first and third record are fine,The issue with second records as it has comma enclosed with in inverted... (1 Reply)
Hi I am using KSH and trying to read variables from a csv file. I've set the IFS=, and it workds. Problem is where one of the values is text containing a comma. For example the following lines exist in my file. How can I read everything between the quotes into a single variable?
APW13812,,1... (2 Replies)
Hi,
I have a CSV file in following manner:
server1,env1,patch1
server1,env1,patch2
server1,env1,patch3
server1,env2,patch1
server1,env2,patch3
server2,env3,patch1
server2,env3,patch5
server2,env4,patch1
server3,env6,patch1
server3,env7,patch2
server3,env7,patch3
I want to... (6 Replies)
Hi
I have a file which I am reading line by line and processing it.
But the last line is not getting read in the file loop until I put an enter in the end.
#!/bin/ksh -p
v_org_id=${P1}
FILE=${P2}
NEW_FILE_NAME=$APPLPTMP/b1.txt
BAKIFS=$IFS
IFS=$'\n'
exec 0<"$FILE"
echo "File to be... (2 Replies)
Hi Folks,
I have the below csv file which is comma delimited , now from this file i need to read the value of the column der_id and then want to create a separate text file which will contain the value of the column der_id only please advise how to read the value of the column der_id and then... (3 Replies)
Hi I am writing a script which has multiple awk statements and each statement gives me a numeric count as an output.
I want those output to be stored in different cells of a csv file.
say 12 awk statements give 12 output and i want them in diffrenet cells of csv file.
Thank you guys..!! (4 Replies)
Hi experts,
Im having csv file with few columns which should contain data as shown below. Want to check if column 3 contain row with duplicate value(9876,9876) then corresponding to this in col2 should contain text "tax" and should not contain text "non".
Word "non" can come but if in column3... (2 Replies)
Discussion started by: as7951
2 Replies
LEARN ABOUT PLAN9
zgrep
ZGREP(1) General Commands Manual ZGREP(1)NAME
zgrep - search possibly compressed files for a regular expression
SYNOPSIS
zgrep [ grep_options ] [ -e ] pattern filename...
DESCRIPTION
Zgrep invokes grep on compressed or gzipped files. These grep options will cause zgrep to terminate with an error code:
(-[drRzZ]|--di*|--exc*|--inc*|--rec*|--nu*). All other options specified are passed directly to grep. If no file is specified, then the
standard input is decompressed if necessary and fed to grep. Otherwise the given files are uncompressed if necessary and fed to grep.
If the GREP environment variable is set, zgrep uses it as the grep program to be invoked.
EXIT CODE
2 - An option that is not supported was specified.
AUTHOR
Charles Levert (charles@comm.polymtl.ca)
SEE ALSO grep(1), gzexe(1), gzip(1), zdiff(1), zforce(1), zmore(1), znew(1)ZGREP(1)