Remove values after minus symbol

[Anonymous]

Hi,

I'm loading data from sample.qvd file where from the values are coming as illustrated below in the table format "Current Output" but I need output like "Required Output" column.

Current Output	Required Output
Parent-ABC-111	Parent-ABC-111
Parent-ABC-111-AB0	Parent-ABC-111
Parent-ABC-111-AB1	Parent-ABC-111

Regards,

[jpapador · Accepted solution]

If you always want the first three you could do something like the following:

Subfield([Current Output], '-', 1) & '-' & Subfield([Current Output], '-', 2) & '-' & Subfield([Current Output], '-', 3) as [Required Output]

[Anonymous]

Or maybe something like this :

     = left (  'Parent-ABC-111-AB0' ,  index ( 'Parent-ABC-111-AB0' , '-' , 3) -1 )