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!
@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.
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!