Behaviour of \n(new line ) character geting from database

Question

I am facing some weird issue.I am fetching a email template from database "Hi \n How are you? \n story continues". I am assigning this to string in my java application and sending email. The final output should be

Hi
How are you?
story continues

But my result is like this

Hi \n How are you? \n story continue

Instead of getting from db, if I hard code in the string I am getting in right way.

What might be causing \n to be ineffective?

Is there a way can I make \n effective in java layer?

How is the `\n` getting there? You should use actual newline characters. — SLaks, Jul 19 '13 at 15:57

score 2 · Answer 1 · answered Jul 19 '13 at 16:14

2

Try this

    String str = //value read from DB
    str = str.replaceAll("\\\\n", "\n");

answered Jul 19 '13 at 16:14

Mangoose

922
1
9
17

score 0 · Answer 2 · answered Jul 19 '13 at 16:02

0

You have to use StringEscapeUtils. The method that you need is unescapeJava().

It is inside Apache Commons Lang.

answered Jul 19 '13 at 16:02

Vitaly Olegovitch

3,509
6
33
49

Behaviour of \n(new line ) character geting from database

2 Answers2