Substring or Split of a data that contains slash (/)

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

Hi ,
You can use split in the way shown below
Split(input_string,"/")(0)

1 Like

Hi @Tanzill_Ahsan ,

You can also use substring for this case.

Test.xaml (4.9 KB)

2 Likes

thank you I get my expected result

1 Like

@ermanoj3101 thank you

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.