Most streamlined method to get data

2021-07-29 Thread Skip Kimpel via use-livecode
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 f

Re: Most streamlined method to get data

2021-07-29 Thread Craig Newman via use-livecode
Hi. I s the value you want always in the last line? If so, that dollar sign is always in a place that can be referenced: set the itemDel to “$” put the last item of the last line of yourCommaInfestedData into eureka replace quote with empty in eureka Craig > On Jul 29, 2021, at 8:42 AM, Skip

Re: Most streamlined method to get data

2021-07-29 Thread Craig Newman via use-livecode
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 > wrote: > > I have a variable that contains: > > ,Name,,,Quantity,Total,,,Percent > > ,Dine In,,,189,"$4,812.71",,,57.

Re: Most streamlined method to get data

2021-07-29 Thread Craig Newman via use-livecode
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 > wrote: > > I have a variable that contains: > > ,Name,

Re: Most streamlined method to get data

2021-07-29 Thread Colin Kelly via use-livecode
Put the last trueword of yourVariable That should do what you need ☺ Col. From: use-livecode on behalf of Craig Newman via use-livecode Date: Thursday, 29 July 2021 at 13:56 To: How to use LiveCode Cc: Craig Newman Subject: Re: Most streamlined method to get data Ugh. I really do not like

Re: Most streamlined method to get data

2021-07-29 Thread Rick Harrison via use-livecode
Nice solution Colin! Rick > On Jul 29, 2021, at 9:10 AM, Colin Kelly via use-livecode > wrote: > > Put the last trueword of yourVariable ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and

Re: Most streamlined method to get data

2021-07-29 Thread Craig Newman via use-livecode
"Nice solution Colin!” Agreed. Have to get down with these fancy new gadgets. Craig > On Jul 29, 2021, at 10:22 AM, Rick Harrison via use-livecode > wrote: > > Nice solution Colin! ___ use-livecode mailing list use-livecode@lists.runrev.com Please

Re: Most streamlined method to get data

2021-07-29 Thread Ben Rubinstein via use-livecode
As grepophile, I'd go for some variation on get matchText(last line of myVar, \ ",+Total,.*\"\$(\d*,?\d+\.\d\d)\",+", \ myTotal) obviously details depend on what variations you expect within the data. Note that there's a nasty aspect of LC parsing: in or

Re: Most streamlined method to get data

2021-07-29 Thread Mark Wieder via use-livecode
On 7/29/21 9:24 AM, Ben Rubinstein via use-livecode wrote: As grepophile, I'd go for some variation on While I heartily approve of Ben's use of grep, here's another approach using an array. Note that is somewhat specific to your data set, and from the looks of the data my guess is that you're

Re: Most streamlined method to get data

2021-07-29 Thread Jean-Jacques Wagner via use-livecode
Hi put replacetext(varlist,quote,numtochar(29)) into varlist2 set the itemdelimiter to numtochar(29) go each second item numtochar(29) to extract the komma or do whatever wirth it which does not interfer with other char the comma to another char put replacetext (valist2,numtochar(29),quote) into

Re: Jim Lambert is not crazy!

2021-07-29 Thread Jim Lambert via use-livecode
😃🤪 Jim Lambert ___ 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

how to include Apple's SF Pro font in an iOS app?

2021-07-29 Thread Phil Davis via use-livecode
Functionally speaking, I understand how to include it, but... will Apple let me release the app with that font included? I don't speak their brand of legalese very well. I can see the list of fonts that reside on my iPad and the SF fonts are not there. (I'm running iOS 14.6. ) But Apple makes it s

Re: how to include Apple's SF Pro font in an iOS app?

2021-07-29 Thread J. Landman Gay via use-livecode
I don't know why it wouldn't be allowed. Apple provides the fonts on their developer site and says you can download and use them: https://developer.apple.com/fonts/ Fonts are often named one thing but listed differently in the font files. This post mentions it's named "SFUI-Regular" on iOS 13:

Re: how to include Apple's SF Pro font in an iOS app?

2021-07-29 Thread Phil Davis via use-livecode
Thanks Jacque! I'll try '(System)' out and see what happens. Phil On 7/29/21 10:55 PM, J. Landman Gay via use-livecode wrote: > I don't know why it wouldn't be allowed. Apple provides the fonts on > their developer site and says you can download and use them: > https://developer.apple.com/fonts/