extracting data and store in database - Shell Programming and Scripting

mam · #1 01-25-2008

Hello all,
I have this text file data. The data are separated by comma in three column and space or line feed to start a new row

Code:

anderson helberg, Jane, brother
Sister ,mother,grandpa
bombay,new york, china

I would like store them in the following format.

Code:

field1                           field2                              field3
anderson helberg              Jane                               brother
bombay                         new york                         china

my problem is how to implemet the script with both line feed or single space or multiple space and comma separator to separate the rows and stores the data as shown above.
by using cut and delimiter.

Code:

anderson helberg=`echo "$text" | cut -f 1 -d','`

please anyone with help appreciated

Smiling Dragon · #2 01-28-2008

Your example doesn't match the description though,,, 'space or line feed to start a new row' isn't what you show. Your example shows it starting a new row on line feed only, and treating space as part of the field.
I'll use the output (ie line feed seperation only) as the goal here.

You can cheat and just use sed to substitute commas for tabs but it won't make a very pretty layout.
Otherwise, printf would probably be the way to go here:

Code:

#!/bin/sh
printf "%10s    %10s    %10s\n" "field1" "field2" "field3"
while read line
do
    printf "%10s    %10s    %10s\n" "`echo $line | cut -d ',' -f 1`" "`echo $line | cut -d ',' -f 2`" "`echo $line | cut -d ',' -f 3`"
done

manas_ranjan · #3 01-29-2008

Can you try this out
(You have to work out in order to format properly)
echo "field1 field2 field3"
while IFS="," read a b c
do
echo "$a $b $c"
done < FileName

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to store the data retrived by a select query into variables?	jisha	Shell Programming and Scripting	12	01-17-2008 08:45 PM
Howto capture data from rs232port andpull data into oracle database-9i automatically	boss	UNIX for Dummies Questions & Answers	1	09-22-2007 11:35 PM
How to store Data in a File	krishna_sicsr	Shell Programming and Scripting	2	06-09-2007 05:23 AM
Extracting data from each line	csaha	Shell Programming and Scripting	1	04-26-2006 08:49 PM
extracting info from Unix database to construct a visual diagram	fusion99	UNIX for Advanced & Expert Users	0	11-29-2004 10:29 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode