Loading data from MySQL: Replace CR/LF?

HomeForum

Welcome, Guest

(1 viewing) (1) Guest

Reply Topic

TOPIC: Loading data from MySQL: Replace CR/LF?

baba OFFLINE Fresh Boarder Posts: 4 Karma: 0	Hello, I have a transformation that is pulling from a MS SQL view; and one of the fields is pulling over cr/lf's that are not being removed via the 'replace characters' function any ideas as how to best remove them? thanks! B
	Reply Quote

admin OFFLINE Moderator Posts: 2182 Karma: 12	Use script transformation instead begin result:=Replace(Replace([F001],(Char(12)),''),Char(13)); end; Peter
	Reply Quote