View topic - Regex assistance with US zip codes • AutoHotkey Community

View unanswered posts | View active topics

Board index » AutoHotkey » Support

All times are UTC [ DST ]

Regex assistance with US zip codes

Page 1 of 1

[ 3 posts ]

Print view | E-mail friend

Previous topic | Next topic

Author

Message

bqw371

Post subject: Regex assistance with US zip codes

Posted: January 15th, 2010, 6:41 am

Joined: November 26th, 2008, 4:16 pm
Posts: 32

Hi all. I need assistance creating a regex to remove commas that should not have been entered into number sets (U.S. zip codes).

,11778, - This is a valid zip code within a CSV file.
,1,0566, - Invalid - Should be ,10566,
,30,052, - Invalid - Should be ,30052,
,113,61, - Invalid - Should be ,11361,
,1177,8, - Invalid - Should be ,11778,

Any help would be appreciated

Top

jaco0646

Post subject:

Posted: January 15th, 2010, 7:12 am

Joined: October 7th, 2006, 4:50 pm
Posts: 3157
Location: MN, USA

Code:

var =
(
,11778, - This is a valid zip code within a CSV file. 
,1,0566, - Invalid - Should be ,10566, 
,30,052, - Invalid - Should be ,30052, 
,113,61, - Invalid - Should be ,11361, 
,1177,8, - Invalid - Should be ,11778,
)
MsgBox,% RegExReplace(var,"(,\d{1,4}),","$1")

Top

bqw371

Post subject:

Posted: January 15th, 2010, 7:19 am

Joined: November 26th, 2008, 4:16 pm
Posts: 32

jaco0646,

Thank you friend! This will help immensely!!
Works as expected

Top

Page 1 of 1

[ 3 posts ]

Board index » AutoHotkey » Support

All times are UTC [ DST ]

Who is online

Users browsing this forum: bobbysoon, iDrug, JSLover, Tipsy3000, Yahoo [Bot] and 21 guests

You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum