Most streamlined method to get data
Craig Newman
craig at starfirelighting.com
Thu Jul 29 08:56:01 EDT 2021
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
More information about the use-livecode
mailing list