{"id":469,"date":"2019-11-04T08:22:04","date_gmt":"2019-11-04T08:22:04","guid":{"rendered":"http:\/\/flace.de\/?p=469"},"modified":"2019-11-04T08:22:04","modified_gmt":"2019-11-04T08:22:04","slug":"sql-um-wagenruecklauf-cr-und-zeilenvorschub-lf-zu-entfernen","status":"publish","type":"post","link":"https:\/\/flace.de\/?p=469","title":{"rendered":"SQL um Wagenr\u00fccklauf (CR) und Zeilenvorschub (LF) zu entfernen"},"content":{"rendered":"<div><span>Carriage Return (CR) Wagenr\u00fccklauf bedeutet zur\u00fcckkehren zum Anfang der aktuellen Zeile<br \/>\nCHAR(13)<br \/>\nLine Feed (LF)oder Zeilenvorschub heisst nach unten in die n\u00e4chste Zeile<br \/>\nCHAR(10)<\/span><\/div>\n<div><span>Beides Zusammen ergibt den (CRLF) Wagenr\u00fccklauf Zeilenvorschub<\/span><\/div>\n<div><span>Beispiel:<br \/>\nProjNr,ProjAdr,Replace(Replace(ProjBezeichnung,CHAR(10),&#8216; &#8218;),CHAR(13),&#8216; &#8218;) as ProjBez,AuftragsSumme,P.AbtNr<\/span><\/div>\n<div><span>Entfernt alle Wagenr\u00fcckl\u00e4ufe und Zeilenvorsch\u00fcbe aus einer Zeichenkette<\/span><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Carriage Return (CR) Wagenr\u00fccklauf bedeutet zur\u00fcckkehren zum Anfang der aktuellen Zeile CHAR(13) Line Feed (LF)oder Zeilenvorschub heisst nach unten in die n\u00e4chste Zeile CHAR(10) Beides Zusammen ergibt den (CRLF) Wagenr\u00fccklauf Zeilenvorschub Beispiel: ProjNr,ProjAdr,Replace(Replace(ProjBezeichnung,CHAR(10),&#8216; &#8218;),CHAR(13),&#8216; &#8218;) as ProjBez,AuftragsSumme,P.AbtNr Entfernt alle Wagenr\u00fcckl\u00e4ufe und Zeilenvorsch\u00fcbe aus einer Zeichenkette<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,16],"tags":[106,109,110,107,111,31,108],"class_list":["post-469","post","type-post","status-publish","format-standard","hentry","category-allgemein","category-sql","tag-cr","tag-crlf","tag-entfernen","tag-lf","tag-replace","tag-sql","tag-zeichenkette"],"_links":{"self":[{"href":"https:\/\/flace.de\/index.php?rest_route=\/wp\/v2\/posts\/469","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/flace.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/flace.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/flace.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/flace.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=469"}],"version-history":[{"count":1,"href":"https:\/\/flace.de\/index.php?rest_route=\/wp\/v2\/posts\/469\/revisions"}],"predecessor-version":[{"id":470,"href":"https:\/\/flace.de\/index.php?rest_route=\/wp\/v2\/posts\/469\/revisions\/470"}],"wp:attachment":[{"href":"https:\/\/flace.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=469"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/flace.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=469"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/flace.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=469"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}