General information
Category:
Coding, syntax & commands
>>Hi all
>>I have to run a scan/endscan on table and to do the following changes in memo field: if the first letter is chr(10) (empty line/paragraph) remove this line (all the other lines will go up one line).
>>Help please
>
>Replace all yourfield with substr(yourfield,2) for yourfield=chr(10)
If you are using VFP 9 you might be able to use LTRIM().
Replace all yourfield with LTRIM(yourfield,0,chr(10)) for yourfield=chr(10)
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only