Formula to find the highest number in a string

I was wondering if I could get some guidance with this.

I have a string value in a text field from the interface. It looks like. In the middle of this string is something like, "1, 10, 25."

I can isolate that part of the string using regex. But I need to also find the highest value in that string. That value will be used in an action tool to update another tool. (Basically updating the maximum distance in that tool).

So I think I'm limited to one formula in the action tool to get there. Does anyone know how I can isolate just the 25 in this instance?

Help

Accepted answers

Maskell_Rascal

Hey @mike_weaver,

So now that I better understand what you're trying to accomplish, I put together a down and dirty analytic app for you to experiment with. You can create a trade area from a specific field within the Trade Area spatial tool.

So applying the original workflow of mine allows for you to parse out the largest radii and then apply that to the Trade Area tool.

So in the below example the app is parsing out 20 as the max number, and then applying that to the rest of the workflow to create my trade area.

If this solves the issue please mark answer as correct, if not let me know!

Cheers!
Phil

Find Largest Number In String.yxwz

All comments

MichaelSu

Hi @mike_weaver ,

Please see attached solution. You can use the Text to Columns tool to perform a Split to Rows, sort the data from highest to lowest, and use the Sample Tool to take the highest number from each string.

Please let me know your thoughts.

Thanks,

Mike

Highest_Number_In_A_String.yxmd

Maskell_Rascal

Hey @mike_weaver,

Here is a workflow that should work for you. This approach allows for any strings fields that contain both alpha and numeric values.

Starting Data:

Workflow w/ Output:

Cheers!

Phil

Find Largest Number In String.yxmd

michael_weaver

These are good solutions. Unfortunately, I need to isolate that in an action tool. So I need a formula that can do it.

Jean-Balteryx

Why do you need to isolate that in an Action tool ?

michael_weaver

The string comes from an API feed. The user enters an address and then one or more radii and that comes in on one text tool. The radii are applied to various reports and maps downstream. I need to isolate the largest number to find the maximum radius and that value needs to be fed to a spatial tool down the line. That tool doesn't accept field references for the maximum radius so I need to change it with an action tool.

Maskell_Rascal

Hey @mike_weaver,

So applying the original workflow of mine allows for you to parse out the largest radii and then apply that to the Trade Area tool.

So in the below example the app is parsing out 20 as the max number, and then applying that to the rest of the workflow to create my trade area.

If this solves the issue please mark answer as correct, if not let me know!

Cheers!
Phil

Find Largest Number In String.yxwz

michael_weaver

Thanks for that, but I should have been more specific. I need to update the Distance tool. Specifically, the field circled in red.

(P.S. ignore the "no valid datasets found").

Maskell_Rascal

You can set the Trade Area tool to Drivetime Minutes. Depending on what you're trying to accomplish, you can then use a Spatial Match or Spatial Process tool to get your desired output.

This is really your only option due to how your data is coming into the workflow. RegEx has no innate way to evaluate values, since it is a string parser.

Edit: I should also point out that the Trade Area tool is the only spatial tool that allows you to use a field to assign a value like distance/minutes.

michael_weaver

Thanks so much for your help!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703