On 8/15/01 4:28 PM, Clinton wrote:
> Hi
> I'm reading data from MSAccess, joining 2 fetched values with a comma and
> writing to another table. The data seems to be padded. My resultant column
> shows some space between the two values eg
> valuefromFirstcolumn , valuefromSecondcolumn
>
> I have tried applying a regex
> $valuefromFirstcolumn =~s/W+$//;
> &
> $valuefromFirstcolumn =~s/s+$//;
> with no success.
> Assistance appreciated.
> Regards
> CCJ
>
Erm, you want to remove W's and S's at the end of $valuefromFirstcolumn? If
you're trying to remove all non-word characters, you'd say:
$valuefromFirstcolumn =~s/\W+//g;
But I don't think that's what you want, as you'd end up with
valuefromFirstcolumnvaluefromSecondcolumn
from your example. I'm not sure quite what you want, but you might want to
try
$valuefromFirstcolumn =~s/\s+//g;
which should be self explanatory.
I recommend buying and reading the camel book ("Programming Perl, 3rd ed.",
by Larry Wall, Tom Christiansen, and Jon Orwat). It has a nice big chapter
on regexes.
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
