|
|
|
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 generate a pipe ( | ) delimited file? | anushree.a | Shell Programming and Scripting | 5 | 10-15-2008 03:35 AM |
| How to split pipe delimited file | njgirl | Shell Programming and Scripting | 4 | 06-18-2008 06:15 PM |
| how to convert Fixed length file to delimited file. | satyam_sat | Shell Programming and Scripting | 7 | 04-03-2008 03:41 AM |
| splitting a pipe delimited file in unix | ddedic | Shell Programming and Scripting | 4 | 03-20-2007 01:16 AM |
| Grep for NULL in a pipe delimited file | sureshg_sampat | Shell Programming and Scripting | 5 | 11-21-2006 06:15 AM |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
02-12-2009
|
||||
|
||||
|
Convert CSV file (with double quoted strings) to pipe delimited file
Hi,
I want to convert a CSV file to pipe delimited file, in Unix shell command. Most of the string and date fields will be in double quotes. Ideally, want to do it with single sed command. If not possible then, with minimum possible commands on Unix command prompt (using all possible things like sed, awk etc etc) Don't want to write a Perl script. E.g. if input line is 100,"ksjdh",20,,"19-Jan-2009","my,name,is,",0 That should become 100|ksjdh|20||19-Jan-2009|my,name,is,|0 All commas inside double quotes should be there. Blank fields may or may not have double quotes. Numbers will not have double quotes. Can anybody please help. Thanks in advance. |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Threaded Mode
