Re: Re: Cleaning Data Between Specified Columns

[enoch]

++BrowserUK!

I was bitten by my squashing of apostrophes. Because it was a fixed width file, squashing the apostrophes caused the width's to change. I changed the regex to:

s/(.)'(.\B*)/$1$2 /g

So, that spacing was added for each apostrophe I pulled from any field.

enoch

[BrowserUk]

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.

[enoch]

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 [e-mail] 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