Spreadsheet: 838714d1691295928-pulling-text-number-values-from-text-string-samplesheet-tms
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}}} |  | [NAME] | [NAME] | 0 | 0.2 | 0 | 0.2
{"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}}} |  | [NAME] | [NAME] | 0 | 0 | 200 | 200
{"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}}} |  | [NAME] | [NAME] | 0 | 0 | 200 | 200
{"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}}} |  | [NAME] | [NAME] | 0 | 0 | 0 | 52.7
{"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}}} |  | [NAME] | [NAME] | 0 | 0 | 0 | 78.44
{"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}}} |  | [NAME] | [NAME] | 0 | 0 | 150 | 450
{"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}}} |  | [NAME] | [NAME] | 0 | 0 | 725 | 825
{"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}}} |  | [NAME] | [NAME] | 0 | 0 | 0 | 190
{"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}}} |  | [NAME] | [NAME] | 0 | 0 | 800 | 950
{"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}}} |  | [NAME] | [NAME] | 0 | 0 | 0 | 53
{"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}}} |  | [NAME] | [NAME] | 0 | 0 | 100 | 100
{"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}}} |  | [NAME] | [NAME] | 0 | 0 | 250 | 250
{"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}}} |  | [NAME] | [NAME] | 0 | 2.96 | 0 | 2.96
{"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}}} |  | [NAME] | [NAME] | 0 | 0 | 100 | 100