Hello - I am trying to build a string that converts Full Name to Username. For example I have John Smith in a field and would like to extract jSmith. What should be the correct syntax?
Use Regular expression action:
If you use a combination of a Regular expression to split based on space character and then fn-Substring('your text',1,1) to get the first character in a Build string action you should be fine.
Works flawlessly!!! Thanks!
Retrieving data ...