Most streamlined method to get data

Skip Kimpel skiplondon at gmail.com
Thu Jul 29 08:42:54 EDT 2021


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



More information about the use-livecode mailing list