Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Easy way to pluck these characters from memo field?
Message
 
To
17/07/2002 14:44:23
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00679569
Message ID:
00681487
Views:
17
But be carefull with the ALINES() Command.
It does not recognize chr(10) or chr(13) alone. And it does happen, that these are NOT saved in your MEMO Field together. Then it happened that you only have 2 LINES instead of 3.
So you would have to

Using the sample:

local lcContent
USE test2 && test table with memofield called test

**********************************************************
*Because there is a bug in the ALINES() Command
*you have to correct the CARRIAGE RETURN+ LINEFEEDS
**********************************************************
lcContent = strtran(test2.test,chr(13)+chr(10),chr(13) )
lcContent = chrtran(lcContent,chr(10),chr(13) )
lcContent = strtran(lcContent,chr(13),chr(13)+chr(10))
**********************************************************

x=ALINES(larray,lcContent)


FOR i = 1 TO x
? SUBSTR(larray[i],RAT('-',larray[i])+1)
ENDFOR
Marvin Blase (tA-logistic Software GmbH)
You'll never notice the good things if you haven't seen the bad.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform