Hi All,
I'm hoping to transform a particular column using a regular expression (which are new to me) but have been struggling to do so.
Each cell in the column contains a series that always starts with a group of one or more letters, followed by one or more numbers, another letter followed by one or more numbers, then either a letter followed by one or more numbers or a series of numbers.
In short, it typically looks something like this: AB 1234 C56 2000 or AB 1234 C56 D78.
I need to transform the column so that third chunk of each entry will begin with a period: e.g. AB 1234 .C56 2000 - I haven't been able to accomplish this without getting rid of the following text.
Any suggestions?