AnsweredAssumed Answered

Trim Phone Number and wildcard search

Question asked by JoeMintz on May 1, 2012
Latest reply on May 2, 2012 by philmodjunk

Title

Trim Phone Number and wildcard search

Post

So I am trying to trim and wildcard search a phone number, so that it will find it by looking at the numbers in that specific order.

For example, whether someone enters (123) 456 7890, 123-456-7890, (123)-456-7890 or 123 456 7890, I want to be able to first:

a) Eliminate all special characters ), (, -, etc

b) Trim(All) (Which I already know how to do)

To make the result: 1234567890

c) Then I want to insert * before and after every digit so it results in this: *1*2*3*4*5*6*7*8*9*0

I've tested the result, and this searches for the correct number regardless of how it was input in the system.

Can anyone help me with steps a) and c)?

Thank you.

Outcomes