General information
Category:
Coding, syntax & commands
Thank you very much for your suggestion. I actually will use a combination of your code with a slight modification and the code that Hilmar suggested earlier.
I need to do this in case the “ “ is an only delimiter, and then by using your code it would replace it with an empty string and will result in an incorrect address.
lcDelims = ",:/" && all the delimiters you want changed
lcChangeTo = ";"
lcEmail = ChrTran(lcEmail, lcDelims + " ", Replicate(lcChangeTo, Len(lcDelims)+1))
do while ";;" $ lcEmail
lcEmail = StrTran(lcEmail, ";;", ";")
enddo
Thank you again to everybody
Yelena
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only