Information générale
Catégorie:
Codage, syntaxe et commandes
>>I have a character field zip c(5) containing zipcodes. I need to set a filter to select the bad entries which contain alpha characters. This is done in Access code using the LIKE function (not like('#####'), but VFP handles LIKE differently. This would also seem to be a simple matter but I can't seem to find the answer. I could find a bad entry by parsing the values but that doesn't serve my need to set a filter.
>>
>>Any thoughts?
>
>Here's another one:
>
>set filter to chrtran(zipcode, "0123456789","9999999999")#"99999"
Very nice! Much better than my suggestion!
Précédent
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