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.
Solved
attributecreator split a string by comma
Best answer by mark_f
You can use a StringSearcher with a Regex.
Or with AttributeCreator try:
@Substring(@Value(NAME),0,@FindString(@Value(NAME),","))
+2You can use a StringSearcher with a Regex.
Or with AttributeCreator try:
@Substring(@Value(NAME),0,@FindString(@Value(NAME),","))
mark_f wrote:
You can use a StringSearcher with a Regex.
Or with AttributeCreator try:
@Substring(@Value(NAME),0,@FindString(@Value(NAME),","))
thank you so much! FindString works for me.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.