Hi all

Stumped by this one. I need to extract the 'amount' number from the text strings below. The format varies but there is consistency in that the number i need always follows:

"amount":"

here's a sample of the text string variance i'm working with:

{"amount":"100.0","currency":"sek","customerId":""}
{"currency":"EUR","customerId":"","amount":"5.0"}
{"currency":"GBP","amount":"20.0","customerId":""}
{"currency":"RON","amount":"50.0","customerId":""}
{"currency":"SEK","customerId":"","amount":"800.0"}
{"customerId":"","currency":"GBP","amount":"8.0"}
{"customerId":"","currency":"SEK","amount":"1000.0"}
{"customerId":"","currency":"SEK","amount":"300.0"}
{"customerId":"106513976","currency":"DKK","amount":"150.0"}
{"customerId":"3111","currency":"SEK","amount":"100.0"}

However, as you can see the number is not fixed digit length nor consistent position within the text string.

Help appreciated.