Start Free Trial

Alteryx Designer Desktop Discussions

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

Cut Before / Cut After

bakaidora
8 - Asteroid

Dear Community,

 

I have an Excel sheet where I have a column with the Notes. This is a bulk text and I need to cut the NT user information out of this text.

I cannot say from which characters I need this information because it is different, the only thing I can say that the needed information is between two phrases.

e.g. "Q: NT-ID of affected user? A:ABC2BP Q: Client-ID / Computer name of affected user?"

And from this I only need ABC2BP. The phrases before and after ABC2BP are not needed for me, I would like to cut them.

 

Is there any easy solution which I can use to cut a words before and after the needed data?

 

Thanks in advance!

 

2 REPLIES 2
Felipe_Ribeir0
16 - Nebula

Hi @bakaidora 

 

Try this regex expression:

NT-ID of affected user\? A\:(.*?)\s

 

Felipe_Ribeir0_0-1674042746181.png

 

Sarreddy
9 - Comet
Labels
Top Solution Authors