Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I am having a field value with this kind of data DG10101 - NY, DownTown, QP 9.
now I need to load the data into QVW and I wanted to eliminate DG10101 - this value and load only NY, DownTown, QP 9 this .
how can I trim the data. the field name id ''TerritoryName''.
please help me.
You can use subfield if your values always has the same logic that you need the text after the "-" character e.g.
Subfield(TerritoryName,'- ',2) as NewTerritoryName
You can use subfield if your values always has the same logic that you need the text after the "-" character e.g.
Subfield(TerritoryName,'- ',2) as NewTerritoryName
If the data follows the same idea Something1 - Something2 and you want to remove Something1, you can try this:
SubField(FieldName, ' - ', 2) as TrimmedFieldName
I hope this helps.
Best,
Sunny