Issues with Substring search

Krish_Penubarthi

Hi.

I need to search for a particular keyword in my string and extract data accordingly. The string is ' ' (space).

Example : If the name column has Robert it should give me Rob and if it has got Dave Paul, i should return DPau. 

I am not able to get the solution for this. 

Also, I need to skip the spaces if any at last as well.

Thanks!!

OllieClarke

The following formula uses the CONTAINS() function to search for a space and parses the names according with what you wanted.

IF !CONTAINS(TRIM([Field1]),' ') THEN Left(TRIM([Field1]),3)
ELSE REGEX_Replace(TRIM([Field1]),'(\w).*?\s(\w{3}).*','$1$2')
ENDIF

As it uses regex, there are some in built assumptions - namely that the field will only ever have 1 space in it, between the first and second word. The TRIM() function removes any trailing or leading white space

for krish.yxmd