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