I need to import csv file using xmlport in BC however, when I try to import data, BC automatically removes more than one whitespace in the string.
for example, lets say there is a cell has string "AA 1111", between AA and 1111, it has two white spaces but when I import to the BC, it automatically changes to "AA 1111" which is one white space.
I tested with multiple whitespaces in between the text and only one whitespace is remain after import.
Removing whitespace takes in action before anything I could do to customize it.
Are there ways that I can hard copy whitespaces from the csv file or is it BC default that it removes any additional whitespaces?
