So to give you a full sense of the ugliness of the CSV I am working with,
here it is: (trying to add certain columns but because some columns have
multiple "thousand dollar+ amounts, it throws doing an item count. Need to
get rid of all dollar signs (easy) and all the commas that are part of a
thousand+ dollar amount)
-------------------
,3rd Party,Bakery,Bar,Catering,Delivery,Dine In,Drive Thru,Take
Out,,Vending,Total,
8:00 AM,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,$406.43,,$0.00,$406.43,
9:00 AM,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,,$0.00,$0.00,
10:00 AM,$40.74,$0.00,$0.00,$0.00,$0.00,$52.41,$0.00,$200.69,,$0.00,$293.84,
11:00
AM,$538.14,$3.29,$0.00,$0.00,$0.00,$581.30,$0.00,$165.93,,$0.00,"$1,288.66",
12:00
PM,$184.11,$3.29,$0.00,$0.00,$0.00,$745.68,$0.00,$274.36,,$0.00,"$1,207.44",
1:00
PM,$89.06,$12.87,$0.00,$0.00,$0.00,$741.65,$0.00,$132.26,,$0.00,$975.84,
2:00
PM,$216.86,$12.47,$0.00,$0.00,$0.00,$604.86,$0.00,$90.32,,$0.00,$924.51,
3:00 PM,$160.69,$0.00,$0.00,$0.00,$0.00,$404.66,$0.00,$37.86,,$0.00,$603.21,
4:00
PM,$68.31,$33.71,$0.00,$0.00,$0.00,$349.46,$0.00,$323.34,,$0.00,$774.82,
5:00
PM,$286.31,$0.00,$0.00,$0.00,$0.00,$625.92,$0.00,$253.94,,$0.00,"$1,166.17",
6:00
PM,$500.66,$36.11,$0.00,$0.00,$0.00,$790.25,$0.00,$609.95,,$0.00,"$1,936.97",
7:00
PM,$224.81,$26.95,$0.00,$0.00,$0.00,"$1,038.03",$0.00,$137.17,,$0.00,"$1,426.96",
8:00 PM,$0.00,$0.00,$0.00,$0.00,$0.00,$55.46,$0.00,$7.10,,$0.00,$62.56,
9:00 PM,$0.00,$0.00,$0.00,$0.00,$0.00,$2.75,$0.00,$0.00,,$0.00,$2.75,
10:00 PM,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,,$0.00,$0.00,
Total,"$2,309.69",$128.69,$0.00,$0.00,$0.00,"$5,992.43",$0.00,"$2,639.35",,$0.00,"$11,070.16",
,,,,,,,,,,,,Page 1 of 1
On Thu, Jul 29, 2021 at 1:41 PM Mark Wieder via use-livecode <
use-livecode@lists.runrev.com> wrote:
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 heading down the path
of csv madness.
on mouseUp pMouseBtnNo
local tVar, tHeader, tCount, tOriginal
put field 1 into tVar
put line 1 of tVar into tHeader
delete line 1 of tVar
split tVar by cr
repeat for each key tKey in tVar
# transform "$8,303.32" into "$8303.32"
repeat for each trueword tTrueWord in tVar[tKey]
put tTrueWord into tOriginal
replace comma with empty in tTrueWord
replace tOriginal with tTrueWord in tVar[tKey]
end repeat
# now we can deal with commas as itemDelimiters
put 1 into tCount
repeat for each item tWord in tVar[tKey]
put tWord into tVar[tKey][tCount]
add 1 to tCount
end repeat
end repeat # for each key tKey in tVar
# now pick out the desired total
local tTotal, tOffset
put itemoffset("Total", tHeader) into tOffset
put tVar[5][tOffset] into tTotal
breakpoint
end mouseUp
--
Mark Wieder
ahsoftw...@gmail.com
_______________________________________________
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
_______________________________________________
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
