String parsing based on semicolan, dolon and commas

Question

Hi,

I am trying to solve a hacker rank problem below, If someone can help. I would really appreciate it.

Problem: parse the below string based on semicolon, comma, and colon, the output should be an HTML table (Matrix)

String: "5.0,15,4.0,25,3.0,10:L10;5.0,18,4.0,42,3.0,12:L20"

Desired output : <table border="1"><tr><th>Row Label</th><th>L10</th><th>L20</th></tr><tr><td>5.0</td><td>15</td><td>18</td></tr><tr><td>4.0</td><td>25</td><td>42</td></tr><tr><td>3.0</td><td>10</td><td>12</td></tr></table>

Answer 1

public record LData(string L, string[] Value);

public static void Parse1() {     
	string text = "5.0,15,4.0,25,3.0,10:L10;5.0,18,4.0,42,3.0,12:L20";      
	List<LData> datas = new();     
	StringBuilder sb = new();     
	List<string> list = new();     
	bool readL = false;      

	void AddDatas()     
	{         
		readL = false;         
		datas.Add(new(sb.ToString(), list.ToArray()));         
		sb.Clear();         
		list.Clear();     
	}      

	foreach (var item in text)     
	{         
		if (readL)         
		{             
			if (item != ';')                 
				sb.Append(item);             
		else                 
		AddDatas();         
		}         
		else         
		{             
			switch (item)             
			{                 
				case ',':                     
				list.Add(sb.ToString());                     
				sb.Clear();                     
				break;                 
				case ':':                     
					sb.Append(item);                     
					list.Add(sb.ToString());                     
					sb.Clear();                     
					readL = true;                     
					break;                 
				default:                     
				sb.Append(item);                     
				break;             
			}         
		}     
	}      
	AddDatas(); 
}

or

public static void Parse2() {     
	string text = "5.0,15,4.0,25,3.0,10:L10;5.0,18,4.0,42,3.0,12:L20";     
	List<LData> datas2 = new();     
	string[] records = text.Split(';');     
	//5.0,15,4.0,25,3.0,10:L10     
	//5.0,18,4.0,42,3.0,12:L20      

	foreach (var item in records)     
	{         
		var d = item.Split(':');         
		//0 = 5.0,15,4.0,25,3.0,10         
		//1 = L10          

		datas2.Add(new(d[1], d[0].Split(",")));     
	} 
}

Answer 2

you can do the split in one shot:

var text = "5.0,15,4.0,25,3.0,10:L10;5.0,18,4.0,42,3.0,12:L20";
var list = text.Split(new char[] {',',':',';'});

but I don't understand the desired sort order. its not the original sequence, not order by decimal value, just seems random.

Answer 3

namespace hacker_rank
{
	internal class Program
	{

		static void Main(string[] args)
		{
			string inputString = "5.0,15,4.0,25,3.0,10:L10;5.0,18,4.0,42,3.0,12:L20";
			var tokens = inputString.Split(new char[] { ',', ';', ':' });
			
			var outputString = $"<table border='1'><tr><th>Row Label</th><td>{string.Join("</td><td>", tokens)}</td></table>";
		}
	}
}

Value of outputString:

<table border='1'><tr><th>Row Label</th><td>5.0</td><td>15</td><td>4.0</td><td>25</td><td>3.0</td><td>10</td><td>L10</td><td>5.0</td><td>18</td><td>4.0</td><td>42</td><td>3.0</td><td>12</td><td>L20</td></table>

Answer 4

namespace hacker_rank
{
	internal class Program
	{

		static void Main(string[] args)
		{
			string inputString = "5.0,15,4.0,25,3.0,10:L10;5.0,18,4.0,42,3.0,12:L20";
			var tokens = inputString.Split(new char[] { ',', ';', ':' });
			
			var outputString = $"<table border='1'><tr><th>Row Label</th><td>{string.Join("</td><td>", tokens)}</td></table>";
		}
	}
}

Value of outputString:

<table border='1'><tr><th>Row Label</th><td>5.0</td><td>15</td><td>4.0</td><td>25</td><td>3.0</td><td>10</td><td>L10</td><td>5.0</td><td>18</td><td>4.0</td><td>42</td><td>3.0</td><td>12</td><td>L20</td></table>