LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stunelson

Having never used a REGEX command previously I'm struggling to understand the syntax and how I use it in LAE.
What I am looking to do is take string "United_States-of|America+2013" and replace all non alphanumeric characters with a space which should leave
me with "United States of America 2013" - I'm sure it is fairly straightforward but a little assistance would be appreciated. Thanks.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

For a full reference on Regular Expressions, check http://perldoc.perl.org/perlre.html
For a "quick guide" check http://en.wikipedia.org/wiki/Regular_expression

For the particular thing you are trying to do, this should work:

s=regexSubstitute(column,"[^A-Za-z0-9]"," ")

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stunelson

Originally posted by: stonysmith
					

For a full reference on Regular Expressions, check http://perldoc.perl.org/perlre.html

For a "quick guide" check http://en.wikipedia.org/wiki/Regular_expression


For the particular thing you are trying to do, this should work:


s=regexSubstitute(column,"[^A-Za-z0-9]"," ")
			

Thanks, this is perfect!
I was slightly out with my brackets.