Most streamlined method to get data

Craig Newman craig at starfirelighting.com
Thu Jul 29 08:54:22 EDT 2021


Looking at this again, two seconds later, you may also want to;
replace comma with empty in eureka

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