Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Reading from a CSV and writing in same CSV file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Reading from a CSV and writing in same CSV file
# 1  
Old 09-07-2012
Reading from a CSV and writing in same CSV file
Hi,

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:-
Code:
20120829001415,noneAA,google.com
20120829001415,dfsafds,google.com
20120829001415,noneAA,google.com

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:-
Code:
20120829001415,abcd,google.com
20120829001415,dfsafds,google.com
20120829001415,dfgd,google.com

Thanks in advance.
Moderator's Comments:
Mod Comment
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!
# 2  
Old 09-07-2012
you have to be more descriptive than that.
What does "based on some grep command output" mean?
How did you arrive at your desired output sample from the sample input?
# 3  
Old 09-07-2012
Yes. I have figured out that. I just need to know how I modify the same CSV file while reading it.
# 4  
Old 09-07-2012
Quote:
Originally Posted by kmajumder
Yes. I have figured out that. I just need to know how I modify the same CSV file while reading it.
it all depends on the 'tools' you're using to modify a file.
the easiest/generic paradigm is to write to a temp file, and rename a temp file to the original CSV file AFTER the original file is fully read/processed.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Reading CSV file

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

2. UNIX for Dummies Questions & Answers

Writing multiple outputs in to separate cells of CSV file

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)
Discussion started by: prabhat.diwaker
4 Replies

3. Shell Programming and Scripting

Reading the value of particular column from csv file

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)
Discussion started by: punpun66
3 Replies

4. Shell Programming and Scripting

Reading last line of a CSV file

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)
Discussion started by: Chinky23
2 Replies

5. Shell Programming and Scripting

Need help in writing a routine for sorting a CSV file

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)
Discussion started by: avikaljain
6 Replies

6. Shell Programming and Scripting

Reading variables from CSV file

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)
Discussion started by: ventris
2 Replies

7. UNIX for Advanced & Expert Users

Issue reading csv file

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)
Discussion started by: mohdtausifsh
1 Replies

8. Shell Programming and Scripting

reading from a .csv file

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)
Discussion started by: novice_user
1 Replies

9. Shell Programming and Scripting

writing to a csv file

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)
Discussion started by: pstanand
6 Replies

10. Shell Programming and Scripting

Script for reading .csv file

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)
Discussion started by: creativeworld
3 Replies
Login or Register to Ask a Question