baanware
26th May 2010, 15:43
Hi,
Is it possible to concatenate two fields from a sales order EDI (input) file into one single concatenated field?
The actual issue is to utilize two different input-fields and merge them into a single field - the Customer Order Reference field (tdsls400.corn). The input fields are positioned as fields 4 and 51 in level 2 of the header import.
If both fields are filled (not empty) a separator character should separate the two input fields in the single target field. In other words if field 4 is "ABC" and field 51 is "DEF" tdsls400.corn should be filled as follows: "ABC/DEF".
Is this possible to obtain this using standard EDI facilities?
Thanks!
Is it possible to concatenate two fields from a sales order EDI (input) file into one single concatenated field?
The actual issue is to utilize two different input-fields and merge them into a single field - the Customer Order Reference field (tdsls400.corn). The input fields are positioned as fields 4 and 51 in level 2 of the header import.
If both fields are filled (not empty) a separator character should separate the two input fields in the single target field. In other words if field 4 is "ABC" and field 51 is "DEF" tdsls400.corn should be filled as follows: "ABC/DEF".
Is this possible to obtain this using standard EDI facilities?
Thanks!