Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Extract string from text

qlikvw2019
7 - Meteor

I have a Text field with lots of data in each row 

 

Sample 1

The disk F: on the computer is running out of disk space.

The values that exceeded the threshold are 4.46% free space and 958 free Mbytes.

Server: CHP13332.hosts.cld.com
Target: F:
Alert: Logical Disk Free Space is low
Alert Date: 2020-01-16T13:10:40.1230000Z

MORE TEXT...

 

Sample 2

The disk F: on the computer is running out of disk space.

The values that exceeded the threshold are 4.46% free space and 958 free Mbytes.

Server   name: CHG15632.hosts.cld.com
Target: F:
Alert: Logical Disk Free Space is low
Alert Date: 2020-01-16T13:10:4otoiwetuq0Z

MORE TEXT...

 

I want to extract the Server name: CHP13332, CHG15632

 

The Server name starts with anything. It is always mentioned after the word "Server:"  or "Server name:" 

It is always mentioned after the ":" but there can be many ":" in the whole text

 

Please help

2 REPLIES 2
T_Willins
14 - Magnetar
14 - Magnetar

Hi @qlikvw2019,

 

Based on how you presented the data, this Regex parse works for both examples (same Regex tool set up for both.  If all the data is in the same row it should still work.

 

regex parse.png

 

afv2688
16 - Nebula
16 - Nebula

Hello @qlikvw2019 ,

 

Maybe this works:

 

Sin título.png

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

Labels