i have column like........
Customer and designation (column heading)
_____________________________________________
customer5-Designation5,customer4-Designation4customer5-Designation5,customer4-Designation4customer5-Designation5,customer4-Designation4customer5-Designation5,customer4-Designation4customer5-Designation5,customer4-Designation4Name
----------------------------------------------
customer5-Designation5,customer4-Designation4,customer5-Designation5,customer4-Designation4customer5-Designation5,customer4-Designation4customer5-Designation5,customer4-Designation4 ---> Second Colomn
----------------------------------------------
customer6-Designation6 ---> Third column
---------------------------------------------
-
----------------------------------------------
-
----------------------------------------------
-
-
so i want to get substring "customers" from each column.
can i have any string function and solution for this query.
Thank u .