How do I get Data Shuttle to pull information exactly as it's listed in the source file?

hwilcoxson

I have a column in my source file that includes alphanumeric characters - some characters include an E, which is being translated as an Exponent of 10. Example: 311E9 is being changed to 311000000000. I want the smartsheet to pull the number exactly as it's listed in the source file. Any suggestions? Thank you!

Michael Culley

This is a good question and I'm curious of the answer. Not the best option but what happens if you change the column type to "text" on excel before you use data shuttle?

hwilcoxson

I updated the number format to text in the source file, but unfortunately that didn't work. Great idea, though!

Michael Culley

Well this may be a silly workaround but perhaps the best way is to highlight the whole column in Excel, do control + F, then replace the E with an X.

Then once it uploads to the smartsheet, you can repeat that and convert the X back to an E.

Or you can have a formula column on your smartsheet that automatically converts that column back:

=REPLACE([column]@row, FIND("X", [column]@row), 1, "E")

I use formula columns alot with data shuttle because I often don't get the results I'm looking for. But it still makes life easier having that feature in my opinion.