Extract Data between text

Help
#1

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?

#2

@saneeth_kandukuri

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

output = Path.getFileNameWithOutExtension(input)

1 Like
#3

thank you for your kindly reply

1 Like
#4

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

#5

Did you try a String value instead of generic?

#6

yes but also it is showing error

#7

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
#8

I got it

#9

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