Uploading data with Data Shuttle, with spaces between numbers.

Mitch Cohen
✭✭✭✭
When I upload a numerical string, which has a space before the last 2 digits, the space is removed. How do I upload the numerical string and maintain the space before the last 2 digits? Example, I need the string to import as "123 45", but after the import it appears as "12345".
Best Answer
-
In your data shuttle workflow mapping, click the three bars and change the column type to Text
Answers
-
Try adding an 'Expression', the last step before you name the workflow. This would be a formula you write to add the space back in.
-
In your data shuttle workflow mapping, click the three bars and change the column type to Text
-
@Paul H Changing the column type to "Text" was the solution.....thanks Paul !!!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 75 Community Job Board
- 502 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives