RegEx Replace in Expressions

Avatar

Avatar
Validate 10
Level 2
eriku40433679
Level 2

Likes

10 likes

Total Posts

33 posts

Correct reply

2 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 2
eriku40433679
Level 2

Likes

10 likes

Total Posts

33 posts

Correct reply

2 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
eriku40433679
Level 2

07-08-2017

Hi all,

I need to clean up a varchar phone number of all non-numerical characters to compare against the SMS logs. I was wondering if there was a way to do so easily, maybe preprocessing or a computed field?

Thanks!

--Erik

View Entire Topic

Avatar

Avatar
Validate 10
Level 2
eriku40433679
Level 2

Likes

10 likes

Total Posts

33 posts

Correct reply

2 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 2
eriku40433679
Level 2

Likes

10 likes

Total Posts

33 posts

Correct reply

2 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
eriku40433679
Level 2

13-08-2017

Thanks Florent. If that's the case, maybe I can have a script read in the results of the query and have it write to a new column after processing, and use that for the comparison? Does the javascript engine used by AC have regular expressions implemented? Actually I'll make a quick check. hahaha!

Cheers!

--Erik