Information générale
Catégorie:
Codage, syntaxe et commandes
Hi Sean,
>I have solved my many DB connectivity problems and was wondering what function I would use to locate a character in a field and replace it with something else ie make smith,charles smith charles or something like that. TIA
You have two choices, CHRTRAN() and STRTRAN().
Chrtran() is faster because it only does searches for one character:
lcText = chrtran('smith, charles', ',', '')
returns "smith charles". It also replaces every found occurenece:
lcText = chrtran('s,m,i,th, charles', ',', '')
also returns "smith charles"
Strtran() can find and replace whole strings with whole strings, look in the help for more info.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement