Input String: ABCD/IC/STAN.CHA/PAINTS LTD
Expected output String: ABCD
Here I want to take the first part before the first slash. Which is ABCD but it can be anything like ABC or AB(Dynamic).
I need help regarding this substring/split command.
I need it for excel automaion