AnsweredAssumed Answered

How To Search for a space using PX

Question asked by drewkoenig on Aug 7, 2013
Latest reply on Aug 8, 2013 by drewkoenig
I generate userids from a combo of First Name and Last Name. A new quirk popped up with offshore names that have two Last Names.

My current PX generates userids as [LName][First Initial][Unique Counter] = dkoenig01, smithb01, smithb02, etc...

But if we have an offshore person with two surnames, Rao Yadama, then the user id is "rao yadamas01"

Because we can't have spaces in the userid I tried to use PX to trim the LName by searching for the space and taking the 'second' Last name.
However it appears PX doesnt like to search for spaces.

How do you search for a space in a string?

Outcomes