Home › Forums › Import Export PowerTool › Import Removes Consecutive Spaces in Text Fields

Tagged: 

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • Frank DiGiambattistaFrank DiGiambattista
      May 2, 2025 at 2:28 pm
      Post count: 3
      #13079

      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!

      Terri Vaive
        May 6, 2025 at 10:45 am
        Post count: 508
        #13097
        Upvote
        Up
        0
        Down
        Not Helpful
        ::

        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,

        Frank DiGiambattistaFrank DiGiambattista
          May 7, 2025 at 12:01 pm
          Post count: 3
          #13101
          Upvote
          Up
          0
          Down
          Not Helpful
          ::

          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.

          Terri Vaive
            May 8, 2025 at 7:09 am
            Post count: 508
            #13102
            Upvote
            Up
            0
            Down
            Not Helpful
            ::

            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 [email protected].

            Thank you,

          • Author
            Posts
          Viewing 4 posts - 1 through 4 (of 4 total)
          • You must be logged in to reply to this topic.