Home Trimming any Leading or trailing characters
Reply: 0

Trimming any Leading or trailing characters

user425
1#
user425 Published in August 16, 2018, 6:17 am

I have a table where I have some raw data. My requirement is to trim any leading or trailing spaces and operator characters in the given string column. Examples of operator characters include + - . > < = : ;"

Examples:

Value +Payment should be trimmed to Payment
Value ->300 Write should be trimmed to 300 Write

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.302486 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO