Vstring data that has been trimmed will not join

[CherieACI]

We are using a unique ID to join data together from different inputs. Some of those unique IDs have alpha numeric characters so we are trimming the alpha characters to end up with just a numeric in the end. (The reason being is because we haven't figured out a way to join alpha numeric data.) After the IDs are trimmed they should match up. We are performing the trim on all inputs. The Sales Order Line ID started out like the Sales Order Number (they are identical) and then after the trim end up as pictured below. We are joining on Sales Order Line ID. I have also added a data cleanse tool to remove any leading or trailing white spaces before it joins.  

Here is my workflow. I've highlighted each of the places that have the trim formula. Everything else joins just fine. It is only these lines that have been trimmed that won't join. And I have checked to make sure there is matching data that should join from the other inputs. 

Any ideas why this is happening? 

Thank you in advance!

[Luke_C]

Hi @CherieACI 

Can you provide some sample data? Maybe two tables where the records don't join? For the join to work properly the fields you're joining on need to be the same data type and exact same values (case sensitive, no leading/trailing whitespace, etc). 

[CherieACI]

While I was preparing sample data I was able to see what my issue was and got it fixed! Thank you!