- 1. Trim in T-SQL and SSIS
- / SQL Server Integration Services /
- ... "" ), "\x000D", "" ) ) ) -- \x0009 = Tab -- \x000A = Line Feed -- \x000D = Carriage Return -- or split for clarity TRIM( LOWER( REPLACE( REPLACE( REPLACE( myString, "\x0009", ...
- Created on 14 May 2013
- 2. Prefix Line Numbers in a Text File
- / MS-DOS /
- ... file) original_file.txt is your original file (obviously change the name to your file) temp.txt is just a dummy file which should be empty for clarity results_file.txt is the resulting file, it ...
- Created on 18 July 2012