Select code list standard rule on a field in the ISA is not finding a match when the values does exist in the table. (SCI51164)

Select code list standard rule on?a field in the?ISA?is not finding a match when the values does exist in the table.

Before the code list look up is performed the translator does not remove the trailing spaces from the field value.

There are two options available to allow the translator to properly retrieve the code list data.

Option 1:
In the Code List the?value will have to account for the entire length of data in the ISA element being used.?e.g. If the data in the code list is for the?ISA 06 then the code value would have to be 15 characters long including trailing spaces.

If the ISA06 value is "PETTEST??????? " then value?entered in the?code list?should be "PETTEST??????? ".

Option 2:
An extended rule can be added to the map to remove the trailing spaces from the value and?store the value into a temporary field at the bottom of the ISA segment in the map.? The standard rule can be placed on the temporary field allowing the lookup to be done without the spaces.

Example Rule
Integer sp;
sp = 0;

sp = strstr(#ISA06" "); //Search for the first space in the ISA06 value
if sp != -1 then
?? #Tmp_ISA06 = left(#ISA06sp);
else
?? #Tmp_ISA06 = #ISA06;