Extract Last Part of a String

[khdavis]

Hi All, I'm using CR10/Oracle database and trying to extract the last part of a string that looks something like this --

C:\Documents and Settings\bha\My Documents\Problem Management\FINAL\2763213 AIG Europe AIU PARSEXC2 FailedArray.pdf

I need to get everything after the last "\" (basically the file name).

The path can change, so there is no consistency with the number of "\" that are found.

Any help would be greatly appreciated! Thanks!

 

[lbass]

Use a formula like:

stringvar array x := split({table.string},"\");
x[ubound(x)]

-LB

 

[khdavis]

Thank's lbass. That worked for me!

 

[IdoMillet]

Here's a slightly simpler solution:

Mid({table.string}, InstrRev ( {table.string} , '\') + 1)

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com