Remove first letter when consecutive letters are both capital
Hi,
I have a dataset with a reoccurring issue. Whenever two capital letters appear in a row, the first capital letter should be removed.
Example:
George Washing
LAbraham Lincoln
Ronald Reagan
The “L” in front of “Lincoln” should be removed from the string.
Wondering if there is a way to implement this in removeChars for String Manipulation node or Column expressions node?
Thanks,
grossa8