Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 494
  • Last Modified:

Need a regular expression to parse between / forward slashes

http://sccps-acorn/ddi/web/DLFT/TEST/one/21stwfd.jpg

1) url above
2) want to be able to identify the word "one". Everything before will be the same.
3) it is going to be the 6th word between the / forward slashes
4) would like to be able to configure which word between slashes ( ie 4th, 3rd etc)
5) i have a workflow that the 6th word will be the deciding factor when to run
6) want to ignore the file name

thank you
0
metatonka
Asked:
metatonka
  • 8
  • 3
  • 2
  • +1
1 Solution
 
Ahmed HusseinCommented:
I can't open the image, i'm getting a network error, but if you want to parse between 2 forward slashes you can use this regular expression.

\/([a-zA-Z0-9]{0,})

Open in new window


or try to upload the image on different site, so i can see what you really mean.
0
 
metatonkaAuthor Commented:
1) sorry for the confusion, that url is not available to the web. It is the example of url that i need the regular express to run on.
2) your suggestion provided the following result  

/;/sccps;/ddi;/web;/DLFT;  

3) what i am looking for is a regular express that gives me the word between two forward slashes in the sixth place after the http:// which in this example would be the word "one".

please let me know if you have any questions.
Thank you for helping.
0
 
Terry WoodsIT GuruCommented:
Try this pattern:
http://(?:[^/]*/){5}([^/]*)

Open in new window

0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
metatonkaAuthor Commented:
i tried extract with your suggestion, it came out blank
0
 
metatonkaAuthor Commented:
my workflow regular expression has 4 options

replace text
check match
split
extract
0
 
Ahmed HusseinCommented:
the solution TerryAtOpus posted, returns to results, the one you need is the second one, so if your RegEX workflow return an array, get the second element of that array.
0
 
metatonkaAuthor Commented:
AhmedGeek i assume you are saying to use http://(?:[^/]*/){5}([^/]*)

this is what happens

use this  (?:[^/]*/){3}([^/]*)  results are http://sccps-acorn/ddi/web/DLFT;
use this  (?:[^/]*/){2}([^/]*)  results are http://sccps-acorn/ddi/web;
use this  (?:[^/]*/){4}([^/]*)  results .....nothing
use this  (?:[^/]*/){5}([^/]*)  results .....nothing

not sure where to proceed.
thanks
0
 
käµfm³d 👽Commented:
What language or editor are you using?
0
 
metatonkaAuthor Commented:
nintex workflow 2007 software on sharepoint 2007
0
 
käµfm³d 👽Commented:
It appears that Nintex has .NET's regex library available. Modifying Terry's previous suggestion, try:

(?<=http://(?:[^/]*/){5})[^/]*

Open in new window

0
 
metatonkaAuthor Commented:
getting closer

using extract

(?<=http://(?:[^/]*/){2})[^/]*   web;
(?<=http://(?:[^/]*/){3})[^/]*   DLFT;
(?<=http://(?:[^/]*/){4})[^/]*   -----nothing-----
(?<=http://(?:[^/]*/){5})[^/]*   -----nothing-----

almost there!!!!!!!!!!!!!!!!!
0
 
käµfm³d 👽Commented:
That I'm not sure about. 4 and 5 work fine for me, and I don't have Nintex available to me for testing.

Screenshot
0
 
metatonkaAuthor Commented:
will ask nintex about their regular expression interpreter...will tell you the results.
0
 
metatonkaAuthor Commented:
response from nintex

This regular expression would work : \w+(?=/[\w\d]+\.[\w\d]+)

We use the .Net Regular Expression engine. The following site is generally what my colleagues and I use when it comes to help build expressions: http://gskinner.com/RegExr/ 

and it does work.

will give you the credit.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 8
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now