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()
-
right()
-
substring()
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.
Related Articles
Keywords
data format split manipulate fields return data sources
Article ID: 181, Created: August 1, 2012 at 1:56 PM, Modified: January 17, 2017 at 11:43 AM