Converting Multiple-line of text to single line of text.
in [Windows Services]
|
Prev: advise on removing WMSDE and using sql2005
Next: Microsoft Responds to the Evolution of Online Communities
From: Robert on 2 May 2010 23:38 Is there a way in SP 2003 to convert a multiple-line of text into single-line of text? Claudio Brotto [MVP] wrote: Zaur,a Note field (i.e. 14-Jan-09 Zaur, a Note field (i.e. a multiple lines of text field) can keep more than the 255 chars limit that applies to Text field (i.e. single line of text). So please ensure the amount of data you are storing in your items :-) HTH Ciao -- Claudio Brotto MVP Windows SharePoint Services Microsoft Certified Trainer https://mvp.support.microsoft.com/profile/Claudio.Brotto Read my blog @ http://blogs.devleap.com/devlizard "Zaur Bahramov" <zbakhramov(a)msn.com> wrote in message news:ekT8JxhdJHA.1184(a)TK2MSFTNGP05.phx.gbl... Previous Posts In This Thread: On Wednesday, January 14, 2009 2:47 AM Zaur Bahramov wrote: Convert multiple lines of text column to single line of text clumn Hello! We have a column of type "Multiple lines of text" which can not be sorted. All other columns are sortable, and are of various types (single line of text, choice, date and time). I need to make this column sortable and the only way I suppose is it convert it to "single line of text" column. When I select to change the type, sharepoint gives the message that such conversion may result in loss of data... What actually can be lost and how to check which data can be potentially lost during such conversion? Also, is there another way to enable sorting for "Multiple lines of text column"??? Thank you! Zaur On Wednesday, January 14, 2009 6:17 AM Claudio Brotto [MVP] wrote: Zaur,a Note field (i.e. Zaur, a Note field (i.e. a multiple lines of text field) can keep more than the 255 chars limit that applies to Text field (i.e. single line of text). So please ensure the amount of data you are storing in your items :-) HTH Ciao -- Claudio Brotto MVP Windows SharePoint Services Microsoft Certified Trainer https://mvp.support.microsoft.com/profile/Claudio.Brotto Read my blog @ http://blogs.devleap.com/devlizard "Zaur Bahramov" <zbakhramov(a)msn.com> wrote in message news:ekT8JxhdJHA.1184(a)TK2MSFTNGP05.phx.gbl... On Tuesday, January 20, 2009 3:48 AM kezoesps wrote: Re: Convert multiple lines of text column to single line of text clumn On Jan 14, 7:47=A0am, "Zaur Bahramov" <zbakhra...(a)msn.com> wrote: .. I ion Can you export the column values to a spreadsheet? Create a new column next to the existing one of text field Export the lot to Excel Within excel write a function in the new column that copies the data from the multi line column Compare the results for loss of data Import the lot back in Submitted via EggHeadCafe - Software Developer Portal of Choice WPF GridView Sample To Insert, Update, and Delete Records http://www.eggheadcafe.com/tutorials/aspnet/fc9a5bf6-f5bb-4443-a92a-c9a46fd3aeb2/wpf-gridview-sample-to-in.aspx |