How to extract a particular word after 7th slash in a path using regex

Question

I have different paths in a column like below:

'E:/R_Process/R_Input_UDM//Greater Europe/CEW Hub/Austria/Toothpaste/Variant Data/AUSTRIA_SHG_VARIANT_8.csv'
'E:/R_Process/R_Input_UDM//Greater Europe/CEW Hub/Austria/ManualTB/Variant Data/AUSTRIA_SHG_VARIANT_7.csv'
'E:/R_Process/R_Input_UDM//Greater Europe/CEW Hub/Austria/MouthWash/Variant Data/AUSTRIA_SHG_VARIANT_9.csv'

I want Toothpaste from 1st path, ManualTB from 2nd, and MouthWash from 3rd.

There are many more paths around 30 every from every paths I want the word from 7th slash.

How can I do this using regex?

This would be better done with a tool that understand's paths (eg. PowerShell's `Split-Path`) than with a regex. — Richard, Nov 19 '18 at 09:25

score 0 · Answer 1 · answered Nov 19 '18 at 09:21

0

You can use the following regex:

(?:\/([^\/\n]*)){7}

Check Regex Demo

Required keywords would be in capture group 1

answered Nov 19 '18 at 09:21

karthik manchala

13,492
1
31
55

its giving me error like this [ Error: '\/' is an unrecognized escape in character string starting ""(?:\/" ] – shantam malgaonkar Nov 19 '18 at 09:28
@shantammalgaonkar Which editor/language are you using? you can try this one.. without escape characters: `(?:/([^/\n]*)){7}` – karthik manchala Nov 19 '18 at 09:34
using R studio to extract the word i mentioned – shantam malgaonkar Nov 19 '18 at 09:52
now its showing me this error -{Error in stri_extract_last_regex(employ.data$Path, "(?:/([^/\n]*)){7}") : could not find function "stri_extract_last_regex"} – shantam malgaonkar Nov 19 '18 at 09:54
@shantammalgaonkar Can you verify the output of `stri_install_check(silent=TRUE)` in your code?.. it should return `true` – karthik manchala Nov 19 '18 at 10:05
employ.data$Extract =stri_extract_last_regex(employ.data$Path, "(?:/([^/\n]*)){7}") i am susing this line where i am creating new column extract and taking the words from the Path column – shantam malgaonkar Nov 19 '18 at 10:20

Pushpesh Kumar Rajwanshi · Answer 2 · 2018-11-19T10:59:49.710

0

You can match any optional characters followed by a slash and capture the word following it by using this regex,

(?:.*?\/){7}(\w+)

Explanation:

(?:.*?\/){7} --> Non capture group matching any optional characters followed by / seven times
(\w+) --> Capture the following word in group 1

Demo

Let me know if this works fine for you.

edited Nov 19 '18 at 10:59

answered Nov 19 '18 at 10:35

Pushpesh Kumar Rajwanshi

18,127
2
19
36

Showing me this error Error: '\/' is an unrecognized escape in character string starting ""(?:.*?\/" – shantam malgaonkar Nov 19 '18 at 10:53
Can you try this regex (?:.*?\Q/\E){7}([a-zA-Z]+) and see if it works? I will update my answer if this works. I never programmed in R language so not sure if slash further needs double escaping or there is some other issue. – Pushpesh Kumar Rajwanshi Nov 19 '18 at 11:17
showing me this error [Error: '\Q' is an unrecognized escape in character string starting "" (?:.*?\Q"] – shantam malgaonkar Nov 20 '18 at 03:24

How to extract a particular word after 7th slash in a path using regex

2 Answers2