Data Environment - Data Report - manipulating string

Hello

I'm using Data Environment to produce report.
The problem is, how can I manipulate the string for e.g., in the database, the asset type is "LAND - FREEHOLD". But what I want to produce in the report (data report) is the word "FREEHOLD" only (without "LAND - ").

Can anyone help me? Thanks.

what i can advise is split the asset type to asset in your database. for organization purpose also

Hello...

Thanks 4 the idea. I'll take ur advise :thumb: