Removing delimiter

[brkstr]

Hello all
I am having trouble trying to remove a "," delimiter from a .txt file. testdata.txt has data that is delimited (",") and I want to remove the delimiter.
Awhile ago you all helped me with code examples. i.e.

perl -pi.bak 's/,//' file.out
and 
$line =~ tr/,//d;

My script looks like

#!c:perl\bin\perl.exe

perl -pi.bak 's/,//' testdata.txt

#$line =~ tr/,//d;

I have been playing with variations of the code. But me being new to this I know I am missing something. A push in the right direction would be greatly appreciated.

Thanks
Scott

[helgi]

You're getting two things mixed up. The code you were using is meant to be run from the command line, not inside a script. Your script should look something like:

#!C:/Perl/bin/perl.exe -pi.bak

tr/,//d;

And run it like so:

C:\>script.pl testdata.txt

I hope this helps. This of course assumes that you just want to remove the commas and not replace them with anything else.

[thinker]

Hi brkstr,

The following should do what you ask, leaving the original file in FILENAME.bak

perl -pi.bak -e 's/,//g' FILENAME

Hope this helps

thinker

[brkstr]

thinker & Helgi,

Thanks your suggestions helped. Also helgi, your clarification about how it was ran cleared a lot of confusion.

Thanks again
Scott

[inman]

You might want to look at the module Text::CSV. It should help you process comma delimited data that contains escaped commas as part of the data value.

... but if your data is simple then stick with the substitution mentioned earlier.

Inman