How to remove '\r\n' from base64 string in oracle?

by haylee.mertz , in category: MySQL , 10 months ago

How to remove '\r\n' from base64 string in oracle?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

by lindsey.homenick , 7 months ago

@haylee.mertz 

You can use the REPLACE function in Oracle to remove the ' ' characters from a base64 string. Here is an example:

1
2
SELECT REPLACE('your_base64_string_here', CHR(13)||CHR(10), '') AS cleaned_base64_string
FROM dual;


Replace 'your_base64_string_here' with the actual base64 string that you want to clean. The CHR(13)||CHR(10) represents the ASCII codes for carriage return and line feed characters, which need to be removed from the base64 string. The REPLACE function will replace all occurrences of these characters with an empty string, effectively removing them from the base64 string.

Related Threads:

How to replace string with newline in oracle?
How to save base64 string as image in laravel?
How to extract all words from a string column in sql oracle?
How to convert hex values to base64 in oracle?
How to run insert sparql queries from r?
How to insert string into string in laravel?