ASP.NET

uglyeyes wrote:

I have like 1000 rows returning from database is string.split and looping to get the 7 words appropriate way to go?

uglyeyes wrote:

could you pleae help?

CREATE FUNCTION SplitString 
(
    -- Add the parameters for the function here
    @myString varchar(500),
    @deliminator varchar(10)
)
RETURNS 
@ReturnTable TABLE 
(
    -- Add the column definitions for the TABLE variable here
    [id] [int] IDENTITY(1,1) NOT NULL,
    [part] [varchar](50) NULL
)
AS
BEGIN
        Declare @iSpaces int
        Declare @part varchar(50)

        --initialize spaces
        Select @iSpaces = charindex(@deliminator,@myString,0)
        While @iSpaces > 0

        Begin
            Select @part = substring(@myString,0,charindex(@deliminator,@myString,0))

            Insert Into @ReturnTable(part)
            Select @part

    Select @myString = substring(@mystring,charindex(@deliminator,@myString,0)+ len(@deliminator),len(@myString) - charindex(' ',@myString,0))


            Select @iSpaces = charindex(@deliminator,@myString,0)
        end

        If len(@myString) > 0
            Insert Into @ReturnTable
            Select @myString

    RETURN 
END
GO

Select * From SplitString('Hello John Smith',' ')

uglyeyes wrote:

hello either in sql or c# a code hint will be really helpful. I prefer in sql thou.

public string getAdBrief(string text)
       {
           string s = "";
           string[] words = text.Split(' ');
           for (int i = 0; i < 7; i++)
           {
               s +=words[i] + ' ';
           }
           return s;
       }

public static string GetFirstFewWords(string input, int numberWords)
       {
           if (input.Split(new char[] { ' ' },
                 StringSplitOptions.RemoveEmptyEntries).Length > numberWords)
           {
               // Number of words we still want to display.
               int words = numberWords;
               // Loop through entire summary.
               for (int i = 0; i < input.Length; i++)
               {
                   // Increment words on a space.
                   if (input[i] == ' ')
                   {
                       words--;
                   }
                   // If we have no more words to display, return the substring.
                   if (words == 0)
                   {
                       return input.Substring(0, i);
                   }
               }
               return string.Empty;
           }
           else
           {
               return input;
           }
       }

lrsoft2009 wrote:

Why is no one to help me, because I was in China do? Or do not think my English is wrong about this?