Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Easy way to pluck these characters from memo field?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00679569
Message ID:
00679720
Vues:
28
This message has been marked as the solution to the initial question of the thread.
Steve,

Here is a simple example:
USE test2 && test table with memofield called test

x=ALINES(larray,test2.test)

FOR i = 1 TO x
	? SUBSTR(larray[i],RAT('-',larray[i])+1)
ENDFOR
>Here is the contents of my memo field. My question follows the memo field text.
>
>--- At: 06/10/2002 14:49:04 By: 550162 Walker,Sandy  ------------ CALL WAS FROM 1429 UNTIL 1450.
>--- At: 06/10/2002 14:32:25 By: 550162 Walker,Sandy  ------------ MCO HUDAK ON SCENE WITH R34 WORKING CODE.
>
>I want to pluck the text that is all CAPS from the two sentences that are contained in the memo field and drop the rest of the characters when I print the report. I am building a cursor while I SCAN the table records and at that point in time I can pluck the characters from the memo field.
>
>Is there an easy way to do this? Look for all CAPS?
>Look for dashes "-----------"?
>
>Your ideas are welcome. Thanks so much.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform