Join Question - Same Item but one has a Identifier at the end

[Karl_Spratt]

Hi Community 

Question please::

I have a Join Question - I have the same Items but one has a Identifier at the end, do can I create the join? 

Sample data:  Finished Items are my master list, but the extracts have a #100 at the end.  Can someone please explain the join?  TIA Karl

Finished Number	Component Item
22519995	22519995#100
67637181	67637181#100
67637207	67637207#100
67646331	67646331#100
67802298	67802298#100

[mceleavey · Accepted solution]

Hi @Karl_Spratt ,

some more Regex magic. 

Hope this helps.

M.

[messi007]

Dear @Karl_Spratt,

Nope you can't as both columns have to have the same values in order to join.

The join tool is case sensitive as well.

Below a workflow that you can use in order to join columns.

Hope that helps,

Regards

[Karl_Spratt]

Thanks Guys the Regex Solution worked a treat..

Cheers,

Karl.