Re: Re: Cleaning Data Between Specified Columns

++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
[download]

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

enoch

Comment on Re: Re: Cleaning Data Between Specified Columns Download Code

Replies are listed 'Best First'.
Re: Re: Re: Cleaning Data Between Specified Columns by BrowserUk (Patriarch) on Jan 27, 2003 at 22:26 UTC
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.	[reply] [d/l] [select]
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]