I have a confiform field definition with field User. So i got user name as Snow, John2 [ABC] Or aa0000. I want only to return John in Display or confiform table view.
I want something different
For eg
Full name : Medved, Alex23[CONF]
Output : Alex
I am trying this in the formula but getting error Unknown operator at position 46
IF(EMPTY(SPLIT(REGEXREPLACE([entry.Name.fullName], "\[?\d+\]?", ""), ",")[1]),
SPLIT(REGEXREPLACE([entry.Name.fullName], "\[?\d+\]?", ""), ",")[0].strip(),
SPLIT(REGEXREPLACE([entry.Name.fullName], "\[?\d+\]?", ""), ",")[1].strip()
)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
FirstName= [entry.Name.fullName.replaceAll('.*?\\,\\s(\\D+?)(\\d|\\s|\\[).*', '$1')].
FirstName=[entry.OwnerName.split(", ")[1].replaceAll('[\\d\\[\\]]', '').split(' ')[0]]
It is also not working after IFTTT macro
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.