Splitting string error

Help Studio
, ,
1

C:\Users\naveenkumar.s.clo\3D Objects\NACH\JSFB_2021-07-05-ACHDR Present2-S002 - Settlement Detail Report.xls
C:\Users\naveenkumar.s.clo\3D Objects\NACH\JSFB_2021-07-05-ACHDR Present2_R-S002 - Settlement Detail Report.xls
From i want only ACHDR Present2,ACHDR Present2_R can anyone please help me on this??

2

in some name contains “_R” like in this “JSFB_2021-07-05-ACHDR Present2_R”.
in Some name it wont contains “_R” like in this “ACHDR Present2-S002”.

3

You need the Like this?
“JSFB_2021-07-05-ACHDR Present2_R”.
or
“ACHDR Present2_R” This is enough

4

@Sudharsan_Ka “ACHDR Present2_R”

5

Have you tried with regex?

1 Like
6

No i didn’t try using regex I am trying using substring and split functions.

7

@HeartCatcher can you try below regex pattern ?

[\d]{4}-[\d]{2}-[\d]{2}-(.*)-

It seems to be working regex101: build, test, and debug regex

1 Like
8

@AkshaySandhu

Screenshot (19)
Screenshot (19)1366×768 92.5 KB

I am new to uipath can you please guide whether it is correct which is in photo.??

9

If you need you can try this here is the regex

And
Here is the workflow with split
Sample.xaml (5.6 KB)

Regards,
Sudharsan

1 Like
10

Hi,

Another solution:

arrStr = yourString.Split("-"c)

then

arrStr(arrStr.Length-3).Trim

Regards,

1 Like
11

시퀀스4.xaml (6.8 KB)

1 Like
12

@Sudharsan_Ka

Screenshot (20)
Screenshot (20)1366×768 78.9 KB

Actually file name look as in the photo it is not static, some time the file will going change.
I just need the data in between “JSFB_2021-07-05-” and “-S002 - Settlement Detail Report” these two are same in every file.

13

try this in log message
System.Text.RegularExpressions.Regex.Match(str_input,"[\d]{4}-[\d]{2}-[\d]{2}-(.*)-").Groups(1)

1 Like
14

Then You can use this inside the for each

Directory.getFiles(“C:\Users\naveenkumar.s.clo\3D Objects\NACH”)

And here is the sample workflow
Sample.xaml (6.1 KB)

15

@Sudharsan_Ka , thanks very much for your response, it is working fine now. may I know Split(Demo,“-”)(3): what does it do
I know that split is a function, Demo is variable and splitting based on “_” but what does (3) is stands for. please dont mind i am asking too much

16

If we use like this it will be in array type
So for that i have given the array index there

Regards,
Sudharsan

17

Ok thanks.

18

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