remove part of a string (contingent upon number of periods within that string)?
I have a column with strings of varying length. All strings have 1 semicolon separating the first and last part of the string.some strings with no 'periods':_______________;______some strings with 1 period______.______;_______some strings with 2 periods___._______._____;_________I want to create a new column and populate it with the string of interest with the following conditions:IF a string con...
