Text to Column

[dhakim1996]

Hi I want to split the column using delimiter "-". e.g. "ABC - Do not use" it will be split into "ABC" and "Do not use". However there are some where "-" is part of their name e.g. "A-BC". Using the text-to-column function it will split into "A" and "BC" instead of keeping it. Anyways to solve this?

Thaank you!

[DataNath]

@dhakim1996 are the records always in that similar format of [1] - [2] where there aren't spaces in [1], but could be extra hyphens? I'm just thinking the following could perhaps be an alternative if so:

If not, can you provide a list of some further examples? I think RegEx is the way to go here so will just need a few possibilities to work with to try and build out a suitable expression.

[Nick-C]

Hey @dhakim1996, 
Are you confident that the second half of the "Input" won't contain your delimiter? If so then you could use ReverseString to flip it around and parse using "-" and then ReverseString it back the right way again! 

If the second half of your string might also contain the Delimiter then this won't work but just a thought! 

[Kinga]

If in the second part the is no "-" I would use RegEx Tool and in pattern add "$" as end of line:

[Emmanuel_G]

Hi @dhakim1996 ,

Find attached one easy way to do this with regex tool.