get rid of whitespace around pipes??

[Jeff 'Japhy' Pinyan]

On Dec 17, LoneWolf said:

>I am parsing a massive file line by line and cleaning it up. It has about
>15 fields, all separated by | and I want to remove the white space from
>before and after the pipes so that as the information is parsed it gets rid
>of external white spaces from the string and such.

Then split on /\s*\|\s*/. That regex reads "zero or more whitespace, a |,
then zero or more whitespace".

@fields = split /\s*\|\s*/, $line;

--
Jeff "japhy" Pinyan [email]japhy@pobox.com[/email] [url]http://www.pobox.com/~japhy/[/url]
RPI Acacia brother #734 [url]http://www.perlmonks.org/[/url] [url]http://www.cpan.org/[/url]
<stu> what does y/// stand for? <tenderpuss> why, yansliterate of course.
[ I'm looking for programming work. If you like my work, let me know. ]

[Randy W. Sims]

On 12/17/2003 11:26 AM, LoneWolf wrote:

> I am parsing a massive file line by line and cleaning it up. It has about
> 15 fields, all separated by | and I want to remove the white space from
> before and after the pipes so that as the information is parsed it gets rid
> of external white spaces from the string and such.
>
> Some fields are numbers, others are strings, and a couple are arrays.
>
> sample:
> 1|AA-1202 |12in. X10.75 FOIL SHEETS 12/200| 70.96 | 46.40 | 45.24 | 44.13
> |246|3| 55.000 | .000 | .000 |A |AA-1202
> 2| AA-1205 |12in. x10in. FOIL POPUP SHEETS 6/500| 96.61 | 63.17 | 61.59 |
> 60.09 |246|3| 25.000 | 6.000 | .000 |B | AA-1205

my @fields = split /\s*\|\s*/, $line;

[James Edward Gray II]

On Dec 17, 2003, at 10:26 AM, LoneWolf wrote:

> I am parsing a massive file line by line and cleaning it up. It has
> about
> 15 fields, all separated by | and I want to remove the white space from
> before and after the pipes so that as the information is parsed it
> gets rid
> of external white spaces from the string and such.

Try something like:

my @fields = split /\s*\|\s*/, $line;

Good luck.

James

[Lonewolf]

I am parsing a massive file line by line and cleaning it up. It has about
15 fields, all separated by | and I want to remove the white space from
before and after the pipes so that as the information is parsed it gets rid
of external white spaces from the string and such.

Some fields are numbers, others are strings, and a couple are arrays.

sample:
1|AA-1202 |12in. X10.75 FOIL SHEETS 12/200| 70.96 | 46.40 | 45.24 | 44.13
|246|3| 55.000 | .000 | .000 |A |AA-1202
2| AA-1205 |12in. x10in. FOIL POPUP SHEETS 6/500| 96.61 | 63.17 | 61.59 |
60.09 |246|3| 25.000 | 6.000 | .000 |B | AA-1205


TIA!!

Robert