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".

Paul H

In your data shuttle workflow mapping, click the three bars and change the column type to Text

Mike TV

@Mitch Cohen

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.

Paul H

In your data shuttle workflow mapping, click the three bars and change the column type to Text

Mitch Cohen

@Paul H Changing the column type to "Text" was the solution.....thanks Paul !!!