![]() |
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here. |
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 11:45 PM |
| Howto capture data from rs232port andpull data into oracle database-9i automatically | boss | UNIX for Dummies Questions & Answers | 1 | 09-23-2007 03:35 AM |
| How to store Data in a File | krishna_sicsr | Shell Programming and Scripting | 2 | 06-09-2007 09:23 AM |
| Extracting data from each line | csaha | Shell Programming and Scripting | 1 | 04-27-2006 12:49 AM |
| extracting info from Unix database to construct a visual diagram | fusion99 | UNIX for Advanced & Expert Users | 0 | 11-30-2004 01:29 AM |
![]() |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
||||
|
extracting data and store in database
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 |
![]() |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|