Home Trim a part of a String
Reply: 0

Trim a part of a String

user655
1#
user655 Published in June 19, 2018, 6:17 pm

Thank you in advance.

I have a table with a column which is long.

I need to take only the name from the column.

This is the column name:

QSTY-IOM-HFVNBJGYG | Mobile #: 9876541323 | CUSTOMER NAME: MNOP UNIPOUYTREA POIUY | INVOICE DATE:02/28/18 | EMP#: 101466 | EMPLOYEE NAME: ANGELINA CASIANO

I just need to pick up the customer name from this column. I tried Charindex and it was displying an error message of

Invalid length parameter passed to the LEFT or SUBSTRING function.

output:

MNOP UNIPOUYTREA POIUY
You need to login account before you can post.

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

© 2016 Powered by mzan.com design MATCHINFO