Hello Everyone-
I am working on separating mixed data from one column into separate column and couldn't find a work around to achieve the same. The single column consists of Locator and LPN information mixed , example as shown below. The unique thing about a Locator is it will always has a "-" in the string while the LPN's will be continuous alpha numeric strings.
in my working logic i created a flag (1/0) to separate the Locators from LPN's (using "-" as an identifier) and then had LPN's on a separate column but the challenge is to get the parent locator adjacent to the LPN's. Please find the sample data which has input and required output fields. also, find in attached my WIP logic.
Thank you very much.
