>Hmmm... this is something I got to analyze carefully, for I feel I got plenty to learn here... ;)
>Thank you both Çetin and Hilmar.
>Ulises
I learned something here, too. In Bata-Bolivia, I let the users type text into an EditBox, using several alternative characters as separators (new-line; comma; semicolon [punto y coma]; or space). To convert this to a single separator, I repeatedly used StrTran() (search and replace). I just realized today that a single call to ChrTran() can replace a whole series of StrTran()!
Something like this:
lcText = strtran(lcText, ",", ";")
lcText = strtran(lcText, " ", ";")
lcText = strtran(lcText, chr(13), ";")
lcText = strtran(lcText, chr(10), ";")
lcText = strtran(lcText, ", " + chr(13) + chr(10), ";;;;")
Note: in the above example, chr(13) + chr(10) will translate to two delimiters, but I have to get rid of repeated delimiters anyway, in case the user types two or more spaces in a row, or leaves a space at the end of the line. This latter part, I believe, is still best done with strtran().
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)