SubField function is missing

[avigdova]

Hi,

Is anybody know why the 'SubField' function is missing in the 'Add calculated field' in the Data Manager screen?

Even when typing the expression - SubField(TableName, '_' , 2)

I get error message (invalid function).

Of course while typing it in the  Data Load Editor, its working.

[ogster1974 · Accepted solution]

Data manager handles it differently.

Go to your field and view details you'll get the option to Split the field on a delimiter in your case _

[avigdova]

Got it. Thank you!