Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
300
NewLine in cells of imported file
posted

Good day.

I have a XLS file witch I want to import to SQL Server table and show it on UltraGrid.

Some cells have a Wrap Text (Alt+Enter). 

Can I replace the Alt+Enter sequence in CSV file for some text, so then the UltraGridCell displayed with a line break?

P.S. Sorry for my English, it's not my native language.

Parents
No Data
Reply
  • 300
    Verified Answer
    posted

    Problem solved.

    In csv I replaced Alt+Enter to \n, import records to SQL Table and then run small script

    UPDATE mainTable

    SET field=REPLACE(field, '\n', CHAR(13) + CHAR(10))

    After that UltraGrid show my records with Wrap text.

Children
No Data