Modified:

You are to loop through this string below with headers and rows to create a valid Json string.

"Country\tState\tTown\r\nNigeria\tLagos State\tLagos\r\nUSA\tTexas\tDallas\r\n";


Which should produce the Json result below:

[{
"Country": "Nigeria",
"State": "Lagos State",
"Town": "Lagos"
}, {
"Country": "USA",
"State": "Texas",
"Town": "Dallas"
}]

You can validate your Json result here: http://jsonlint.com

Disclaimer: Please only attempt this challenge if you know your are a dangerous programmer.

You didn't even specify the .json file or the url .

proxy20:
You didn't even specify the .json file or the url . Are we json file generators .

put the json file or url here
www.json2csharp.com it will generate the class
open visual studio click on console project . In the main.cs put the json class generated . After that click

Edit >>Paste Json . click build

Sorry you miss understood me, the string would need to be converted to Json first before being converted to an object without listing the object properties.

Where is the data that you want to store or are you creating an empty string with no data only general variables like age , town . undefined strings.

proxy20:
Where is the data that you want to store or are you creating an empty string with no data only general variables like age , town . undefined strings.

The string is in a tab format "\t" copied from a table with columns and rows into a html textbox and it will give you the string I posted above. You will need to loop through this string using the split method.

ok

proxy20:
Alright . You don't need Json , convert the excel style sheet to sql .
https://www.youtube.com/watch?v=MTX6kfPmACM

This challenge will allow a string with "\t" to be converted to Json.

360 degrees k leg

dhtml18:
This kind of challenge get K-leg.

lol

@dhtml18 and proxy20

This challenge has now been modified.
Now it's just a simple loop through the string below:

"Country\tState\tTown\r\nNigeria\tLagos State\tLagos\r\nUSA\tTexas\tDallas\r\n";


Which should produce the Json result below:

[{
"Country": "Nigeria",
"State": "Lagos State",
"Town": "Lagos"
}, {
"Country": "USA",
"State": "Texas",
"Town": "Dallas"
}]

You can validate your Json result here: http://jsonlint.com

public static String solution(String s){


		//get table rows;
		String[] rows = s.split("\r\n" ) ;

		//header rows are at index 0 
		String header = rows[0];
		//break header into columns
		String[] header_rows = header.split("\t" ) ;

	
		//append each subsequent word to its corresponding header
		//note that we start at 1
		StringBuilder builder = new StringBuilder() ;

		//just making the json valid
		builder.append("{" ) ;
		int counter = 1;
		for(int i = 1; i < rows.length; i++){

			//get this particular row
 			String[] thisRow = rows[i].split("\t" ) ;

 			//we add a counter to produce valid json
 			builder.append("\""+(counter++)+"\": {" ) ;
 			for(int j  = 0; j < header_rows.length; j++){

 			//where the job is done
 			builder.append(	"\""+header_rows[j] + "\" : \"" + thisRow[j]+"\"" ) ; 
 			
 			//if this is not the last item in this row, add a comma
 			if(header_rows.length-1>j){
 				builder.append(", " ) ;
 			}
 		}
 			
 			builder.append("}" ) ;

 			//if this is not the last json bracket in this string, add comma
 			if(rows.length-1>i){
 			builder.append("," ) ;
 			}


		}

		builder.append("}" ) ;

		return builder.toString() ;
 
	}

this will produce:

{
"1": {
"Country": "Nigeria",
"State": "Lagos State",
"Town": "Lagos"
},
"2": {
"Country": "USA",
"State": "Texas",
"Town": "Dallas"
}
}

larisoft:

this will produce:

{
"1": {
"Country": "Nigeria",
"State": "Lagos State",
"Town": "Lagos"
},
"2": {
"Country": "USA",
"State": "Texas",
"Town": "Dallas"
}
}

Well done mate. Though I was expecting it in the format below, but with your code I'm sure you can do that easily.
[{
"Country": "Nigeria",
"State": "Lagos State",
"Town": "Lagos"
}, {
"Country": "USA",
"State": "Texas",
"Town": "Dallas"
}]

var parse_json = function(raw_string){
var
string_array = raw_string.split("\r\n\r\n",
json_keys = string_array[0].split("\t",
json_values_array = string_array[1].split("\r\n",
formatted_string = '',
final_string = '[',
i,
j;
for( i = 0; i < json_values_array.length; i++ ){
var json_values_array_items = json_values_array[i].split("\t";
for( j = 0; j < json_values_array_items.length; j++){
formatted_string +=
"{\""+json_keys[j]+":\""+json_values_array_items[j]+"\"}";
if( (j + 1 ) < (json_values_array_items.length ) ) {
formatted_string += ",";
}
}
final_string += formatted_string;
if( (i + 1) < json_values_array.length )
final_string += ",";

//console.log(final_string);
formatted_string = '';
}
final_string+= ']';
return final_string;
};

@ cyrielo, please post the result you got.

Febup:
@ cyrielo, please post the result you got.

console.log( parse_json("Country\tState\tTown\r\n\r\nNigeria\tLagos State\tLagos\r\nUSA\tTexas\tDallas\r\n" );

//[{"Country:"Nigeria"},{"State:"Lagos State"},{"Town:"Lagos"},{"Country:"USA"},{"State:"Texas"},{"Town:"Dallas"},{"Country:""}]

Modified

var parse_json = function( raw_string ){
var
string_array = raw_string.split( "\r\n\r\n" ),
json_keys = string_array[0].split( "\t" ),
json_values_array = string_array[1].split( "\r\n" ),
formatted_string = '',
final_string = '[',
i,
j;
for( i = 0; i < json_values_array.length; i++ ){
var json_values_array_items = json_values_array[i].split( "\t" );
for( j = 0; j < json_values_array_items.length; j++){
formatted_string +=
"{\""+json_keys[j]+":\""+json_values_array_items[j]+"\"}";
if( (j + 1 ) < (json_values_array_items.length ) ) {
formatted_string += ",";
}
}
final_string += formatted_string;
if( (i + 1) < json_values_array.length )
final_string += "],[";

//console.log(final_string);
formatted_string = '';
}
final_string+= ']';
return final_string;
};
console.log( parse_json( " Country\tState\tTown\r\n\r\nNigeria\tLagos State\tLagos\r\nUSA\tTexas\tDallas\r\n " ) );
//[{"Country:"Nigeria"},{"State:"Lagos State"},{"Town:"Lagos"}],[{"Country:"USA"},{"State:"Texas"},{"Town:"Dallas"}],[{"Country:""}]

cyrielo:

console.log( parse_json("Country\tState\tTown\r\n\r\nNigeria\tLagos State\tLagos\r\nUSA\tTexas\tDallas\r\n" );

//[{"Country:"Nigeria"},{"State:"Lagos State"},{"Town:"Lagos"},{"Country:"USA"},{"State:"Texas"},{"Town:"Dallas"},{"Country:""}]

Try to validate your Json string at this link: http://jsonlint.com

it gives the error below:

Error:
[{ "Country:" Nigeria "},{" State
--------------^
Expecting 'EOF', '}', ':', ',', ']', got 'undefined'

Febup:


Well done mate. Though I was expecting it in the format below, but with your code I'm sure you can do that easily.
[{
"Country": "Nigeria",
"State": "Lagos State",
"Town": "Lagos"
}, {
"Country": "USA",
"State": "Texas",
"Town": "Dallas"
}]

well I aim to please:
public static String solution(String s){


//get table rows;
String[] rows = s.split("\r\n " ) ;

//header rows are at index 0
String header = rows[0];
//break header into columns
String[] header_rows = header.split("\t " ) ;


//append each subsequent word to its corresponding header
//note that we start at 1
StringBuilder builder = new StringBuilder( ) ;

//just making the json valid
builder.append("[ " ) ;
int counter = 1;
for(int i = 1; i < rows.length; i++){

//get this particular row
String[] thisRow = rows[i].split("\t" ) ;

builder.append(" { " );
for(int j = 0; j < header_rows.length; j++){

//where the job is done
builder.append( "\""+header_rows[j] + "\" : \"" + thisRow[j]+"\"" ) ;

//if this is not the last item in this row, add a comma
if(header_rows.length-1>j){
builder.append(", " ) ;
}
}

builder.append("}" ) ;

//if this is not the last json bracket in this string, add comma
if(rows.length-1>i){
builder.append("," );
}


}

builder.append("]" );

return builder.toString();

}

that will produce :

[{
"Country": "Nigeria",
"State": "Lagos State",
"Town": "Lagos"
}, {
"Country": "USA",
"State": "Texas",
"Town": "Dallas"
}]

@larisoft you are the first winner. Hope other gurus will come out of hibernation to have ago too

I dont even know what the thread is about, too advanced coding, trolls to next thread ------->

dhtml18:
I dont even know what the thread is about, too advanced coding, trolls to next thread ------->

Come back here mate. There is no where for you to hide. After Sql, XLM, now Json is the next big thing for data storage and for data exchange as it is light weight on like the others, this is why it is popular with WebAPI. So now is the time for you to get your hands dirty with Json.

^^^
So?

FrankLampard:
^^^

So?

So drop your code.

Oh didn't check he json validation thing
**Modified Code
This one passes the validation at least
Note: I made some modification to your string format.
Notice the double carriage return to separate keys from actual values and i removed the new line at the of the string it causes a new row.

var parse_json = function( raw_string ){
var
string_array = raw_string.split( "\r\n\r\n" ),
json_keys = string_array[0].split( "\t" ),
json_values_array = string_array[1].split( "\r\n" ),
formatted_string = '',
final_string = '[',
i,
j;

for( i = 0; i < json_values_array.length; i++ ){
var json_values_array_items = json_values_array[i].split( "\t" );
formatted_string += "{";
for( j = 0; j < json_values_array_items.length; j++){
formatted_string += "\""+ json_keys[j]+ "\":\"" +
json_values_array_items[j] +"\"";
if( (j + 1 ) < (json_values_array_items.length ) ) {
formatted_string += ",";
}
}
formatted_string += "}";
final_string += formatted_string;
if( (i + 1) < json_values_array.length )
final_string += ",";
formatted_string = '';
}
final_string+= ']';
return final_string;
};
var parsed_string = parse_json( "Country\tState\tTown\r\n\r\nNigeria\tLagos State\tLagos\r\nUSA\tTexas\tDallas" );
console.log( (parsed_string) );

//[{"Country":"Nigeria","State":"Lagos State","Town":"Lagos"},{"Country":"USA","State":"Texas","Town":"Dallas"}]

cyrielo:
Oh didn't check he json validation thing
**Modified Code
Note: I made some modification to your string format.
Notice the double carriage return to separate keys from actual values and i removed the new line at the of the string it causes a new row.

Nice try but you cannot modify the string, the string has to remain the same for this challenge.

Febup:


Nice try but you cannot modify the string, the string has to remain the same for this challenge.

I hope nobody will dry from trying this challenge!

dhtml18:

I hope nobody will dry from trying this challenge!

I hope it won't get to that, think I should put a disclaimer at the top

//scala script for json serialization


val inputString = "Country\tState\tTown\r\nNigeria\tLagos State\tLagos\r\nUSA\tTexas\tDallas\r\n"
val lineArray = inputString.split("\r\n"
val rows = lineArray.tail

val placeRegex = """(.+)\t(.+)\t(.+)""".r

//print the json
print("["
for(row <- rows){
	row match {
		case placeRegex(country, state, town) => 
			printf("""{"Country":"%s",%n"State":"%s",%n"Town":"%s"%n} """,country,state,town)
		case _ => println("Unknown"
	}
	if( row != rows.last) print(", "
};
println("]"

my output:

[{"Country":"Nigeria",
"State":"Lagos State",
"Town":"Lagos"
} , {"Country":"USA",
"State":"Texas",
"Town":"Dallas"
} ]

@nnasino

You are the second winner, well done bro.

dhtml18:

I hope nobody will dry from trying this challenge!

Typo, i meant actually die in real life by trying to complete this code. Me, just looking at it, am sweating already and getting high-blood pressure.
Lawd have mercy, see this nnasino codes as e long like Lagos - Ibadan expressway.