http://qs321.pair.com?node_id=230379


in reply to Re: Re: Cleaning Data Between Specified Columns
in thread Cleaning Data Between Specified Columns

In that case, there's no need for this line

$tmpString =~ s/(.)'(.)/$1$2/g; # squash apostrophes

As the next line

$tmpString =~ tr/a-zA-Z0-9\n\|\-/ /c; # remove bad characters

will convert them to spaces anyway?


Examine what is said, not who speaks.

The 7th Rule of perl club is -- pearl clubs are easily damaged. Use a diamond club instead.

Replies are listed 'Best First'.
Re: Re: Re: Re: Cleaning Data Between Specified Columns
by enoch (Chaplain) on Jan 28, 2003 at 02:31 UTC
    No, could't do that because I need apostrophe's squashed. For example, I need O'Connor to become OConnor and not O Connor. However, I did need something like you@you.com to become you you.com.

    Weird requirements, I know. I am going to play around with what Fletch did here and see what I can come up with.

    Thanks, everyone,
    enoch