Spreadsheet: 838709d1691288578-pulling-text-number-values-from-text-string-samplesheet
Sheet: Example

[NAME] | Small | Personal | Anonymous | Loans | Misc. Auction | Itemized Contributions | Sum
{"sums":{"small":{"date":null,"count":null,"amount":null,"aggregate":null},"personal":{"date":null,"amount":null,"aggregate":0},"anonymous":{"date":null,"amount":null,"aggregate":null},"loans":{"amount":0,"aggregate":null,"date":null,"count":0},"misc_auction":{"amount":0.2,"aggregate":null,"date":"2023-07-31","count":1},"itemized_contributions":{"amount":0,"aggregate":null,"date":null,"count":0}}} | Null | Null | Null | 0 | 0.2 | 0 |  | Example
{"sums":{"small":{"date":null,"count":null,"amount":null,"aggregate":null},"personal":{"date":null,"amount":null,"aggregate":0},"anonymous":{"date":null,"amount":null,"aggregate":null},"loans":{"amount":0,"aggregate":null,"date":null,"count":0},"misc_auction":{"amount":0,"aggregate":null,"date":null,"count":0},"itemized_contributions":{"amount":200,"aggregate":null,"date":null,"count":1}}} | Null | Null | Null | 0 | 0 | 200 |  | Example
{"sums":{"small":{"date":null,"count":null,"amount":null,"aggregate":null},"personal":{"date":null,"amount":null,"aggregate":0},"anonymous":{"date":null,"amount":null,"aggregate":null},"loans":{"amount":0,"aggregate":null,"date":null,"count":0},"misc_auction":{"amount":0,"aggregate":null,"date":null,"count":0},"itemized_contributions":{"amount":200,"aggregate":null,"date":null,"count":1}}}
{"sums":{"small":{"date":"2023-07-28","count":2,"amount":52.7,"aggregate":null},"personal":{"date":null,"amount":null,"aggregate":0},"anonymous":{"date":null,"amount":null,"aggregate":null},"loans":{"amount":0,"aggregate":null,"date":null,"count":0},"misc_auction":{"amount":0,"aggregate":null,"date":null,"count":0},"itemized_contributions":{"amount":0,"aggregate":null,"date":null,"count":0}}}
{"sums":{"small":{"date":"2023-08-03","count":1,"amount":78.44,"aggregate":null},"personal":{"date":null,"amount":null,"aggregate":0},"anonymous":{"date":null,"amount":null,"aggregate":null},"loans":{"amount":0,"aggregate":null,"date":null,"count":0},"misc_auction":{"amount":0,"aggregate":null,"date":null,"count":0},"itemized_contributions":{"amount":0,"aggregate":null,"date":null,"count":0}}}
{"sums":{"small":{"date":"2023-07-28","count":3,"amount":300,"aggregate":null},"personal":{"date":null,"amount":null,"aggregate":0},"anonymous":{"date":null,"amount":null,"aggregate":null},"loans":{"amount":0,"aggregate":null,"date":null,"count":0},"misc_auction":{"amount":0,"aggregate":null,"date":null,"count":0},"itemized_contributions":{"amount":150,"aggregate":null,"date":null,"count":2}}}
{"sums":{"small":{"date":"2023-07-30","count":1,"amount":100,"aggregate":null},"personal":{"date":null,"amount":null,"aggregate":0},"anonymous":{"date":null,"amount":null,"aggregate":null},"loans":{"amount":0,"aggregate":null,"date":null,"count":0},"misc_auction":{"amount":0,"aggregate":null,"date":null,"count":0},"itemized_contributions":{"amount":725,"aggregate":null,"date":null,"count":3}}}
{"sums":{"small":{"date":"2023-08-01","count":4,"amount":190,"aggregate":null},"personal":{"date":null,"amount":null,"aggregate":0},"anonymous":{"date":null,"amount":null,"aggregate":null},"loans":{"amount":0,"aggregate":null,"date":null,"count":0},"misc_auction":{"amount":0,"aggregate":null,"date":null,"count":0},"itemized_contributions":{"amount":0,"aggregate":null,"date":null,"count":0}}}
{"sums":{"small":{"date":"2023-07-31","count":3,"amount":150,"aggregate":null},"personal":{"date":null,"amount":null,"aggregate":0},"anonymous":{"date":null,"amount":null,"aggregate":null},"loans":{"amount":0,"aggregate":null,"date":null,"count":0},"misc_auction":{"amount":0,"aggregate":null,"date":null,"count":0},"itemized_contributions":{"amount":800,"aggregate":null,"date":null,"count":4}}}
{"sums":{"small":{"date":null,"count":2,"amount":53,"aggregate":null},"personal":{"date":null,"amount":null,"aggregate":0},"anonymous":{"date":null,"amount":null,"aggregate":null},"loans":{"amount":0,"aggregate":null,"date":null,"count":0},"misc_auction":{"amount":0,"aggregate":null,"date":null,"count":0},"itemized_contributions":{"amount":0,"aggregate":null,"date":null,"count":0}}}
{"sums":{"small":{"date":null,"count":null,"amount":null,"aggregate":null},"personal":{"date":null,"amount":null,"aggregate":0},"anonymous":{"date":null,"amount":null,"aggregate":null},"loans":{"amount":0,"aggregate":null,"date":null,"count":0},"misc_auction":{"amount":0,"aggregate":null,"date":null,"count":0},"itemized_contributions":{"amount":100,"aggregate":null,"date":null,"count":1}}}
{"sums":{"small":{"date":null,"count":null,"amount":null,"aggregate":null},"personal":{"date":null,"amount":null,"aggregate":0},"anonymous":{"date":null,"amount":null,"aggregate":null},"loans":{"amount":0,"aggregate":null,"date":null,"count":0},"misc_auction":{"amount":0,"aggregate":null,"date":null,"count":0},"itemized_contributions":{"amount":250,"aggregate":null,"date":null,"count":1}}}
{"sums":{"small":{"date":null,"count":null,"amount":null,"aggregate":null},"personal":{"date":null,"amount":null,"aggregate":0},"anonymous":{"date":null,"amount":null,"aggregate":null},"loans":{"amount":0,"aggregate":null,"date":null,"count":0},"misc_auction":{"amount":2.96,"aggregate":null,"date":"2023-08-04","count":1},"itemized_contributions":{"amount":0,"aggregate":null,"date":null,"count":0}}}
{"sums":{"small":{"date":null,"count":null,"amount":null,"aggregate":null},"personal":{"date":null,"amount":null,"aggregate":0},"anonymous":{"date":null,"amount":null,"aggregate":null},"loans":{"amount":0,"aggregate":null,"date":null,"count":0},"misc_auction":{"amount":0,"aggregate":null,"date":null,"count":0},"itemized_contributions":{"amount":100,"aggregate":null,"date":null,"count":1}}}