Does anyone happen to know the SQL code needed in LO Embedded Base to convert some specific text expression back to line feeds and or carriage returns?
I have data in a csv file that contains a large text field with carriage returns an/or line feeds. I can easy convert the carriage returns/line feeds to “some unique text expression” such as “XYZ123”. That way, the line feeds are removed and the field exports as one long line.
Importing to base is easy but I would then like to reconvert the ““XYZ123” expressions, or some other expressions if suggested, back to carriage returns.
Hope this makes sense. BTW I have tried multiple different SQL code samples using CHAR(10), CHAR(13), /r /n etc without luck. All help is appreciated! Thanks!!