Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Test for ! empty fails
Message
 
 
To
18/08/2016 12:08:44
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
MS SQL Server
Miscellaneous
Thread ID:
01639633
Message ID:
01639636
Views:
83
This didn't work - need to figure out what is in these empty rows.

>Hi Naomi,
>
>using VFP9
>
>
>FOR NOT EMPTY(trim(dc_crdno, chr(9), chr(10), chr(13), chr(32), chr(160)))
>
>
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform