I've attached my original data and how I want it to be modified. I need to parse out the last few characters from a set of data, but the length of the data I need to parse varies.
Fair point @BenMoss.
The expression:
^(.*) ([^ ]+)$
Matches the whole string input.
The first part "^(.*) " will 'greedily' match until the last space
The second part "([^ ]+)$" will match every thing to the end of the line
In parse mode each bracketed section becomes a column.
This should work as long as there is a space before the last part.
Text to columns, and use the decimal delimiter (Y)
I'd suggest using the Regex tool in parse mode:
Care to explain the Regex @jdunkerley79 for @bsolove.Sometimes although the regex is a bit more efficient, in terms of number of tools, the text to columns route will be much easier to handover to individuals not familiar with ReGex.
Here is the sample workflow for your case. Hope this is helpful.
WorkflowResults
