0
I need to Retrieve Rows from table, in the Column [Client Name].
My request is need to Prevent Names that Start or End with a [:space:] or other special Character [:Punct:], excluding the dot '.' - at the end of the Name. The Idea is to pull Names that are Possible inconsistencies.
examples that must appear:
- 'GEORGE & SON ' - has an extra space at the end.
- '-GEORGE & SON' - has an extra '-' at the start.
- '&GEORGE & SON' - has an extra '&' at the start.
- '-GEORGE & SON S.A.' - has an extra '-' at the start. The Dot '.' at the end it’s not a problem.
- 'GEORGE & SON.. ' - has not one, but two Dots at the end. That is an Exception for the strings that ends with more than one '. '; they are also bad Names.
examples that must not appear: 'GEORGE & SON.' - Only has an extra '.', at the end.
I’m using the Expression: REGEXP_LIKE(col, '( [[:Punct:]]|[[:Punct:]]$)|( [[:space:]]|[[:space:]]$)') But in spite of retrieving Names that start or end with space or special characters, is also Pulling the ones that have a dot '.' on last Character.
Can anybody help me, Please?
Leopoldo Fernandes Lisbon - Portugal
Welcome to [en.so]! Please click on [Edit] and translate the question into Portuguese.
– hkotsubo
I am so sorry. I put this question in the American Stackoverflow and I got a satisfactory answer. I thank you for the comment hkhotsubo.
– LEOPOLDO
All right, you can still [Edit] the question and leave it in Portuguese if you like. Or delete it if you think it is no longer necessary. :-)
– hkotsubo