Retain Excel line breaks through datashuttle
i do some data wrangling in Access and export the result into Excel. I then use a data shuttle to get the data into a smartsheet.
How do I have to format the Excel cells so that they retain the line break through the data shuttle? I don't care how the Excel looks, but i want line breaks in the smartsheet output
Answers
-
When you say "line breaks" are you referring to text wrapping within a single cell?
-
No. I don't mean wrap cells. i know how to do that.
Sometimes, you want a line break, i.e., force the text to start in a new line. This is useful if you want to add a list, which is often necessary since Smartsheet can't handle one-to-many relationships.
See this: In Excel, i can format a cell to look like this:
a. One Item
b. Another Item
c. yet Another Item
You do this by programing the text as "a. One item " & char (13) & "b. Another Item" & char(13) and so on. You can also use vbCtrLf for char(13).
When I pull this into a smartsheet using data shuttle, it will look like
a. One Itemb. Another Itemc. yet Another Item.
So, what I am asking is, what is the equivalent formatting character I have to add in a string for Smartsheet to achieve that.
I find it a little strange that Datashuttle can't handle such simple things and that I have to prepare my data wrangling such as if subsequent shuttling into smartsheet is the only thing I might want to do with the Excel.
-
CHAR(10) is the line break in Smartsheet.
-
Thanks, Paul. I tried the string below, but it doesn't work. As you see, the line doesn't break after "me". Am I doing something wrong?
-
Once you have the line break in, you need to enable text wrapping.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives