Crystal Reports 2008 to extract data

[guesswhoami]

I'm using Crystal Reports 2008 to extract data from
/XYZ/ABC/1433 .rpt/

How do i extract data upto /XYZ/ABC/ and display that as a folder name

 

[guesswhoami]

This is how the data in the table is

When a report is in scheduled status then the FolderPath consists of the FolderName as well as the Report Name.This is the case for all scheduled reports

FolderPath Status ReportName
/CustomerDetails/CustomerDetails.rpt/ Scheduled CustomerDetails.rpt
/User Folders/ABC/Emergency_SIT_Reconciliation Summary / Scheduled Emergency_SIT_Reconciliation Summary


When a report is in Viewed status then the FolderPath consists of the FolderName only.This is the case for all viewed Reports

FolderPath Status ReportName
/Product/ProductInventory/ProductDetails/ Viewed New Product Details.rpt


I would like to split the FolderPath such that i get only the folder and subfolder name


Hopefully this helps.