Replace text to left of "\"

ncoatney

New Member
Joined
Jan 4, 2018
Messages
6
I'm needing help replacing the text to the left of the first \ from the right.

example:

\\jaja\aaa\hhhh\jias.par

replaced with

a:\aa\aaa\jias.par

Where it becomes difficult is the string of text to the left and the right of the last \ varies in length
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Maybe its just me, but I am not overly clear on what it is you are replacing with what.
Could you post a few more examples, of the BEFORE and AFTER values (what the value looks like BEFORE the replacement, and what you want it to look like AFTER the replacement)?
 
Upvote 0
Maybe its just me, but I am not overly clear on what it is you are replacing with what.
Could you post a few more examples, of the BEFORE and AFTER values (what the value looks like BEFORE the replacement, and what you want it to look like AFTER the replacement)?

Few more examples:

BEFORE:

\\hp-cen-fs1\iMigrateData\revisions\PF CONFIGURATOR\188756\KP100881.par
\\hp-cen-fs1\iMigrateData\revisions\PF CONFIGURATOR\213254\KP102050_ver1.par
\\hp-cen-fs1\iMigrateData\revisions\PF CONFIGURATOR\Custom Parts\KP4937.par


AFTER:

Q:\SigmaNest\SigmaNest X1 SP4\Parts\KP100881.par
Q:\SigmaNest\SigmaNest X1 SP4\Parts\KP102050_ver1.par
Q:\SigmaNest\SigmaNest X1 SP4\Parts\KP4937.par
 
Upvote 0
Try using Find/Replace, replacing:
\\hp-cen-fs1\iMigrateData\revisions\PF CONFIGURATOR\*\
with
Q:\SigmaNest\SigmaNest X1 SP4\Parts\

A formulaic approach would be to use a formula like this (for an entry in cell A1):
Code:
="Q:\SigmaNest\SigmaNest X1 SP4\Parts\" & TRIM(RIGHT(SUBSTITUTE(A1,"\",REPT(" ",200)),200))
 
Upvote 0

Forum statistics

Threads
1,223,904
Messages
6,175,295
Members
452,633
Latest member
DougMo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top