Parse Reglex?

[Hi2023]

Hi, 

Trying to find how to parse and separate the Alert ID only.

The current Column name is Comment 

and the input looks like this: (it wont let me screenshot)

EMM: total transactions - 1 and total amount - 8766.78; Inclearing: Total Transactions - 0 and Total Amount -0; EMM:Total Transactions -0 and Total Amount -0; FIRES: Total transactions -0 and Total Amount -0: Check Seroil #'s or Alert ID's; 123456789; Ref Date(s) 2023-08-01 20:58:24;

I want the AlertID # to come out ONLY  

Expected Outcome: New column name : AlertID

123456789

Please help!

thanks

[ShankerV]

Hi @Hi2023 

It is not due to truncated characters.

Actually it will display in the results pane with truncated characters. If you click on the cell, we can see the full string in cell viewer.

Can you please attach your workflow or screenshot to check what went wrong.

Many thanks

Shanker V

[KrishnaChithrathil]

@Hi2023 

I'm also confused what's causing the error for you.

can you show me the regex tool configuration of yours?

[Hi2023]

This is what the ReEx looks like. The output is null, does it matter that some #s are larger /smaller, also it shows that some have more than one AlertID and is separated by commas.

[Hi2023]

when I ran it, the output is null, does it matter that some #s are larger /smaller, also it shows that some have more than one AlertID and is seperated by commas.

[Hi2023]

It didnt work the output came back as null,

does it matter that some #s are larger /smaller, also it shows that some have more than one AlertID and is seperated by commas.

thanks

[atcodedog05]

Hi @Hi2023 

Please provide a few rows of sample data in an excel. We will get an idea of the data and will be able to help you better 🙂

[KrishnaChithrathil]

@Hi2023 

Can you provide us a few more inputs to try out? 

[atcodedog05]

Hi @Hi2023 

Give this a try. If it works we can explain you about it.

Hope this helps : )