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
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 303 Events
- 34 Webinars
- 7.3K Forum Archives