I need only First letter from First Name, Last Name & Initial. Is there any way I can create a new field like that. I tried some string functions too.
Eg: Li Xiao Ping is the my field name (Full Name)
I want like LXP as Initials (as seperate field)
You probably need to use SubField function with the separator being a space. Hopefully your data is consistent that way.
The formula that Sumanta gave you looks like it would work if your data is good.
Put this in your script in the Load portion and add AS fieldname to the end. Then this new field will be available to the app without having to recalculate each time in the app.
Thanks @Sumanta. Your solution works for me. Thanks. Since, I didn't mentioned that all the characters in the filed are in capital letters. I marked @Varun ans as correct.
Anyways, your solution resolved my case. Thanks @Sumanta 🙂