Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
|
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 print single quote in awk | gauravgoel | UNIX for Dummies Questions & Answers | 6 | 08-20-2008 04:48 PM |
| escaping single quote | javeed7 | Shell Programming and Scripting | 3 | 04-02-2008 05:36 AM |
| single quote | dreams5617 | Shell Programming and Scripting | 2 | 12-01-2007 03:37 AM |
| single or double quote in SED | asami | Shell Programming and Scripting | 2 | 07-17-2006 03:03 AM |
| AWK handling of single quote | braindrain | Shell Programming and Scripting | 3 | 04-27-2006 04:57 PM |
 |
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
12-23-2005
|
||||
|
||||
|
Replacing a single quote
Hi there
I have a data file like so below 'A/1';'T100002';'T100002';'';'01/05/2004';'31/05/2004';'01/06/2004';'08/06/2004';'1.36';'16';'0.22';'0';'0';'1.58';'0';'0';'0';'0';'0';'0';'clientes\resumen\200405\resumen_T10 0002_T100002_1.pdf';'';'0001';'S';'20040501';'';'02';'0';'S';'N' 'A/10';'T1720842';'T1720842';'';'01/06/2004';'30/06/2004';'01/07/2004';'08/07/2004';'15.67';'16';'2.51';'0';'0';'18.18';'0';'0';'0';'0';'0';'0';'clientes\resumen\200406\resumen_T 1720842_T1720842_10.pdf';'';'0001';'S';'20040601';'';'02';'0';'S';'N' I am trying to SQL LOADER it and would like to replace the single quote ' I have tried sed and tr but they both use single quotes in the syntaz. Has anyone got any ideas |
|
12-23-2005
|
|||||
|
|||||
|
Quote:
Code:
echo "'A/1';'T100002';'T100002';'';'01/05/2004';'31/05/2004';'01/06/2004';'08/06/2004';'1.36';'16';'0.22';'0';'0'" | tr -d "'" |
|
12-23-2005
|
||||
|
||||
|
that works thans matey - merry xmas
|
| Sponsored Links | ||
|
|
Linear Mode
