Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Test for ! empty fails
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Test for ! empty fails
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
MS SQL Server
Divers
Thread ID:
01639633
Message ID:
01639633
Vues:
111
Hi everybody,

I have this simple code
replace dc_crdno WITH REPLICATE("*",12) + RIGHT(ALLTRIM(dc_crdno),4) FOR NOT EMPTY(dc_crdno) && IN csrReport
The problem is that I see just 12 * for some rows, so I assume that there may be some unprintable characters in that column. How can I make sure to either show 12* + 4 last digits or show empty value?

Thanks in advance.
If it's not broken, fix it until it is.


My Blog
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform