So I’ve bumped into an issue I just cant figure out. Been searching the forums and google, but cant find a solution.
I’ve got an excel file with data. One of the columns contain phone number. In excel, it’s written as a string, like this: 4712345678
(47 = countrycode, last 8 digits are number).
When using Excel Reader (XLS) to read the file, it’s correctly identified and formatted as a string under File content tab in the config of the node.
But in the preview tab, it’s converted to Double. No mater what I do. I dont want any fields to change upon import. String should be string.
This in turn makes it somewhat difficult for me to get back my original string of the phone number. All conversions from double back to string gives me results like: 4.712345678E9
I tried using a Round Double node, storing as String, and that turns it back into the right format.
But, I don’t want to find workarounds, I just want the input to be treated as string. It is identified as string, but for some reason it gets converted.
Thanks in advance for any help