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

[download]

As the next line 

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

[download]

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
[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom