I have thousands of three-letter codes separated by either “/”, “-” or “*” or a combination of them. I would like to understand how many unique formats they are written in, please. The letters in the code do not matter, just how they are separated, therefore I have just used A’s in the example table below:
Column A |
---|
AAA/AAA |
AAA/AAA/AAA |
AAA*AAA-AAA/AAA |
AAA/AAA*AAA/AAA |
AAA/AAA-AAA |
AAA/AAA-AAA/AAA |
AAA/AAA-AAA-AAA*AAA-AAA/AAA |
Thanks in advance!
I have tried to define a function to extract patterns but not had any success yet
New contributor
normsky is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.