I have several fields that are being extracted using Mode: Location from a text file and creating an XML file. I am trying to add a new field that combines two of these fields OMBU and OrderNumber but cannot find the correct syntax for the Concatenation String field. OMBU starts at 43 and ends at 47, OrderNumber starts at 208 and ends at 217. I assume the Concatenation String field can be used, but how?
Just use data.extract(43,47,0,1,“”) +" " + data.extract(208,217,0,1,“”)
This concatenates both fields with a blank space in between.
The concatenation string cannot be used in this instance because it is used to concatenate multi-line selections, which isn’t the case here.
What you first need is extract the 2 fileds OMBU and OrderNumber.
Then you add a new field with a Javascript expression for the concatenation:
record.fields.New_Field = record.fields.OMBU + record.fields.OrderNumber;