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
