Hi Everyone
I have a input column where user will enter customer Number seperated by comma. The input can be anywhere form 1 customer to 20 customers.
Customer Input
12,A345,456,T877
43
456,989,111,235,345,875
34,46
The output i want is each customer number encolsed with certain fixed text.
Output
ThursdaySale={12-ontime-,A345-ontime-,456-ontime-,T877-ontime-}
ThursdaySale={43-ontime-}
ThursdaySale={456-ontime-,989-ontime-,111-ontime-,235-ontime-,345-ontime-,875-ontime-}
ThursdaySale={34-ontime-,46-ontime-}
How can achieve desire output, please guide.
Thanks
Bookmarks