MFLD Mike Posted September 26, 2023 Share Posted September 26, 2023 Hi, I know this must seem very simple, but I’m new to this and need a space after a comma (,) rule. Can anyone help please? thanks for your time Quote Link to comment Share on other sites More sharing options...
Alex Marshall Posted September 26, 2023 Share Posted September 26, 2023 if(Field("First Name")!="") return Field("First Name") + ' ' + "," else return ""; Quote Link to comment Share on other sites More sharing options...
MFLD Mike Posted September 26, 2023 Author Share Posted September 26, 2023 Hey thank you. The only thing it’s adding after the fact. They is what I have. A list of thousands of names with last name comma first name (Jones,Sam) I need a space after the (,Sam) sorry I didn’t explain it well enough mike Quote Link to comment Share on other sites More sharing options...
Alex Marshall Posted September 26, 2023 Share Posted September 26, 2023 Try the following script: XV = ReplaceSubstring(Field("Full Name"), "," , "," +' ') return XV; This script replaces it with a space after the comma. Quote Link to comment Share on other sites More sharing options...
MFLD Mike Posted September 26, 2023 Author Share Posted September 26, 2023 Thank you so much! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.