Re: Escaping with tr

2005-09-02 Thread Bernard van de Koppel
Hi, Thanks for the warning. As far as the specs are, a semicolon is not allowed as data in the datastream (yet) (of an electronic banking backend application). Some files however don't use the doublequote combined with the semicolon, but just the semicolon to identify fields. So far the se

Re: Escaping with tr

2005-08-30 Thread John W. Krahn
Bernard van de Koppel wrote: > Hi, Hello, > How can I get all the " characters out of a csv file. > > Input looks like > "bla bla";"bla bla";"bla bla" > > and it has to look like > bla bla;bla bla; bla bla > > I tried $text=~ tr(#\"##); $text =~ tr/"//d; John -- use Perl; program fulfillm

Re: Escaping with tr

2005-08-30 Thread Bernard van de Koppel
Hi, Thanks, this works great. Bernard On Tuesday 30 August 2005 23:23, Scott Taylor wrote: > > Hi, > > > > How can I get all the " characters out of a csv file. > > > > Input looks like > > "bla bla";"bla bla";"bla bla" > > > > and it has to look like > > bla bla;bla bla; bla bla > > > > I tried

Re: Escaping with tr

2005-08-30 Thread Scott Taylor
Wiggins d'Anconia said: > Scott Taylor wrote: I did not. >>>Hi, >>> >>>How can I get all the " characters out of a csv file. >>> >>>Input looks like >>>"bla bla";"bla bla";"bla bla" >>> >>>and it has to look like >>>bla bla;bla bla; bla bla >>> >>>I tried $text=~ tr(#\"##); >>>but perl keeps com

Re: Escaping with tr

2005-08-30 Thread Wiggins d'Anconia
Scott Taylor wrote: >>Hi, >> >>How can I get all the " characters out of a csv file. >> >>Input looks like >>"bla bla";"bla bla";"bla bla" >> >>and it has to look like >>bla bla;bla bla; bla bla >> >>I tried $text=~ tr(#\"##); >>but perl keeps complaining about "Might be a runaway multi-line ;;" >

Re: Escaping with tr

2005-08-30 Thread Scott Taylor
Bernard van de Koppel said: > Hi, > > How can I get all the " characters out of a csv file. > > Input looks like > "bla bla";"bla bla";"bla bla" > > and it has to look like > bla bla;bla bla; bla bla > > I tried $text=~ tr(#\"##); > but perl keeps complaining about "Might be a runaway multi-line

Re: Escaping with tr

2005-08-30 Thread Bernard van de Koppel
Eric, thanks for the response. After some fideling, I found a solution. $text=~ tr/\042/ /; Thanks. On Tuesday 30 August 2005 22:20, Eric Walker wrote: > On Tuesday 30 August 2005 04:16 pm, Bernard van de Koppel wrote: > > "bla bla";"bla bla";"bla bla" > > cat test.file | sed 's/\"//g' > editedf

Re: Escaping with tr

2005-08-30 Thread Wiggins d'Anconia
Eric Walker wrote: > On Tuesday 30 August 2005 04:16 pm, Bernard van de Koppel wrote: > >>"bla bla";"bla bla";"bla bla" > > > cat test.file | sed 's/\"//g' > editedfile Quick someone get the can of "UUoC Be Gone" ... ;-) http://danconia.org -- To unsubscribe, e-mail: [EMAIL PROTECTED] For ad

Re: Escaping with tr

2005-08-30 Thread JupiterHost.Net
Eric Walker wrote: On Tuesday 30 August 2005 04:16 pm, Bernard van de Koppel wrote: "bla bla";"bla bla";"bla bla" cat test.file | sed 's/\"//g' > editedfile Good solution for sed list and if you like redirtecting from a pipe and using multiple program when unnecessary (do you also where

Re: Escaping with tr

2005-08-30 Thread Eric Walker
On Tuesday 30 August 2005 04:16 pm, Bernard van de Koppel wrote: > "bla bla";"bla bla";"bla bla" cat test.file | sed 's/\"//g' > editedfile -- Eric Walker EDA/CAD Engineer Work: 208-368-2573 -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]