Ron Neville Posted October 24, 2016 Share Posted October 24, 2016 (edited) 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 Link to comment Share on other sites More sharing options...
comment Posted October 24, 2016 Share Posted October 24, 2016 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. Link to comment Share on other sites More sharing options...
Ron Neville Posted October 24, 2016 Author Share Posted October 24, 2016 Sorry about the alignment and was default and didn't realise I could change it Thank you for your response... Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2875 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now