Most streamlined method to get data

[Mark Smith]

That was brilliant. Relatedly, why does “ the last word” not return $8,303.32 since it is delimited by quotes (and the dictionary says, "A word is delimited <> by one or more spaces, tabs, or returns, or enclosed by double quotes <>." <>, and is there a list of “unicode word breaks” lying around somewhere?

Thanks...
Mark


> On Jul 29, 2021, at 2:10 PM, Colin Kelly via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> Put the last trueword of yourVariable
> 
> That should do what you need ☺
> 
> Col.
> 
> From: use-livecode <use-livecode-bounces at lists.runrev.com> on behalf of Craig Newman via use-livecode <use-livecode at lists.runrev.com>
> Date: Thursday, 29 July 2021 at 13:56
> To: How to use LiveCode <use-livecode at lists.runrev.com>
> Cc: Craig Newman <craig at starfirelighting.com>
> Subject: Re: Most streamlined method to get data
> Ugh.  I really do not like the format of the use-list.
> 
> Anyway, don’t just replace comma with empty. Do it to the trailing commas only. This can be done in several ways.
> 
> Craig
> 
>> On Jul 29, 2021, at 8:42 AM, Skip Kimpel via use-livecode <use-livecode at lists.runrev.com> wrote:
>> 
>> I have a variable that contains:
>> 
>> ,Name,,,Quantity,,,,,Total,,,Percent
>> 
>> ,Dine In,,,189,,,,,"$4,812.71",,,57.96%
>> 
>> ,Take Out,,,72,,,,,"$1,676.43",,,20.19%
>> 
>> ,3rd Party,,,54,,,,,"$1,779.35",,,21.43%
>> 
>> ,Bakery,,,3,,,,,$34.83,,,0.42%
>> 
>> ,Total,,,318,,,,,"$8,303.32",,,
>> 
>> 
>> What is the best way to get 8303.32 from that last line.  Obviously, the
>> complexity is the commas and getting rid of the dollar sign as well.
>> 
>> 
>> I know I am going to kick myself when somebody answers.... I am blank this
>> morning.  (NEED MORE COFFEE!!!!!)
>> 
>> 
>> SKIP
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> 
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode