Regular Expression code

Help Studio
1

I have attached a .txt file of loss information sample data. Im trying to write a regual expression that will take the state and the zipcode. The autoamtion runs through emails that have this type of information. What would be a good regular expression to get the state from each loss information and another to get the zipcode from the loss information?

Regular Expression.txt (729 Bytes)
[Regular Expression.txt|attachment]

(upload://jPIxzgmZiCd6YI7o4NR711JXLFB.txt) (729 Bytes)

2

@NATHAN_MORA

Check below for your reference

image
image735×352 10 KB

Regex:(?<=, ).+

Hope this may help you

Thanks

3

That may not work if there are other commas used elsewhere. Also it doesn’t separate state and zip into 2 different matches.

Here’s a more accurate pattern for the state:

(?<=, )\w{2}(?= \d{5})

Here’s the pattern for the zip:

(?<=, \w{2} )\d{5}
1 Like
4

Hi Nathan. More precise regex should include possible values in state abreviation. Use the following:

(AL|AK|AZ|AR|CA|CO|CT|DE|DC|FL|GA|HI|ID|IL|IN|IA|KS|KY|LA|ME|MD|MA|MI|MN|MS|MO|MT|NE|NV|NH|NJ|NM|NY|NC|ND|OH|OK|OR|PA|RI|SC|SD|TN|TX|UT|VT|VA|WA|WV|WI|WY)\s\d{5}

Hope it helps!

5

Dokumentor,
Thanks for this i was just having a issue with this, i would i implement this code?

6

When i do fetch the state for example CA for California i have to add that in a state box. the issue is the state box wants the full state name. so if i pull the state CA from the text file i have to type the state California in the text box. Any ideas ?

7

Sorry. I’ve just corrected it

8

Populate a dictionary of State Names using abbreviation as key, so when you have to input state you get that value

9

This code takes the Stat and the zip is there a way it can just take the state and not the zip?

10

Yes, remove the last part \s\d{5}

11

How would i populate a dictionary to achieve this issue?

12

Here is an example

POPULATE_DICT.xaml (7.4 KB)

It works with this excel file

us_states.xlsx (9.7 KB)

1 Like
13

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.