Csv file's line into array help

Dev Shed Forums Sponsor:

November 24th, 2011, 05:58 AM

dusoo

Registered User

Join Date: Sep 2010

Posts: 3

Time spent in forums: 33 m 44 sec
Reputation Power: 0

Csv file's line into array help

Hi,

I need in SunOS bash to parse csv file and work with column values. I have a problem with no-trimmed column values. How can I get rid of the blanks ?

example of csv file:
line1 col_val_1 |line1 col_val 2
line2 col_val_1 |line2 col_val 2

output I have now :
;line1 col_val_1 ;
;line2 col_val_1 ;

output I want to have:
;line1 col_val_1;
;line2 col_val_1;

Is it possible to use sed 's/[ ]*\|/\|/g' before reading lines is started ?
Or better way

Thanks

Code:

...
while read line; do
 IFS="|"
 set $line

 column_1=$1
 column_2=$2

 # do not want to use own trim function here one every column
 # because parsing is too slow

 echo ";${column_1};"

done < $FILE

November 24th, 2011, 06:25 PM

SimonJM

Contributing User

Join Date: Mar 2006

Posts: 2,108

Time spent in forums: 1 Month 1 Week 1 Day 4 h 41 m
Reputation Power: 1485

Why not use nawk for the while thing?
(not tested!)

Code:

nawk -F\| '{printf(";%s;",$1)}' $FILE

You may need to change the ;s to %;

__________________
The moon on the one hand, the dawn on the other:
The moon is my sister, the dawn is my brother.
The moon on my left and the dawn on my right.
My brother, good morning: my sister, good night.
-- Hilaire Belloc

Viewing: Dev Shed Forums > Operating Systems > UNIX Help > Csv file's line into array help

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump