Hello All,
I do some manipulation with address data and need to achieve the following.
I have 2 columns. The text in column 1 represents (always) a part of the text in column 2 next to it.
I want to delete this (and only this) part in column 2.
The respective replacement shall always happen in the same row, so e.g. the text in column 1 and 2 always are in the same row.
An example:
Column 1 Column 2 desired result in column 2 after replacement
Test street Test street 2 2
City centre city centre test place test place
Test lane Test lane 121a 121a