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

Help Activities
, ,
1

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

2

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

1 Like
3

Hi @Tanzill_Ahsan ,

You can also use substring for this case.

image
image1718×629 22.9 KB

Test.xaml (4.9 KB)

2 Likes
4

thank you I get my expected result

1 Like
5

@ermanoj3101 thank you

1 Like
6

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