Description

How can I split a field into 3 different fields (columns)?
Example: field value 345-9871-265
The – would be the split factor. One field 345 and other 9871 and the other 265.

Applies To

11x;12x

Solution/Immediate Workaround

This can be achieved by small Java rule.
for example

$form.getValue("xPath").split("-")[0]; will give the first part

$form.getValue("xPath").split("-")[1]; second part and so on.

Please see attached solution as an example; Review and let me know if you need further assistance with this.

Same code can be written for Repating table only Xpath field name will be the name of column. Attached example has both scenarios ; it has been created in version 12.0.