I have a 'Single Line of Text' field in my table. It contains names. While doing some operations, if some one enters the nae as "last name, first name", the function isn't working due to the comma. Is there a way I can remove the comma from the field? I want to make it last name [space] first name which will also be ok. Just need to remove the "Comma" from the text entered by the user.
Remove Comma from Single Line of Text
Using Advance Preview I used the following:
1) create a variable with the formula replace([Form].[FullName],","," ")
2) create an On Form Input rule:
if FullName is filled then FullName value is assigned the variable
Known issue: When editing the field contents and the text length is unchanged then the Rule is NOT triggered
Otherwise this works.
Another method is through the Workflow to use the action "Replace Substring in String". This will always work but only after the user has submitted the form.
1) create a variable with the formula replace([Form].[FullName],","," ")
2) create an On Form Input rule:
if FullName is filled then FullName value is assigned the variable
Known issue: When editing the field contents and the text length is unchanged then the Rule is NOT triggered
Otherwise this works.
Another method is through the Workflow to use the action "Replace Substring in String". This will always work but only after the user has submitted the form.
+12I would suggest to use the people group control instead of SLT....this way you can have assurance that users are providing correct names. For e.g. what if someone write names in LN, FN; FN, LN; FN LN; FN,LN; etc.
This won't give correct information about the name. It's best to use the PG control and then you can use userprofilelookup control or workflow action to get desired values and manipulate your process.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.