Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Replacing a single quote
Top Forums Shell Programming and Scripting Replacing a single quote Post 93933 by vgersh99 on Friday 23rd of December 2005 09:29:06 AM
Old 12-23-2005
Quote:
Originally Posted by rjsha1
Hi there
I have a data file like so below
Code:
'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_T100002_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_T1720842_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
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 "'"

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

single quote

Hi I have a shell script with many lines as below: comment on column dcases.proj_seq_num is dcases_1sq; .... .... I want the above script to be as below: comment on column dcases.proj_seq_num is 'dcases_1sq'; I want to have single quotes like that as above for the entire shell... (2 Replies)
Discussion started by: dreams5617
2 Replies

2. Shell Programming and Scripting

escaping single quote

hi, echo 'abc' will give output abc how can i get output as 'abc' plz help. thanks in advance (3 Replies)
Discussion started by: javeed7
3 Replies

3. Shell Programming and Scripting

Regex in grep to match all lines ending with a double quote (") OR a single quote (')

Hi, I've been trying to write a regex to use in egrep (in a shell script) that'll fetch the names of all the files that match a particular pattern. I expect to match the following line in a file: Name = "abc" The regex I'm using to match the same is: egrep -l '(^) *= *" ** *"$' /PATH_TO_SEARCH... (6 Replies)
Discussion started by: NanJ
6 Replies

4. Shell Programming and Scripting

Replacing the string after certain # of double quote

Could you please help in unix scripting for below scenario... In my input file, there might be a chance of having a string ( Ex:"99999") after 5th double quote for each record. I need to replace it with a space. Ex : Input : "abcdef","12345","99999","0986"... (3 Replies)
Discussion started by: vsairam
3 Replies

5. Shell Programming and Scripting

replacing a quote in some lines with multiple quote fields

i want to replace mistaken quotes in line starting with tag 300 and relocate the quote in the correct position so the input is 223;25 224;20100428064823;1;0;0;0;0;0;0;0;8;1;3;9697;18744;;;;;;;;;;;; 300;X;Event:... (3 Replies)
Discussion started by: wradwan
3 Replies

6. Shell Programming and Scripting

Replace single quote with two single quotes in perl

Hi I want to replace single quote with two single quotes in a perl string. If the string is <It's Simpson's book> It should become <It''s Simpson''s book> (3 Replies)
Discussion started by: DushyantG
3 Replies

7. Shell Programming and Scripting

Replacing trailing space with single quote

Platform : RHEL 5.8 I want to end each line of this file with a single quote. $ cat hello.txt blueskies minnie mickey gravity snoopyAt VI editor's command mode, I have used the following command to replace the last character with a single quote. ~ ~ ~ :%s/$/'/gNow, the lines in the... (10 Replies)
Discussion started by: John K
10 Replies

8. Shell Programming and Scripting

Replacing Double Quote in Double Quote incsv file

Hi All , We have source data file as csv file and since data could contain commas ,each attribute is quoted into double quotes.However problem is that some of the attributa data also contain double quotes which is converted to double double quote while creating csv file XLs data : ... (2 Replies)
Discussion started by: Shalini Badal
2 Replies

9. Shell Programming and Scripting

Replacing all but the first and last double quote in a line with a single quote with awk

From: 1,2,3,4,5,This is a test 6,7,8,9,0,"This, is a test" 1,9,2,8,3,"This is a ""test""" 4,7,3,1,8,"""" To: 1,2,3,4,5,This is a test 6,7,8,9,0,"This; is a test" 1,9,2,8,3,"This is a ''test''" 4,7,3,1,8,"''"Is there an easy syntax I'm overlooking? There will always be an odd number... (5 Replies)
Discussion started by: Michael Stora
5 Replies

10. Shell Programming and Scripting

Single quote _error_.

Hi all... (This is Don's domain.) I have come across an anomaly in sh and dash compared to bash. It involves echoing a character set to a file in sh and dash compared to bash. It is probably easier to show the code and results first. #!/usr/local/bin/dash #!/bin/sh #!/bin/bash echo... (4 Replies)
Discussion started by: wisecracker
4 Replies

LEARN ABOUT DEBIAN

upgrade-system

UPGRADE-SYSTEM(8)						 Debian GNU/Linux						 UPGRADE-SYSTEM(8)

NAME

       upgrade-system - Command for upgrading and sanitizing a Debian system

SYNOPSIS

       upgrade-system

DESCRIPTION

       upgrade-system  is  an  APT  front-end  that simplifies regular upgrading of Debian systems, only requiring an administrator's intervention
       whenever updated packages necessitate the configuration of new features.

USAGE

       upgrade-system is run from the command line shell by the administrator. It performs the following actions:

       o  Resynchronize the list of available packages.

       o  Upgrade all packages to their newest version.

       o  Remove all obsolete package dependencies.

       o  Clean retrieved archives off the APT cache.

ENVIRONMENT

       Setting the FLAUSCH environment variable enables useful advanced system sanitization features. See upgrade-system.conf(5) for more details.

FILES

       /etc/upgrade-system.conf

AUTHORS

       Copyright (C) 2003-2004 Martin Zdrahal <martin.zdrahal@konflux.at>
       Copyright (C) 2004,2012 Christoph Schindler <hop@30hopsmax.at>
       Copyright (C) 2004-2012 Martin-Eric Racine <martin-eric.racine@iki.fi>

LICENSE

       GPLv2+: GNU GPL version 2 or later <http://gnu.org/licenses/gpl.html>.

SEE ALSO

       apt(8), upgrade-system.conf(5).

http://q-funk.iki.fi						    2004-02-16							 UPGRADE-SYSTEM(8)
All times are GMT -4. The time now is 08:21 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy