What is the Simple Way to find Slash in Given Example

[senthilkumar_rm]

Hi Solvers,


I Have file name as D:DataPersonalsramasamdesktopExceldata.xls

Want to find the 4th Slash() what is simple way


Find Function looks big !!


Thanks

 

[Faseeh]

Hi senthilkumar_rm!


Fourth slesh from which side? Left or right??

 

[senthilkumar_rm]

Hi Faseeh,


From left !!

 

[Hui]

=FIND("",A1,FIND("",A1,FIND("",A1,FIND("",A1)+1)+1)+1)


or


=SEARCH("",A1,FIND("",A1,FIND("",A1,FIND("",A1)+1)+1)+1)

 

[senthilkumar_rm]

Thanks Hui,

 

[Faseeh]

@senthilkumar_rm,


Besides this will also work:

=(LARGE(((MID($A1,ROW(INDIRECT("1:"&1024)),1))="")*ROW(INDIRECT("1:"&1024)),2))

Regards,

Faseeh

 

[Hui]

and a simpler

=FIND(CHAR(135),SUBSTITUTE(G5,"",CHAR(135),4))

Isn't it amazing how many different ways you can skin a cat.

 

[Faseeh]

Yes Hui, Its is correct, similar formula so many combination. I adopted this formula from a recent thread that asked to split text into parts. Things are simpler untill we are not taking into account 'n' no. of slashes. Otherwise it would have been a bit difficult I think.


Only things that limits is how one used these functions.

 

[bobhc]

Between Hui and myself I don't think there are many cats left in our neighbour hoods

 

[Montrey]

@bobhc


hahaha