I am trying to map one field to multiple fields. I tried to use the "substring" function, but that will not work because the string being parse as varying length. However, the string as a common delimiter (.)
Location = WV.L2.D3.F1.0
- Loc1 = WV
- Loc2 = L2
- Loc3 = D3
- Loc4 = F1
This would be easy if the Location data is a fixed length and pattern
but Location could be any of these pattern below
You can use the tokenize function
Create a local variable "var1" on the target field like "Loc1" in which use the below function:
Map this local variable "var1" to the target field "Loc1" using the textual rule.
Similarly create another local variable "var2" on the second target field like "Loc2" in which use the below function:
Map this local variable "var2" to the target field "Loc2" using the textual rule.
You can follow the above steps for other target fields as well.
If you are using Adeptia v6.1 and above, you will need to change your XSL Transformer
- Change the XSL transformer from Saxon to Xalan(Actions>>XSL Transformer)