How to Use Split function or Substring?

Hi All,

I am a beginner and need your support for the below problem.

I get a string value from the mail subject as mentioned below. i need to split it and put it in a separate variables for processing further.

You paid Rs. 8 to Cosmo Juice And Cakes

In the above sentence the want “8” and “Cosmo Juice And Cakes” to be stored in Variables Amount and Vendor.

I’m thinking of using split function.I want to store the value before “to” in Amount variable and after “to” in Vendor variable.

Can someone suggest me,how can i do this?

Hi @kiranbgtechm
See this post:

Hope this helps

1 Like


Here is a xaml file detailing how to achieve that. Hope this helps

spilitstringarray.xaml (5.9 KB)

1 Like

Outside of what was already linked… I recommend reading through the following so you understand the Split and Substring call.

1 Like

Thanks a lot! :slight_smile:

Thank you so much Raghavendra! :slight_smile:

Thank you for sharing :slight_smile: will go through

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