Replace string between back slash

Question

0.00/5 (No votes)

See more:

Hi All.
Really need some help here.
I need to replace the string between the second and third back slash. There will always be a second and third slash.

IncludeFiles = \\mckirlwebpd3srv\CDODFiles

Thanks in advance for any help given

What I have tried:

nothing tried so far as not sure where to start

Posted 27-Mar-18 23:42pm

johnjsm

Updated 27-Mar-18 23:51pm

Add a Solution

2 solutions

Solution 1

I would use the Regex.Replace Method (String, String) (System.Text.RegularExpressions)[^].

Posted 27-Mar-18 23:48pm

CPallini

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2018-03-27T23:53:00

Solution 2

Try:

VB

Imports System.Text.RegularExpressions
...
Public Dim regex As Regex = New Regex( _
      "(?<=\\\\).+(?=\\)", _
    RegexOptions.Multiline _
    Or RegexOptions.Singleline _
    Or RegexOptions.CultureInvariant _
    Or RegexOptions.Compiled _
    )
...
Dim result As String = regex.Replace(strInput,strReplacement)

Quote:

I'm new to Regex and I should have given the full string
IncludeFiles = \\mckirlwebpd3srv\CDODFiles\71669\ClaimReviewCustomizationGuideV61.pdf
Output I need is
IncludeFiles = p:\CDODFiles\71669\ClaimReviewCustomizationGuideV61.pdf

Ah! Change the regex string to:

VB

Public Dim regex As Regex = New Regex( _
      "\\\\.+(?=\\)", _

Posted 27-Mar-18 23:53pm

OriginalGriff

Updated 28-Mar-18 0:37am

v2

Comments

johnjsm 28-Mar-18 6:06am

The input string will be different form time to time so I will not know what the input string will be

OriginalGriff 28-Mar-18 6:23am

That's ok - provided the bit you want to replace starts with "\\" and ends with "\" it will work: that's the whole idea of a regular expression. Try it and see!

If your input string doesn't always have that format, then you need to look at a whole load of examples of genuine inputs and find some "similarity" that can be used as a basis for checking - or no automatic system will work!

johnjsm 28-Mar-18 6:24am

I'm new to Regex and I should have given the full string
IncludeFiles = \\mckirlwebpd3srv\CDODFiles\71669\ClaimReviewCustomizationGuideV61.pdf

Output I need is
IncludeFiles = p:\CDODFiles\71669\ClaimReviewCustomizationGuideV61.pdf

OriginalGriff 28-Mar-18 6:36am

You need to be precise when you tell us things! :laugh:
See updated answer.

johnjsm 28-Mar-18 6:44am

I guess i'm excited that today is my Friday and can't wait to get out of work.
I tried the update on the following

IncludeFiles = \\mckirlwebpd3srv\CDODFiles\71669\ClaimReviewCustomizationGuideV61.pdf

I get this output
\\mckirlwebpd3srv\CDODFiles\71669

OriginalGriff 28-Mar-18 6:51am

Show me the exact code you used to get that - I get exactly what I expected!

johnjsm 28-Mar-18 6:59am

I was testing it in a regex designer. I'll start the code and check it out. Sorry Regex baffles me

johnjsm 28-Mar-18 7:03am

Dim strInput As String = "IncludeFiles = \\mckirlwebpd3srv\CDODFiles\71669\ClaimReviewCustomizationGuideV61.pdf"
Dim strReplacement As String = "p:\"
Dim regex As Regex = New Regex( _
"\\\\.+(?=\\)", _
RegexOptions.Multiline _
Or RegexOptions.Singleline _
Or RegexOptions.CultureInvariant _
Or RegexOptions.Compiled _
)
Dim result As String = regex.Replace(strInput, strReplacement)

MsgBox(result)

OriginalGriff 28-Mar-18 7:12am

I see the problem! You need a "as few as possible" in there:
"\\\\.+?(?=\\)", _

Get a copy of Expresso[^] - it's free, and it examines and generates Regular expressions.

johnjsm 28-Mar-18 7:49am

It works. Thanks a million

OriginalGriff 28-Mar-18 7:58am

You're welcome!