Hi All,
I have a task which is related to split text.
my input data is look like below :
1.Customer Invoice
2.Customer Address
3.Order Quantity
4.Order Status
Expected out put :
1.CI
2.CA
3.OQ
4.OS
Here i am confusing how to work with trim , in string and length functions.
Any one please share best solution.
I have a task which is related to split text.
my input data is look like below :
1.Customer Invoice
2.Customer Address
3.Order Quantity
4.Order Status
Expected out put :
1.CI
2.CA
3.OQ
4.OS
Here i am confusing how to work with trim , in string and length functions.
Any one please share best solution.