Hi,
I need to extract fields from this string (and 100's others like it)
{"currency":"NZD","delivery_confirmation":"SIGNATURE","duty_payment_account":"164497240","freight_charge":0.0,"incoterm":"DDP","label_date":"2017-04-18T12:42:07+00:00","label_format":"ZPL","label_size":"4X7","print_custom_1":"ECOM 66651 / 6900091985","commercial_invoice_signature":"IMAGE_3","parties_to_transaction_are_related":true,"import_federal_tax_id":"40422445L","customs_include_shipping":true,"delivered_duty_paid":true,"print_custom":[{"name":null,"value":"ECOM 66651 / 6900091985","barcode":null}]}
I am looking to get the label_date (just the date, not the T onward in that string) and print_custom_1 fields out but I can't work out how, I have not used access in over 10 years so I am really rusty.
Any help?
Cheers
I need to extract fields from this string (and 100's others like it)
{"currency":"NZD","delivery_confirmation":"SIGNATURE","duty_payment_account":"164497240","freight_charge":0.0,"incoterm":"DDP","label_date":"2017-04-18T12:42:07+00:00","label_format":"ZPL","label_size":"4X7","print_custom_1":"ECOM 66651 / 6900091985","commercial_invoice_signature":"IMAGE_3","parties_to_transaction_are_related":true,"import_federal_tax_id":"40422445L","customs_include_shipping":true,"delivered_duty_paid":true,"print_custom":[{"name":null,"value":"ECOM 66651 / 6900091985","barcode":null}]}
I am looking to get the label_date (just the date, not the T onward in that string) and print_custom_1 fields out but I can't work out how, I have not used access in over 10 years so I am really rusty.
Any help?
Cheers