I want to extract word which matches a pattern like ‘RXXXXX’ from a text column into a new column. The word starts with letter ‘R’ and contains alphanumeric characters and the delimiter can be ‘;’ or nothing.The word length can vary. Below is the sample input and output required