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

Reporting

Accepted answers

All comments

KrishnaChithrathil

@Hi2023

Glad you made it a separate post 😀

posting the same answer again.

Conditional Statement.yxmd

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

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

binu_acs

@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🙂

Hi2023

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

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

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703