Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

CSV file issue

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting CSV file issue
# 8  
Old 12-10-2010
Ok.. It works for me..
Code:
sed '/[^"]$/N; s/\n/ /' inputfile
A EMP 58 ; NO EMP"
NO EMPL"
TXN 58 ; NO EMPL"

Is this what you expect or something else..
# 9  
Old 12-10-2010
Attaching you correct file

Name comment value
"A","EMP","58.s
; NO EMP"
"B","EMP","56.s; NO EMPL"
"C","EMP","54.s
; NO EMP"
output to be
Name comment value
"A","EMP","58.s; NO EMP"
"B","EMP","56.s; NO EMPL" -- No change as it ends with "
"C","EMP","54.s; NO EMP"

Output got is
Name comment value"A","EMP","58.s; NO EMP"
"B","EMP","56.s; NO EMPL" "C","EMP","54.spls help
# 10  
Old 12-10-2010
ok so you need to exempt line# 1.Could try..
Code:
tail +2 inputfile |sed '/[^"]$/N; s/\n/ /'
"A","EMP","58.s ; NO EMP"
"B","EMP","56.s; NO EMPL"
"C","EMP","54.s ; NO EMP"

# 11  
Old 12-10-2010
not only that, if you see the output 2nd and 3rd line are merged

Name comment value
"A","EMP","58.s
; NO EMP"
"B","EMP","56.s; NO EMPL"
"C","EMP","54.s
; NO EMP"

Output got is
Name comment value"A","EMP","58.s; NO EMP"
"B","EMP","56.s; NO EMPL" "C","EMP","54.s
# 12  
Old 12-10-2010
Well.. It works for me. Wot machine and the sed version you have..? Below is the output i get. Post your execution line as well..
Code:
cat inputfile
Name comment value
"A","EMP","58.s
; NO EMP"
"B","EMP","56.s; NO EMPL"
"C","EMP","54.s
; NO EMP"

Code:
tail +2 inputfile |sed '/[^"]$/N; s/\n/ /'
"A","EMP","58.s ; NO EMP"
"B","EMP","56.s; NO EMPL"
"C","EMP","54.s ; NO EMP"

# 13  
Old 12-10-2010
i'm directing output to another file will that be problem
tail +1 test.csv|sed '/[^"]$/N; s/\n/ /'>test2.csv
# 14  
Old 12-10-2010
Code:
nawk '{x=(/;/||NR<2)?RS:"";printf"%s"x,$0}' input

Code:
# cat input
Name comment value
"A","EMP","58.s
; NO EMP"
"B","EMP","56.s; NO EMPL"
"C","EMP","54.s
; NO EMP"

Code:
# nawk '{x=(/;/||NR<2)?RS:"";printf"%s"x,$0}' input
Name comment value
"A","EMP","58.s; NO EMP"
"B","EMP","56.s; NO EMPL"
"C","EMP","54.s; NO EMP"

Last edited by ctsgnb; 12-10-2010 at 10:21 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Save output of updated csv file as csv file itself, part 2

Hi, I have another problem. I want to sort another csv file by the first field. result.csv SourceFile,Airspeed,GPSLatitude,GPSLongitude,Temperature,Pressure,Altitude,Roll,Pitch,Yaw /home/intannf/foto5/2015_0313_090651_219.JPG,0.,-7.77223,110.37310,30.75,996.46,148.75,180.94,182.00,63.92 ... (2 Replies)
Discussion started by: refrain
2 Replies

2. Shell Programming and Scripting

Save output of updated csv file as csv file itself

Hi, all I want to sort a csv file based on timestamp from oldest to newest and save the output as csv file itself. Here is an example of my csv file. test.csv SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0739.JPG,2015:02:17 11:32:21 /home/intannf/foto/IMG_0749.JPG,2015:02:17 11:37:28... (10 Replies)
Discussion started by: refrain
10 Replies

3. Shell Programming and Scripting

Compare 2 files of csv file and match column data and create a new csv file of them

Hi, I am newbie in shell script. I need your help to solve my problem. Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file. File1: SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies

4. Shell Programming and Scripting

Match columns from two csv files and update field in one of the csv file

Hi, I have a file of csv data, which looks like this: file1: 1AA,LGV_PONCEY_LES_ATHEE,1,\N,1,00020460E1,0,\N,\N,\N,\N,2,00.22335321,0.00466628 2BB,LES_POUGES_ASF,\N,200,200,00006298G1,0,\N,\N,\N,\N,1,00.30887539,0.00050312... (10 Replies)
Discussion started by: djoseph
10 Replies

5. Shell Programming and Scripting

Compare 2 csv files in ksh and o/p the difference in a new csv file

(say) I have 2 csv files - file1.csv & file2.csv as mentioned below: file1.csv ID,version,cost 1000,1,30 2000,2,40 3000,3,50 4000,4,60 file2.csv ID,version,cost 1000,1,30 2000,2,45 3000,4,55 6000,5,70 The... (7 Replies)
Discussion started by: Naresh101
7 Replies

6. Shell Programming and Scripting

csv file to excel issue

Hi, I am trying to attach and email a csv file in the form of an excel sheet. And I have been successful in doing this. But after some days I realised that some fields in the csv file are also having commas because of which this field is getting splitted in columns in the excel sheet. ... (5 Replies)
Discussion started by: girish1428
5 Replies

7. Shell Programming and Scripting

2 problems: Mailing CSV file / parsing CSV for display

I have been trying to find a good solution for this seemingly simple task for 2 days, and I'm giving up and posting a thread. I hope someone can help me out! I'm on HPUX, using sqlplus, mailx, awk, have some other tools available, but can't install stuff that isn't already in place (without a... (6 Replies)
Discussion started by: soldstatic
6 Replies

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

9. Shell Programming and Scripting

Need to compare two csv files values and write into another csv file

Hi all, Am new to scripting. So i just need your ideas to help me out. Here goes my requirement. I have two csv files 1.csv 2.csv abc,1.24 abc,1 def,2.13 def,1 I need to compare the first column of 1.csv with 2.csv and if matches then need to compare... (2 Replies)
Discussion started by: chinnahyd
2 Replies
Login or Register to Ask a Question