BASE - Problem importing carriage returns in csv file

[Justin100]

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

[Justin100]

Perhaps I did not express my question very well but I was able to find the answer needed. For those who may be interested the SQL code in LO Base Embedded to change some arbitrary text (say XYZ) in a field (or column), to a line feed (carriage return), is as follows:

update TABLE set COL = replace(COL, ‘XYZ’, CHAR(13)) ;

For example:
This is a test.XYZThis is a test.

Changes to:

This is a test.

This is a test.

Hope this helps someone else trying to do the same thing I was.