Thanks for any help!
Solved
I am trying to remove duplicates within an attribute that vary per cell. For example in the column (ukHabpCode) I have uu1bu1b5 which separated would be u,u1b,u1b5, but I want to remove the duplicates so I am just let with u1b5 (see figure below).
Best answer by ebygomm
So you could use a stringsearcher to get the alternate letter number combination at the end of the string
[A-Za-z]\d[A-Za-z]\d$So this would give you u1b5, r1a6, g1a6 etc.
But how do you want the other cases handled?
+33- Influencer
- Best Answer
So you could use a stringsearcher to get the alternate letter number combination at the end of the string
[A-Za-z]\d[A-Za-z]\d$So this would give you u1b5, r1a6, g1a6 etc.
But how do you want the other cases handled?
Thats great! for the other columns, I want to keep the s, the blank as these do not contain duplicates, and the columns that are like ff2d I want f2d as the output? Thanks so much!
+33- Influencer
lottielbrowne wrote:
Thats great! for the other columns, I want to keep the s, the blank as these do not contain duplicates, and the columns that are like ff2d I want f2d as the output? Thanks so much!
If you add a * to the regex to make the last digit optional i think that works for the ff2d scenarios as well
[A-Za-z]\d[A-Za-z]\d*$Then if you want to match a single letter as well you can add an alternative regex match by separating the two statements with the pipe character |
[A-Za-z]\d[A-Za-z]\d*$|^[A-Za-z]$
ebygomm wrote:
If you add a * to the regex to make the last digit optional i think that works for the ff2d scenarios as well
[A-Za-z]\d[A-Za-z]\d*$Then if you want to match a single letter as well you can add an alternative regex match by separating the two statements with the pipe character |
[A-Za-z]\d[A-Za-z]\d*$|^[A-Za-z]$
yes that works, do you know what expression will allow me to include the s value?
+33- Influencer
ebygomm wrote:
If you add a * to the regex to make the last digit optional i think that works for the ff2d scenarios as well
[A-Za-z]\d[A-Za-z]\d*$Then if you want to match a single letter as well you can add an alternative regex match by separating the two statements with the pipe character |
[A-Za-z]\d[A-Za-z]\d*$|^[A-Za-z]$
The second regex expression above should match a single letter, so should work for the s value
[A-Za-z]\d[A-Za-z]\d*$|^[A-Za-z]$
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.