Filter serial numbers from extracted text

[Pwtf]

Hey guys, please see image attached for reference.

I currently have AI pulling the text into an array, and I want to filter the serial numbers (with format ###-###-###) into a string variable. 

Bonus would be only the ones marked as "Incoming". But I can likely figure that out later. 

I think because they're on a new line, the AI extracting the text marks it as a new line in the array. I've tried an array filter using "contains 'Incoming'" but that hasn't worked. 

Is there some kind of way to pull numbers only in a specific format/pattern? 

Edit: Doing this without regex would be preferred.

 

 

[v-jefferni]

Hi @Pwtf ,

For each item in the Gallery, the field that includes the serial number seems like a string already. Could you please try to copy the "·" in the string and use the Split function to get the last serial number?

Set(varSN, Trim(Last(Split(ThisItem.ColumnName, "·")).Value))

Best regards,

[Pwtf]

Hey,

I've attempted what you suggested and it is returning nothing. I'm assuming like I said because in the image the serial numbers are on a new line, they're actually a new item in the array, meaning the Split function would return nothing after the '•' as that's the last character in that line including the 'Incoming' text.

This also wouldn't differentiate between 'Incoming' and 'Outgoing' as it's giving everything after the '•'. I'm assuming you could specify 'Incoming •' but so far no luck as the issue listed above still exists.

Could the array potentially be converted into a single string and filtered that way?

[v-jefferni]

Hi @Pwtf ,

You'd better figure out the structure of this array before making any adjusting and that would be easier. I assume it is a Gallery in your App, and how did you get the array and input into the Gallery? Did you use a collection? You can preview the array by selecting formulas in Items of Gallery or in Variables -> collections in the studio.

Best regards,