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@lists.runrev.com> wrote: > > Put the last trueword of yourVariable > > That should do what you need ☺ > > Col. > > From: use-livecode <use-livecode-boun...@lists.runrev.com> on behalf of Craig > Newman via use-livecode <use-livecode@lists.runrev.com> > Date: Thursday, 29 July 2021 at 13:56 > To: How to use LiveCode <use-livecode@lists.runrev.com> > Cc: Craig Newman <cr...@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@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@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@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
