Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a problem importing a text file with Swedish characters.
Because of these characters in the "Prg Mgr" column I get a space shift in the following columns.
How can I resolve this?
Best regards,
Jonas
Accepted Solutions
Hello Jonas,
This is unusual, none of the alternative code pages I tested seemed to fix the "spillover" of these extended characters into the next column. In a sense, if you embedded the characters with a deliberate methodology, you could create a text based hierarchy off of how many of these characters you inserted = equated to how many indentations you wanted to mark the hierarchy node depth.
But anyway... to address the main point of the thread. Though I didn't incorporate using the Fix Import Wizard into the solution, there does seem to be a workaround.
Importing the entire row as a single field @1:n and then "chopping" it up in later statements into the appropriate sub-lengths allowed me to "replicate" the behavior of the 'Fix Import Wizard' field partitioning.
Hello Jonas,
This is unusual, none of the alternative code pages I tested seemed to fix the "spillover" of these extended characters into the next column. In a sense, if you embedded the characters with a deliberate methodology, you could create a text based hierarchy off of how many of these characters you inserted = equated to how many indentations you wanted to mark the hierarchy node depth.
But anyway... to address the main point of the thread. Though I didn't incorporate using the Fix Import Wizard into the solution, there does seem to be a workaround.
Importing the entire row as a single field @1:n and then "chopping" it up in later statements into the appropriate sub-lengths allowed me to "replicate" the behavior of the 'Fix Import Wizard' field partitioning.