homepage Welcome to WebmasterWorld Guest from 23.23.22.200
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Subscribe to WebmasterWorld
Home / Forums Index / Code, Content, and Presentation / Perl Server Side CGI Scripting
Forum Library, Charter, Moderators: coopster & jatar k & phranque

Perl Server Side CGI Scripting Forum

    
Search and replace trouble.
Jesse_Smith




msg:4286644
 1:52 am on Mar 24, 2011 (gmt 0)

I got

-###.####,##.###,"Doe, John & Jane","### Main St","Town, State 13370",,,
-###.####,##.###,"Doe, John","### Main St,"Town, State 13370",,,

and I'm trying to change them to

-###.####,##.###,"John & Jane Doe","### Main St","Town, State 13370",,,
-###.####,##.###,"John Doe","### Main St","Town, State 13370",,,

just messing with the name part. I got

$code =~ s*&*4645654*g;
$code =~ s*.([^&]+?),"([^&]+?), ([^&]+?)","*.$1,"$3 $2","*g;
$code =~ s*.([^&]+?),"([^&]+?), ([^&]+?) 4645654 ([^&]+?)"*.$1,"$3 4645654 $4 $2"*g;
$code =~ s*4645654*&*g;

but it's not even close to doing it right. It for example, moves the last name to right before the town name, replaces part of the street number to a period, and moves the Town name to after the Zip code. How do you get it to only mess with the

.NUMBER,"John & Jane Doe","NUMBER
.NUMBER,"Doe, John","NUMBER

part and change it right!

 

janharders




msg:4286792
 10:45 am on Mar 24, 2011 (gmt 0)

### stands for NUMBER?

I believe
$string =~ s/(\d+),"([^,]+), ([^"]+)","/$1,"$3 $2","/gis;
should do the job, but maybe I missed something...

KwikDrySystems




msg:4321028
 12:48 pm on Jun 2, 2011 (gmt 0)

I'm assuming the ### is the ip address? If so, janharders comment should fix the problem. If not, let us know and we'll figure it out.

[edited by: engine at 1:00 pm (utc) on Jun 2, 2011]
[edit reason] promo [/edit]

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Perl Server Side CGI Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved