How to remove line feed while selecting the string from sql server?

sql-server,sql-server-2008,linefeed

The syntax of your statment looks wrong, maybe you can try with something like this: Select Replace(Replace(@str,CHAR(10),''),CHAR(13),'') The inner replace relaces LF and the outer replace replace CR...

How to preg_replace from indentifier to end of text with CR(LF) characters

php,preg-replace,carriage-return,linefeed

It is better to use: explode('<--#SPLIT#-->', $text); Example code: $text = 'Foo bar<--#SPLIT#-->Baz fez'; $temp = explode('<--#SPLIT#-->', $text); $upper = $temp[0]; $lower = (count($temp > 1) ? $temp[1] : ''); // $upper == 'Foo bar' // $lower == 'Baz fez' ...

Record Separation in VSQL Export; CR LF

newline,carriage-return,vertica,linefeed,vsql

I tried using \012 (octal for newline) and it equates that with \n so I don't see a way to do it within vsql. You could download a program from Sourceforge called dos2unix.exe and pipe it, something like: vsql -h myserver -U dbadmin -w mypassword -f export.sql | dos2unix.exe >...