Import with Carriage Return
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!
Subject
Views
Written By
Posted
Import with Carriage Return
643
June 23, 2020 09:01AM
Sorry, you can't reply to this topic. It has been closed.
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.