Skip to main content
  • EN

I have a NAME field with a format of 'lastname, firstname'. How to get the lastname using AttributeCreator? I tried Substring() but couldn't find a IndexOf() function. Please help.

You can use a StringSearcher with a Regex.

Or with AttributeCreator try:

@Substring(@Value(NAME),0,@FindString(@Value(NAME),","))

0684Q00000ArKqGQAV.jpg

You can use a StringSearcher with a Regex.

Or with AttributeCreator try:

@Substring(@Value(NAME),0,@FindString(@Value(NAME),","))

0684Q00000ArKqGQAV.jpg

thank you so much! FindString works for me.

Reply


Community Stats

30,121
Posts
114,328
Replies
37,750
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.