Jump to content
Server Maintenance This Week. ×

Parsing text Data from Field


This topic is 2739 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 by Lee Smith
Removed Align center
Link to comment
Share on other sites

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

This topic is 2739 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.