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

2 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

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