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

[KrishnaChithrathil]

@Hi2023 

Glad you made it a separate post 😀

posting the same answer again.

[ShankerV]

hi @Hi2023 

One way of doing this is as below.

Use the RegEx tool

1. Column to Parse - Select the Input Column

2. Regular expression is as below

ID's;\s(\d*)

3. Output Method -Parse

Modify the Output column name from RegexOut 1 to Alert ID as needed

[ShankerV]

By using the above way it will help to extract if alert ID is any number of digits.

ID's;\s(\d*)

The above expression looks for ID's; and \s ignores the space

Then \d looks for the digits and * helps to retrieve any number of digits.

Input

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; R...

Output

123456789

Shanker V

[ShankerV]

@Hi2023 

Explanation in detail

ID's;\s(\d*)

This will look for ID's; in the input and \s ignore the space and moves one character ahead.

Then \d helps to filter the digits and * helps to read as my digits available.

This can help if your Alert ID is changing from 1 digit to ;n' digits.

Hope this helps!!!

Many thanks

Shanker V

[binuacs]

@Hi2023 One way of doing this with the tokenize method

[Hi2023]

Idk why it isnt working??

[Hi2023]

It didnt work either.

trying to get diff options🙂

[KrishnaChithrathil]

@Hi2023 

did you run the attached workflow? Is it not working???

[Hi2023]

Idk if it is because the cell is marked red stating truncated characters