Assuming split is required, the following 24 results were found.
first column of the data range and NOT the first column of the data sheet (eg. F1 = B11) !!! Additional We add a conditional split task to the data flow which only passes through rows from the Excel sheet which are not blank/null. Browsing the net, I...
all was good using Chrome and tolerable using MS Internet Explorer. If we maximized the Google Chrome browser, the row would split and there would be 2 boxes on the top row and the third would pop under these. As for MSIE, that was ok when maximized....
If you allow percents (%) or apostrophes (*) then you are asking for trouble. Note my redirect for errors. Split the first string "myFolder" with the slash (/) as a delimiter, controlling the syntax/format of your site URLs. For Example...
"\x0009", "" ), "\x000A", "" ), "\x000D", "" ) ) ) -- \x0009 = Tab -- \x000A = Line Feed -- \x000D = Carriage Return -- or split for clarity TRIM( LOWER( REPLACE( REPLACE( REPLACE( myString, "\x0009", "" ), "\x000A", "" ), "\x000D", "" ) ) ) Using it to...