Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Random text in memo field
Message
De
01/04/2023 15:10:29
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
22/03/2023 13:34:57
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01686399
Message ID:
01686429
Vues:
48
>
>DescOnly = CHRTRAN(MemoField,'0123456789$','')
>
>
>However, if you might have commas and periods, it gets harder because those can appear in the descriptions, too. In that case, loop through the possible start characters for the price, using AT() to find out where that part starts. Then grab the front of the string.
>
>One other idea. If you can be sure the price part has no embedded spaces, use RAT() to find the rightmost space and keep everything in front of that.

Actually, paste from Excel, unless they fixed it again meanwhile, is tab delimited. So alines() with regular parameters first to get a row of lines, then loop through the lines to split it into values with alines(... chr(9)).

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform