Most streamlined method to get data
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.
> 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:
> ,Dine In,,,189,,,,,"$4,812.71",,,57.96%
> ,Take Out,,,72,,,,,"$1,676.43",,,20.19%
> ,3rd Party,,,54,,,,,"$1,779.35",,,21.43%
> 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!!!!!)
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
More information about the use-livecode