Comparing two similar strings and inserting commas

Question

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.

string_manip.PNG

caltang · Answer

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.

DMI10000 · Answer

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

x1x2output3 brown street, farleigh, auckland 00102 Brown Street Farleigh Auckland 00103 Brown Street, Farleigh, Auckland 001043/12 irikana road, brownbay, wellington 002043/12 Irikana Road Brownbay Wellington 002043/12 Irikana Road, Brownbay, Wellington 0020.c24/23 michael street, auckland 0600C24/23 Michael Street Auckland 0600C24/23 Michael Street, Auckland 0600.567 gold road, golad coast, bay area 3409566 Gold Road Golad Coast Bay Area 3409567 Gold Road, Golad Coast, Bay Area 340932 mighty crescent, mount smart, tauranga 2010, new zealand31 Mighty Crescent Mount Smart Tauranga 2010 New Zealand32 Mighty Crescent, Mount Smart, Tauranga 2010, New Zealand

caltang · Answer

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.