Level 73
Can you show an example string and the expected result?
Jan 11, 2021
11
Level 2
Replacing /n in query
I have a query that looks like this
$query = DB::select(
"
SELECT
p.id,
p.name,
regexp_replace('/\s\s+/', ' ', p.description) as description,
FROM public.products p
ORDER BY sort ASC
"
)
but when I run it my output has replaced my description with /\s\s+/. What I need is for my query to replace /n with a space
Level 2
yep.
example string
This is an\nexample string
expected result
This is an example string
Level 73
Try this
SELECT
p.id,
p.name,
regexp_replace(p.description, '\\n', ' ') as description,
FROM public.products p
ORDER BY sort ASC
Level 2
I'm still getting the \n
Level 39
SELECT
p.id,
p.name,
REPLACE(description, chr(13), ' ') as description,
FROM public.products p
ORDER BY sort ASC
Level 73
You don't need to use regexp either you can just
SELECT
p.id,
p.name,
replace(p.description, '\n', ' ') as description,
FROM public.products p
ORDER BY sort ASC
Level 2
I'm still getting \n. Do you think that it might be because I'm trying to export it to an excel file? and that is why it isn't working?
Level 73
You need to do \\n and not just \n
Level 39
You are still getting \n with my example?
SELECT
p.id,
p.name,
REPLACE(p.description, chr(13), ' ') as description,
FROM public.products p
ORDER BY sort ASC
It does not depend of your export
Level 2
yes I am
Level 39
Ok , it beacause \n is chr(10) ! -)
SELECT
p.id,
p.name,
REPLACE(p.description, chr(10), ' ') as description,
FROM public.products p
ORDER BY sort ASC
Please or to participate in this conversation.