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.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.