Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Random text in memo field
Message
From
01/04/2023 15:10:29
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
22/03/2023 13:34:57
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01686399
Message ID:
01686429
Views:
47
>
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform