Hey there!
New to RegEx and can't seem to produce the correct combination of expressions to create two new columns from an existing string field.
The field is data from manually entered description with two components.
The first is CRITICAL UPDATE and the second is RELEASE BLURB
Looks similar to this
CRITICAL UPDATE 05/31/2017 This is a sentence I need to extract to a separate field. This sentence should appear together with the first.
RELEASE BLURB: This sentence needs to appear in a new field. This sentence should go along with the first. This one too. This one as well.
( I should add that on ALteryx the cell shows up with a line space between the two)
Since it is a manually entered field, the colon is not always a reliable delimiter. I think the only thing I can count on is that the heading phrases will be in all caps.
I appreciate any help with this!
Solved! Go to Solution.
This only separates the critical update from it's corresponding text and the corresponding text cells show red corner arrows alerting that "This cell has embedded newlines."
@jdunkerley79 text input had a couple extra spaces in the end of the second line. I removed them and it worked fine. His solution is better than the one I posted.
This hit the sweet spot with no irregularities. THANKS A BUNCH!