Problem in tab delemiting

Hi All, Please find below the sample data which we are receiving from the source.

40        653844            "End Mill Sets; Roughing (Yes/No): No; End Type: Square End;         EA                    0            CUTL    CUTTING TOOLS         END MILL        7016    SGS TOOL        30389  5          20151215                                                        1.000   1.000   N          00653844        99.7500           USD     C          "End Mill Sets; Roughing (Yes/No): No; End Type: Square End; 100833            

We have a SSIS package, where it will post all the text into database table. There is no problem in posting the data into database tables. Problem is when converting the source text into Excel sheet. Because business user needs the source text in excel format to validate the data posted in database. 

Expected result is something like 40(1st column) then 6543844(2nd column)  then "End Mill Sets; Roughing (Yes/No): No; End Type: Square End;(3rd column) then EA (4th column) then 0(5th column)  and it continues...

But excel is considering the below mentioned text as single text. After 6543844(2nd column), all the below mentioned text is coming in 3rdcolumn, then directly 100833(4th column)

End Mill Sets; Roughing (Yes/No): No; End Type: Square End; EA 0 CUTL CUTTING TOOLS END MILL 7016 SGS TOOL 30389 5 20151215 1.000 1.000 N 00653844 99.7500 USD C End Mill Sets; Roughing (Yes/No): No; End Type: Square End;

Could you please someone mention what I am doing wrong? Or is there any problem with source data format? My big confusion is data is getting posted in database table as expected. Problem in only during the text file to excel conversion.

August 13th, 2015 6:31am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics