Applies to Infiniti v8.0 or later
If your data source returns a data field and you need to remove unneeded characters, Infiniti has three formula functions to help manipulate the field:
Left() and Right() take the leftmost/rightmost characters of a field, whereas subString() extracts the inner parts.
For example if the field 'AABBCC (OCT 2005)' was returned by a data source:
left([YOURREF],6) would return 'AABBCC'
right([YOURREF],10) would return '(OCT 2005)'
subString([YOURREF],9,8) would return 'OCT 2005'
use the trim() function to clean up any unneeded white space.
data format split manipulate fields return data sources