How to get the specific part of the string

Help
, ,
1

C:\Users\xxx\yyy\zzzl\qqq\Logs\2019-11-13_Execution.log

Hello All,
In the above expression I need to get the value till third back slash ''.
means till xxx.
here string xxx can be any other string
like karan.arora or anything. but the substring as an output should be till the 3rd back slash.

Please help!

2

image
image1097×744 31.3 KB

3

Heyy ,

I need output as C:\Users\xxx\ or C:\Users\xxx
I guess your solution is giving me xxx

4

Data.Split("\"c)(2).ToString
You can use split method. in above image I am using \ as a separator.

5

Okay got it i thought you want only xxx. I will share another screenshot

6

Here i am using yyy as a separator

image
image1154×776 32.4 KB

7

Hi @Karan28
Use following code in Assign.
System.Text.RegularExpressions.Regex.Match(YourStringVariable,".+(?=\\yyy)").ToString .
Assign it to a string Variable.

8

but the value before third \ can change
like yyy can change
we need to find on the basis of third \ only

9

@Karan28 Then use a substring

Data.Substring(0,13).ToString

It will only work if C:\Users\xxx\ don’t change

10

ss
ss884×338 13.2 KB

Bro YYY will be constant here sorry , and I have applied it it is giving me this

11

Hi @Karan28

for the above string you can utilize the below regEx

^(C:|c:)([^\\]*\\){3}

use matches activity and then you can loop it.

image
image842×490 16 KB

Ajay

12

not working bro

13

@Karan28
Use this Str.Split(cchar("\"))(0)+"\"+Str.Split(cchar("\"))(1).Split(cchar("\"))(0)+"\"+Str.Split(cchar("\"))(2).Split(cchar("\"))(0) or
Use Str.Substring(0,13).

1 Like
14

what kind of data type is CurDir?
If it’s string then change it to Generic Value

1 Like
15

Thankyou Ajay your solution worked

1 Like
16

Thankyou Brother

17

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