I have a string field that I am trying to parse into rows where each line starts with the date, then the text that follows. Sample:
ID Number column Text block column
12345 5/2/2024 - Random text of varying length 2/8/2024 : Random text of varying length6/15/2022 Random text of varying length 2/16/2022Random text of varying length
Desired Output:
ID Num col Text block column
12345 5/2/2024 - Random text of varying length
12345 2/8/2024 : Random text of varying length
12345 6/15/2022 Random text of varying length
12345 2/16/2022Random text of varying length
There isn't a set hyphen or anything after the date for me to parse on. What is the best way to tackle this? I'm probably overlooking an easy way, so any help is appreciated!
Solved! Go to Solution.
@flying008
Nice one.
I heard about the "Positive Lookahead" but did not know how to use it.
Thank you so much!!😁