Separate part of a path on Excel

Help Activities
, ,
1

Hi Team,

I had an assign activity to separate part of this path
“K:\QualityAssurance\Majid Al Futtaim\MAF\Omar\Transformation\Projects\BOTs\Onboarding BOT\OB Folder\Account 1\IDs”
and the part i wanted to separate was "Account 1 " and the expression was

System.Text.RegularExpressions.Regex.Match(DTPhotos, “Account\s\d+”).Value

however the plan has changed and the new path is \10.124.101.70\eg\Cairo\Public\Power BI\Onboarding WFRs\Talabat - Talabat AVENE GHC BO - 1 - 3858199\National IDs

so how can i modify the expression to take the “Talabat - Talabat AVENE GHC BO - 1 - 3858199” part please note: that this part could have numbers or not it could be anything so i need to separate the part between Onboarding WFRs and National IDs

2

@omar_ismail

Ifeally if you need the last second then you can use this…irrespective of ehat is there before and after

Str.Split({"\"},StringSplitOptions.None)(Str.Split({"\"},StringSplitOptions.None).Count-2)

Str is the variable where the required path is stored

Cheers

3

@omar_ismail

You can get that by using this expression:

Result = str_Path.Split("".ToCharArray).Reverse()(1)

Hope it helps.

4

image
i got this error

5

@omar_ismail

Str should be the variable whoch contains your string…please declare a variable as str or replace str with the actual variable you have the path in

Cheers

6

Hi @omar_ismail

You can use the split function to split by the \ slash, can get the output.
Follow the below one

Store the path in a String variable
- Assign -> Demo_Str = " \10.124.101.70\eg\Cairo\Public\Power BI\Onboarding WFRs\Talabat - Talabat AVENE GHC BO - 1 - 3858199\National IDs"
Take another assign and store the array of split in array variable
- Assign -> Demo_Arr = Demo_Str.Split("\")
Take another assign activity to store the output String variable
- Assign -> Output = Demo_Arr(Demo_Arr.Length-2)

Follow the below workflow for better understanding

image
image892×576 70.4 KB

You can use the same workflow for both paths to extract account1 nd Talabat - Talabat AVENE GHC like this.

Hope it helps!!

1 Like
7

Thank you @omar_ismail

If you find the solution for your query. Mark it as solution to close the loop.

8

YourStrPath.Split ("" c, StringSplitOptions.RemoveEmptyEntries.RemoveEmptyEntries).Reverse(). Skip(1).Take(1). First()

9

Try below

strPath = "\\10.124.101.70\eg\Cairo\Public\Power BI\Onboarding WFRs\Tealabat - Talabat AVENE GHC BO - 1 - 3858199\National IDs"

Log Message = Path.GetFileName(Path.GetDirectoryName(strPath))
10

Hi
Try this in Assign
InputPath= \10.124.101.70\eg\Cairo\Public\Power BI\Onboarding WFRs\Talabat - Talabat AVENE GHC BO - 1 - 3858199\National IDs
Output= System.Text.RegularExpression.Regex.Match(InputPath,“(?<=Onboarding WFRs).*(?=National IDs)”)

Thanks