Parse Data

[bsolove]

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.

[BenMoss]

Text to columns, and use the decimal delimiter (Y)

[jdunkerley79]

I'd suggest using the Regex tool in parse mode:

[BenMoss]

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.

[bsolove]

They don't all end in a decimal though.  I have different entities.  They either end in Inc. or LLC (with no decimal).

[jdunkerley79 · Accepted solution]

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.

[ponraj]

Here is the sample workflow for your case. Hope this is helpful. 

WorkflowResults

[bsolove]

That worked perfectly.  Thank you!