This discussion is archived
1 Reply Latest reply: Feb 27, 2013 10:58 PM by Marwim RSS

Fetch the file name form document name....

Muthu Newbie
Currently Being Moderated
Hello all,

I am new to development...

I have a doubt, I have a file name in one table like 011abc_XYZSupplier.pdf

from this, I need to take Invoice number and the supplier name from the above file.
ex: upto _ is invoice number (011abc), after _ is supplier name XYZSupplier.

How to achieve this by cursor.

Please help me on this issue.

Thanks and Regards,


  • Correct Answers - 10 points
  • Helpful Answers - 5 points