Jump to content
  • 0

Export to Excel and keep Caspio carriage returns?


roattw

Question

I suspect that this cant be done but just checking, since I presume Excel can only import basic string/delimited data.  I have a calculated field in Casio that uses CHAR13 to make a mailing address using name+address+city+state+zipcode and putting it in the calculated field with hard returns:

'[@field:First_Name]'+' '+'[@field:Last_Name]'+', MD'+CHAR(13)+'[@field:Address]'+CHAR(13)+
'[@field:City]'+', '+'[@field:State]'+' '+'[@field:Zipcode]'

Name
Address
City, State Zipcode

But when exported that field just comes across as a run-on address, where it honors the "spaces" but not hard returns:

Bob Smith1313Lawyer RoadCincinnati, OH 45223

Limited by how Excel imports data?

 

Thx!

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 1

Hi @roattw,

I just tried the formula you have in your post. And it worked as expected, I suggest to enable editing on your excel file then double click on the cell with the Formula to resize the cell.

image.png.44f4872105946d206b628de1c8c86f58.png

I'm not really sure if that is what you meant on your question in the thread. 

If it's not, can you explain your question more?

Link to comment
Share on other sites

  • 0
On 11/30/2022 at 9:59 PM, roattw said:

I suspect that this cant be done but just checking, since I presume Excel can only import basic string/delimited data.  I have a calculated field in Casio that uses CHAR13 to make a mailing address using name+address+city+state+zipcode and putting it in the calculated field with hard returns:

'[@field:First_Name]'+' '+'[@field:Last_Name]'+', MD'+CHAR(13)+'[@field:Address]'+CHAR(13)+
'[@field:City]'+', '+'[@field:State]'+' '+'[@field:Zipcode]'

Name
Address
City, State Zipcode

But when exported that field just comes across as a run-on address, where it honors the "spaces" but not hard returns:

Bob Smith1313Lawyer RoadCincinnati, OH 45223

Limited by how Excel imports data?

 

Thx!

Excel can handle line breaks within cells if the data is exported correctly. However, issues may arise when the data is treated as plain text when exported. To preserve line breaks, export the data with proper line breaks, such as enclosed in double quotes for CSV format. Import the data into Excel using the Text Import Wizard, choosing Delimited, Comma, and General or Text as appropriate. If importing via the "Data" tab, click From Text/CSV and select the CSV file. Alternatively, use Excel Formulas to combine fields with line breaks, ensuring the cell has "Wrap Text" enabled. By following these steps, Excel should correctly interpret and display line breaks in addresses.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...