I'm importing data from an Excel spreadsheet into Datameer. One of the columns contains part numbers, and since some PN's contain alphas, the field in the file import is defined as a STRING. In Excel, the column is defined as GENERAL (although I've also tried it as TEXT with the same result).
When the import runs, some of the values that are numeric (e.g. part number 12345) have an added decimal after import (e.g. 12345.0). It's not happening consistently, but it is happening frequently for those values.
I hesitate to use SUBSTITUTEALL because I can't rule out the possibility a part may come in with a valid .0 embedded in it. I'd like to eliminate the addition of that decimal.
Anyone else run into something like this?
Please sign in to leave a comment.