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
You can use split in the way shown below
Hi @Tanzill_Ahsan ,
You can also use substring for this case.
Test.xaml (4.9 KB)
thank you I get my expected result
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.