i thought this would be really straightforward but alas not

This is what i want to do .i have a field called "filepathtext" it contains the filepath of a file .I want to take that field and remove the filepath section of it EG OSX:file:myfile^gnat. i would like to move the "myfile" part to one field and the text after "^" to another field . the problem is i cannot use a "left/Right/Middleword" statement because each record has a different file path and therefore a different length ,what i am trying to do is find a function that finds SPECIFIC TEXT and not WHERE it is ...

any ideas

THanks

Paul Apted

Paul,

Using the right function along with the length & position function will find anything after the ^.

So create your filename calculation field to be the following with a result of text.

Right(filepath, Length(filepath) - Position(filepath, "^", Length(filepath), -1))

HTH

That worked thank you for your help

Paul

Hi Paul,

I'm glad that Andy's calculation was helpful to you. I was just wondering if you were able to find the second calculation to move the "myfile" side into a separate field too?

Lee