Extract Data between text

I want to extract data between given text…How can i do that?
INPUT : D:\AT&T Project documents\RPA Inputs\A01KVSZ.xlsx

Here in above example…i want to extract data as “A01KVSZ”
OUTPUT : A01KVSZ
How can i do this by matches concept?

@saneeth_kandukuri

input = “D:\AT&T Project documents\RPA Inputs\A01KVSZ.xlsx”

output = Path.getFileNameWithOutExtension(input)

1 Like

thank you for your kindly reply

1 Like

it is showiing error as " getFileNameWithOutExtension" is not a member of generic value…then which variable type it is?

Did you try a String value instead of generic?

yes but also it is showing error

I am using normally in this cases Assign activity:
output = input.Substring(input.LastIndexOf("\")+1).Replace(".xlsx","")
Hope, this help you :slight_smile:

2 Likes

I got it

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