Split Data Feeding Into Alteryx in One Row

[user_7346]

Hello,

I have data in CSV files. The data comes in with all information in 1 column. I am looking to have 2 columns: 1 with the username and another with active/inactive. Some columns have extra text such as "(password)". I would like to avoid manually manipulating the Excel file as I have many files in this exact same format and will receive files in this format frequently.

How the data currently looks in Excel

How the data currently looks in Alteryx

How I would like the data to look in Alteryx

[echuong1]

You could use regex to clean this up.

Another method would be to use a text to columns with a delimiter on "(" to remove the password entries. From there, you can use a simple regex to separate out the data before and after the capital letter.

Are you able to upload a copy of your input file?

[user_7346]

Hello,

The raw data is attached. Thank you for your help!

[Emil_Kos]

Hi @user_7346,

Not sure if you want to keep a password or not but maybe you can try text to columns tool

Output: