xmlmport whitespace issue.

(0) Share

Report

Posted on by jyoon0619

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?

All responses (2)

Answers (1)

jyoon0619 50 on at

Like (0)

Report

RE: xmlmport whitespace issue.

Thank you!!! It worked
Verified answer

Suresh Kulla 47,789 on at

Like (1)

Report

RE: xmlmport whitespace issue.

There is a property on the XmlPort called PreserveWhiteSpace, by default it is false, please try to set it to True.