Parsing text Data from Field

[Ron Neville]

Hi Guys, once again thank you for a great resource.

This will be simple for you guru's I am get text put into a result field and want to pull out certain data. Here is the result:

Messaging Services provide delivery enhancement tools you can apply to your messaging applications at the toggle of a button. Examples include sending messages over long code (10-digit number) when short code messages fail, and automatically distributing high volumes of messages over multiple numbers to ensure speedy, successful delivery.", "status": "queued", "num_segments": "3", "num_media": "0", "direction": "outbound-api", "api_version": "2010-04-01", "price": null, "price_unit": "USD", "error_code": null, "error_message": null, 

I would like to pull out the "error_code" which is null in the example, also the "num_segments" and "error_message"

Thank you in advance... Ron

Edited October 24, 2016 by Lee Smith
Removed Align center

[comment]

Your question is not entirely clear. Assuming your text field contains all the text starting with "Messaging Services" and ending with "null,", you can extract the value attached to the "error_code" label using =

Let ( [
label = "\"error_code\": " ;
start = Position ( Textfield ; label ; 1 ; 1 ) + Length ( label ) ;
end = Position ( Textfield ; "," ; start ; 1 )
] ;
Middle ( Textfield ; start ; end - start )
)

--
P.S. Please do not align your post to the center, it makes it very difficult to read.

[Ron Neville]

Sorry about the alignment and was default and didn't realise I could change it  Thank you for your response...