Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options

Re: Re: Cleaning Data Between Specified Columns

by enoch (Chaplain)
on Jan 27, 2003 at 22:17 UTC ( #230370=note: print w/ replies, xml ) Need Help??

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


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.


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 (Pope) 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

    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.

      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 to become you

      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,

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://230370]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (2)
As of 2016-02-07 02:39 GMT
Find Nodes?
    Voting Booth?

    How many photographs, souvenirs, artworks, trophies or other decorative objects are displayed in your home?

    Results (241 votes), past polls