Skip to content

Import Export PowerTool

Import Removes Consecutive Spaces in Text Fields

Viewing 4 posts – 1 through 4 (of 4 total)
  • Author
    Posts
  • #8704
    Frank D.

    When importing data to the customer card the tool is removing multiple, consecutive spaces in values targeted to Text fields.  For example, when the source value is “Test      Six Spaces”, the value inserted into the text field is “Test Six Spaces”.  The 6 spaces between the first two words are replaced with one space.

    While I like the fact that this helps us clean bad data, it is making it difficult for us to validate data when we compare source and target values.

    I tested the same import using a Config Package and the extra spaces were not removed.

    Is there a way to keep the extra spaces when importing this data?

    Thank you for your help!

    #10366
    Terri V.
    Insight Works

    Hello Frank,

    The Import Export Power Tool does not account for whitespace out of the box.

    There would need to be additional logic added to register the whitespaces as individual characters.

    Thank you,

    #10367
    Frank D.

    Thanks Terri.

    So, for clarity, the tool will always remove more than one consecutive space between words when uploading data.  Correct?

    I think it is a great tool.  I just want to better understand what to expect.  Do you offer paid options for support or consultation?

     

    Thank you.

    #10368
    Terri V.
    Insight Works

    Hello Frank,

    Yes, the Import Export Power Tool focuses more so on real data during migration and management. Thus, whitespaces not being recognized during your import.

    For support and consultation inquiries please submit your request to su*****@*******ks.com.

    Thank you,

Viewing 4 posts – 1 through 4 (of 4 total)
  • Sign in below to reply.