Problem in using Split() with memo field type as the string

[frankyh]

I use the split method in C# to break the text when there is a string "<br>". The text comes from database access, the field type is a Memo type instead of Text type. The result that I got is incorrect

(my code example)
string textFromDataBase = "Welcome to ABC corporation in California<br>"
string[] rows = textFromDataBase.Split("<br>".ToCharArray());


However, when I change the database field from Memo to Text type, I get the correct result using the same split method. I am very confuse. FYI, Using the debugger, I see the same string value. I do not know how to solve this issue. At this time, I can not change the DB field from Memo to Text type since I need to store a very long string, more than 255 chars. Please Help me!

Greatly Appreciated for any feedbacks! I am very lost on this one.

Thanks a bunch,
Franky

[Norfy]

"Split" does not split strings that have "multiple character delimiters" ie. It assumes that each field in the string is delimited by a single character. The character array simply means that the delimiter can vary in the string.

// Split the string into four words.
string[] words = "This.is;a'test".Split(".;'".ToCharArray());

So, using "<br>" with "Welcome to ABC corporation in California<br>" will result in "r" in particular being used to split it up.

[DecksTerrorT]

Try this little function.

		
		public string[] Split(string Value,string SplitBy)
		{
			ArrayList al = new ArrayList();
			
			string sLine = "";
			
			int i = Value.IndexOf(SplitBy,0);
			string sStrLeft = Value;

			while (i  > -1)
			{
				sLine = sStrLeft.Substring(0,i);
				sStrLeft = sStrLeft.Substring(i + SplitBy.Length);

				al.Add(sLine);	

				i = sStrLeft.IndexOf(SplitBy,0);
			}  

			al.Add(sStrLeft);

			return (string[])al.ToArray(typeof(string));
		}