Page 1 of 1
Text file import: spaces converted to underscores
Posted: Fri Jan 31, 2014 7:07 pm
by Frank Ralf
I'm importing a text file with the field names in the first line. The field separator is the pipe but there are a lot of meaningless spaces around the header names for padding. These spaces are converted to underscores during import.
Is there a way to prevent these underscores?
TIA
Frank
Re: Text file import: spaces converted to underscores
Posted: Tue Feb 04, 2014 2:01 pm
by adrian
Hi,
When importing structured text to XML, the header names are by default converted to element names and these cannot contain spaces, so the spaces are automatically converted to underscores.
If you want to alter the element names, press the Customize button from the Import dialog and edit (double click) the XML names directly in the table from the Presentation Names dialog.
Regards,
Adrian
Re: Text file import: spaces converted to underscores
Posted: Tue Feb 04, 2014 6:23 pm
by Frank Ralf
Thanks for the quick reply!