[RESOLVED] Account for carriage return

[regamble]

The source data we are querying has been changed to add a carriage return between names. the fields 'team_names' has multiple names previously delimited by a 'space' now are delimited by a carriage return

The current join statement no longer works, and I was hoping for some help.

FROM Table1 left outer join Table2 on Table2.team_names like concat(\"%\",substring(Table1.emp_name, instr(Table1.emp_name, \",\")+2),\" \",left(Table1.emp_name, instr(Table1.emp_name, \",\")-1),\"%\")

Thanks in advance!

[NogDog]

Well, of course the main problem is having a non-normalized DB with mutlitple data items in one field. 😉

But based on the way your question was posed, I expect that is outside of your control. If so, I need some clarification on what it is you need to change at this point. Is there some place in your query that you need to specify the carriage return, or is it on the PHP side of things? Also, do you truly mean "carriage return", or is it really a "newline" character? (Or is it both?) In PHP, you can reference carriage returns as "\r" and newlines as "\n". Note that this is only true within double quotes; they do not have that special meaning within a single quote string literal.

[regamble]

You are correct, unfortunately it is not normalized and it is out of my control.

It is on the PHP side of things. I have been able to replace the carriage return (actually \n as you identified) in the backend query tool, but I still cannot link the two tables as previously.

Thanks for taking the time with this.

[regamble]

I was able to replace the /n with a ' ' and that returned it to the previous value, and then it worked.

Thanks for the help!