Can this be done?

[Steve_B]

Hi All

I have a string of text in cell A1 similar to this : C:\start\123\solidworks.slddwg (This can vary in length and contents)

In Cell B2 I have a formulae to manipulate the string to get: C:\start\123
I need to get solidworks.slddwg into Cell C2

Any ideas

Steve

 

[Steve_B]

Hi Aladin

I have tried again with still no look!

 

[Aladin Akyurek]

Hi Aladin

I have tried again with still no look!

What do you have in A1 exactly?

What do you need to see in B2 and C2?

 

[Steve_B]

Aladin

This is the full string length. But as I said this can vary!

R:\123\Mach 1\TMFH1\TMH1-04 Tube Fill\TMFH1-04-03 Capper Station\TMFH1-04-03-00 B Capper Assembly.SLDASM

 

[Steve_B]

In B2 I Need to see

R:\123\Mach 1\TMFH1\TMH1-04 Tube Fill\TMFH1-04-03 Capper Station
and in C2 I need to see

TMFH1-04-03-00 B Capper Assembly.SLDASM

 

[Aladin Akyurek]

In B2 I Need to see

R:\123\Mach 1\TMFH1\TMH1-04 Tube Fill\TMFH1-04-03 Capper Station
and in C2 I need to see

TMFH1-04-03-00 B Capper Assembly.SLDASM

I didn't try to figure out why the formula for B2 fails for this "path"...

Here a new set:

B2: (modified)

=LEFT(SUBSTITUTE(A1,C2,""),LEN(A1)-LEN(C2)-1)

C2: (same)

=MID(A1,SEARCH(CHAR(127),SUBSTITUTE(A1,CHAR(92),CHAR(127),LEN(A1)-LEN(SUBSTITUTE(A1,CHAR(92),""))))+1,LEN(A1))

 

[Steve_B]

Aladin

Sorry for the hassle but I am getting

R:\123\Mach 1\TMFH1\TMH1-04 Tube Fill\TMFH1-04-03 Capper Station\TMFH1-04-03-00 B Capper Assembly.SLDAS

as the return from B2

 

[Steve_B]

Thank All it has now been resoved with all your help ray:

This was the final version

B2:=LEFT(A1,SEARCH(CHAR(127),SUBSTITUTE(A1,"\",CHAR(127),LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))))-1)

C2:=MID(A1,SEARCH(CHAR(127),SUBSTITUTE(A1,CHAR(92),CHAR(127),LEN(A1)-LEN(SUBSTITUTE(A1,CHAR(92),""))))+1,LEN(A1))

 

[Aladin Akyurek]

Thank All it has now been resoved with all your help ray:

This was the final version

B2:=LEFT(A1,SEARCH(CHAR(127),SUBSTITUTE(A1,"\",CHAR(127),LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))))-1)

C2:=MID(A1,SEARCH(CHAR(127),SUBSTITUTE(A1,CHAR(92),CHAR(127),LEN(A1)-LEN(SUBSTITUTE(A1,CHAR(92),""))))+1,LEN(A1))

Steve,

Replace the one in C2 by the shorter:

=RIGHT(A1,LEN(A1)-FIND(CHAR(127),SUBSTITUTE(A1,CHAR(92),CHAR(127),LEN(A1)-LEN(SUBSTITUTE(A1,CHAR(92),"")))))

 

[Steve_B]

Will do!

And once again THANKS