how to get the last word after space

[arnie_nits]

Hi ,

I have a requirement where I need to get the last word after space..e.g:
from ABC XYZ I should pick XYZ and from ABC XYZ ASD I should pick ASD....

Please suggest...
Regards,

[chulett]

One solution: use DCount() to get the number of fields then use that count in the Field() function to get the last field:

Code: Select all

Field(YourField," ",DCount(YourField," "),1)

[ray.wurlod]

If DCount() is identified as invalid when you validate the expression, use Count() instead.

Code: Select all

Field(YourField," ",Count(YourField," ")+1,1)

[chulett]

Curious under what circumstances DCount() might be considered invalid?

[ray.wurlod]

For example, if DCount() were not in the DSParams file, which did happen in one point release. Or if DCount() has been removed from DSParams.