Hi all,
I have a very trick problem to replace some part of the order number in this table
before | after |
2SCP6TVU | 2SCP6TVU |
3UIOV8SC | 3UIOV8SC |
3UIOV8SCSCR | 3UIOV8SC |
2PJHQ5MCSC | 2PJHQ5MC |
2PJHQ5MCSCR | 2PJHQ5MC |
2NURAQHCSCRSC | 2NURAQHC |
EYA1800027061SC | EYA1800027061 |
EYA1800027061SCR | EYA1800027061 |
I need to remove the SC or SCR or SC- in the string. but only in the ending part of the data. If SC is in the middle of the string, then don't remove like row 1. But the number of the SC or SCR is not certain. Maybe there will be like SCRSC- or SCSCR or SCSCRSC or SCSCRSCSCR. But all the SC, SCR, SC- are in the ending part. However, sometimes the data may end with SC like row 2, don't remove it. so another information is that order number is only in 8 or 13 digit. This is very complicated. Thank you guys.
Solved! Go to Solution.
Hi @mceleavey ,
I like your solution but wanted to add....
SC\b|SCR\b|SC-\b
looks for boundaries at the end of the "word" as an alternative. this technique is useful if multiple words could exist in a field.
Cheers,
Mark
Good point, @MarqueeCrew