return value, different length

[tiverson]

Trying to return values from original list, without the [-] 510S_ items or the 510S_

The PC Group column is what I am trying to come up with

[atcodedog05]

Hi @tiverson 

Really sorry I know in excel you are considering based on [-] symbol on which to not extract. But since this is not appearing in Alteryx input data it's hard to apply any logic. If you find that it's following a specific pattern let me know.

Hope this helps : )

[tiverson]

I agree, I am using a report that we download from another source and when we try to input the file the [-] disappears.  I can only get it to show up when I copy and paste the original file into a text input.

I appreciate your help.

Thanks