Extract values from element of array

[Jessica_2067]

This may have already been brought up by someone and I haven't done enough searching, but attached is a shot of the array I have that. I need to get the digits from between the quotation marks. They need to stay in an array form to be used elsewhere, but I seem to be having trouble getting something to work. If someone can point me in the right direction or show me discussions that I may have missed, it would be appreciated.

[crossrulz]

I would probably use Match Regular Expression or Search/Split String inside of a FOR loop to find your values.

[Bob_Schor]

if you know the data you expect, and want to extract just the values, I like Scan from String.  For example, you have "hexData" line where you might want to extract the "N" of the hexData identifier (e.g. hexData3, identifier = 3) and the "hex Data" is really an I32.  This will do that -- N will get the value "23", while Value gets 2212892, the decimal represented by the hex string.

Bob Schor

[SergeB · Accepted solution]

As crossrulz and Bob describe, there's many ways of doing it. Another way, less robust, would be to use the "match pattern" function and retrieve what's between the quotations (assuming your array elements will never see more than two quotation marks). And then using a conditional output tunnel on your for loop to filter out the empty string elements in your array that don't fit the desired pattern (see attached).

[Jessica_2067]

@crossrulz, I did try all those and it didn't seem to work out for me, even with conditional statements. I am not sure what I wasn't doing that nothing was working for me, but I now have a solution and can work on the next step.

@SergeB - your way did work thank you.

Thank you everyone for your suggestions.

[SergeB]

You very welcome. Glad we could help