Comparing two similar strings and inserting commas

[DMI10000]

Hi all,

Please I have two similar character strings x1 and x2, and I want to insert "," into x2 at the same position where the "," is in x1. 

Please note that there could be multiple commas in x1. See the example below. 

Thanks in advance.

[caltang]

Please provide relevant data to this use case, and kindly provide your criteria in as much detail as possible. If you have a workflow built halfway, kindly export that over as well.

[DMI10000]

I have now included the data sources. It has the inputs (x1 and x2) and how the output should look like.

x1	x2	output
3 brown street, farleigh, auckland 0010	2 Brown Street Farleigh Auckland 0010	3 Brown Street, Farleigh, Auckland 0010
43/12 irikana road, brownbay, wellington 0020	43/12 Irikana Road Brownbay Wellington 0020	43/12 Irikana Road, Brownbay, Wellington 0020.
c24/23 michael street, auckland 0600	C24/23 Michael Street Auckland 0600	C24/23 Michael Street, Auckland 0600.
567 gold road, golad coast, bay area 3409	566 Gold Road Golad Coast Bay Area 3409	567 Gold Road, Golad Coast, Bay Area 3409
32 mighty crescent, mount smart, tauranga 2010, new zealand	31 Mighty Crescent Mount Smart Tauranga 2010 New Zealand	32 Mighty Crescent, Mount Smart, Tauranga 2010, New Zealand

[caltang]

Hmm, upon investigating - you will need to have a masterlist of addresses to pull this off. Because the placement of commas "," is not consistent. 

I don't think I can be of much help here.