MySQL Forums
Forum List  »  MySQL for Excel

Import with Carriage Return
Posted by: Jason Williams
Date: June 23, 2020 09:01AM

Hello,

I am trying to import a CSV file that is being built with MS Excel. One of the cells requires a Carriage Return without the Line Break in order for the information to be displayed correctly on the website. However I am trying to avoid going to each line and manually entering Shift+Enter.

What I am doing is transferring information from a PDF to the spreadsheet and then merging columns with the CONCATENATE feature, saving the file as a CSV then dropping the columns that are no longer needed. How can I add the Carriage Return to the CONCATENATE formula? I have tried all kinds of things such as \r, '\r', "\r", `\r`, char(13). None of these work.

Thanks in advance for any suggestions!

Options: ReplyQuote


Subject
Views
Written By
Posted
Import with Carriage Return
180
June 23, 2020 09:01AM


Sorry, you do not have permission to post/reply in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.