Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have field
(Region)
AP_India_1234
Result: India-1234
I want result like that then what should I do for that
Thanks
Hey,
Try this:
SubField(Region,'_',2)&'-'&SubField(Region,'_',3)
Regards,
Amrinder
Hey,
Try this:
SubField(Region,'_',2)&'-'&SubField(Region,'_',3)
Regards,
Amrinder
May be this?
T:
Load SubField(Region,'_',2)&'-'&SubField(Region,'_',3) as Result
Table_Name.qvd;