Forum Discussion
building strings
Hello Community, i'm trying to build an email from a colmun with full names. Right now i'm using substitute to replace all blank spaces with a dot and then i add the domain name. But since there ...
You can use a third argument in SUBSTITUE to dictate the occurance that you want to substitue =SUBSTITUTE([name]," ","_",2)
I'd use a switch that checks the number of time a space occurs LEN([name])-LEN(SUBSTITUTE([name]," ","")) then have a result for 1 space or 2.
You can use a third argument in SUBSTITUE to dictate the occurance that you want to substitue =SUBSTITUTE([name]," ","_",2)
I'd use a switch that checks the number of time a space occurs LEN([name])-LEN(SUBSTITUTE([name]," ","")) then have a result for 1 space or 2.
Oh wow that was more easy then i thought, i used the Substitute solution with the second argument and that fullfills my needs. Thanks!