I am running queries against a field in a database that is fixed width 4 characters and null padded.
If I run the following query:=NL("Rows","AIRCRAFT","Aircraft ID")
I get the following as results: (These are the actual values in the cell)
- ="06KM"
'="08C
="08SG"
'="0JJ
Whenever the value in the database is NullCharCharChar, it is returned with the odd formatting of '="CharCharChar
If the value in the database uses the full 4 characters, it is returned as ="CharCharCharChar" which displays properly within the cell.
If instead of the above code, I use:
=NL("Rows","AIRCRAFT",{"Aircraft ID","Tail Number"},"DataSource=","FOS")and
=NF($D5,"Aircraft ID")Then all results appear correctly, with the 3 character results only showing the three characters with no additional single quotes, equal signs or double quotes. The NL function needs to pull the second value in order to get it to display correctly.
Is there any known way of causing the original code to return just the values within the database, and not the additional punctuation marks? I am informing my client of the work around of querying two values and only using the one but he, and I, would like to know why this occurs.