special characters in my column
-
hi experts. i have a several special characters in my column like example goes here empno emp name 1 ve?u.r 2 raj 3 venki 4 Stáció 5 gái 6 Vecsés 7 Mosonmagyaróvár 8 sachin i want to list out the names with only special characters plz help me out regards venu
-
hi experts. i have a several special characters in my column like example goes here empno emp name 1 ve?u.r 2 raj 3 venki 4 Stáció 5 gái 6 Vecsés 7 Mosonmagyaróvár 8 sachin i want to list out the names with only special characters plz help me out regards venu
Use regular expressions to match the special characters. Regular Expressions Make Pattern Matching And Data Extraction Easier[^] The expression would be something like "[\u0041-\u005A]", which matches character range from A to Z.
Eslam Afifi
-
hi experts. i have a several special characters in my column like example goes here empno emp name 1 ve?u.r 2 raj 3 venki 4 Stáció 5 gái 6 Vecsés 7 Mosonmagyaróvár 8 sachin i want to list out the names with only special characters plz help me out regards venu
use patindex function to find out the column with special character .
-
hi experts. i have a several special characters in my column like example goes here empno emp name 1 ve?u.r 2 raj 3 venki 4 Stáció 5 gái 6 Vecsés 7 Mosonmagyaróvár 8 sachin i want to list out the names with only special characters plz help me out regards venu
-
i have 10000 rows in that different different special characters r there how can i list with patindex plz specify
ex a-zA-Z0-9 the above pateern will accecpt only value in betwwn them for other they will return for presence of special character . plz check it