Export to Excel and keep Caspio carriage returns?

[roattw]

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!

[Kronos]

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.

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?

[Anan24]

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.