Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.
Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!

Alteryx Designer Discussions

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

Separating text from the column of texts

sriniprad08
11 - Bolide

Hi Team,

Hope you are well.

I need help. I have to separate the Active hosts and scan assets from the below the column into a new column.

Please let me know how to go about it,

 

Thanks,

9 REPLIES 9
AlexEntz
8 - Asteroid

Hello,

 

the Text to Column tool is perfect for this. Here my Solution:

 

AlexEntz_0-1635844015821.png

 

This is the endresult:

AlexEntz_1-1635844042158.png

 

Example is attached. Hope this helps!

 

Greetings Alex

 

sriniprad08
11 - Bolide

Hi @AlexEntz ,

Perfect. Thank you very much.

 

Cheers

Sri

sriniprad08
11 - Bolide

Hi @AlexEntz ,

 

Thank you for helping out. I found that there are couple of texts which has "-" in the begining . Is it possible to remove only the last one?

 

get Lk sdf-Ksdfffffsfs-Mais EXT - Netblocks Assigned
get Lk sdf-Ksdfffffsfs-Vordef EXT - Netblocks Assigned

 

Thanks

AlexEntz
8 - Asteroid

Hi @sriniprad08,

 

this is a more complicated matter then. For this we have to use regular expressions. I'm not very familiar with them, but I think I cooked something up that works. Here is the flow:

 

AlexEntz_0-1635855479063.png

 Here the result:

AlexEntz_1-1635855506932.png

I added row 3 to show you, that the last one is always taken (doesn't matter how many delimeters there are). I attached the Workflow as well.

 

Greetings Alex

sriniprad08
11 - Bolide

Hi @AlexEntz ,

Perfect. Thank you so much. Really appreciate your time 🙂

 

Cheers,

Sri

sriniprad08
11 - Bolide

Hi @AlexEntz ,

Thanks for the help. Is it possible to retain only the parts before - Network Assigned.  Actually i need to remove the "-Network Assigned".

 

Cheers,

Sri

sriniprad08
11 - Bolide

For eg. As per below in the separate column.

get Lk sdf-Ksdfffffsfs-Mais EXT 
get Lk sdf-Ksdfffffsfs-Vordef EXT 

sriniprad08
11 - Bolide

Hi @AlexEntz ,

Thanks for the help. Is it possible to retain only the parts before - Network Assigned.  Actually i need to remove the "-Network Assigned".

 

Cheers,

Sri

AlexEntz
8 - Asteroid

Hi @sriniprad08,

 

for that, you will have to change the regular expression to this: (.*-)+

 

This is the result:

AlexEntz_0-1635920814641.png

If you the want to remove the last "-" use a formula tool with this expression: TrimRight([RegExOut1],"-")

 

I hope this answers your question :)!

 

Greetings Alex

Labels