Display Data in Table Format

Sandip Patil

10y1.3k.NET

I have Multiple Strings like

a:1:{s:10:"02-02-2015";a:13:{s:12:"control_room";s:14:"Control Room 1";s:8:"inverter";s:10:"Inverter 1";s:16:"daily_generation";s:4:"5225";s:9:"daily_plf";s:6:"21.77%";s:12:"grid_failure";s:8:"00:10:00";s:17:"force_maintenance";s:1:"0";s:9:"scheduled";s:1:"0";s:11:"unscheduled";s:1:"0";s:16:"generation_hours";s:8:"11:52:00";s:15:"operating_hours";s:8:"11:42:00";s:18:"plant_availability";s:7:"100.00%";s:17:"grid_availability";s:6:"99.00%";s:17:"breakdown_remarks";s:10:"No remarks";}}

Now to I Want to display Data Only Within "" string

Header and Values are in Same String for Ex

"02-02-2015" is a Date, "control_room" is Header and "Control Room 1" is the Values

Now i want to display in table format

Date	Control_room	Inverter	daily_generation	daily_plf
02-02-2015	Control Room 1	Inverter	5225	21.77%
03-02-2015	Control Room 1	Inverter	5225	21.77%
04-02-2015	Control Room 1	Inverter	5225	21.77%

How to Display This

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ranjan Dailata10y ago
Please use lots of solutions out there, you can reuse one and build your own. First you may have to De-Serialize the JSON data so you can get an object to display. This will be your model data. Take a look into this article for grid display http://www.4guysfromrolla.com/articles/121510-1.aspx
0
Sandip Patil10y ago
Actually data is already Stored in mysql Database like.

and i would like to display only 'data' 's values

now the data is like

a:1:{s:10:"02-01-2015";a:13:{s:12:"control_room";s:14:"Control Room 1";s:8:"inverter";s:10:"Inverter 1";s:16:"daily_generation";s:4:"5225";s:9:"daily_plf";s:6:"21.77%";s:12:"grid_failure";s:8:"00:10:00";s:17:"force_maintenance";s:1:"0";s:9:"scheduled";s:1:"0";s:11:"unscheduled";s:1:"0";s:16:"generation_hours";s:8:"11:52:00";s:15:"operating_hours";s:8:"11:42:00";s:18:"plant_availability";s:7:"100.00%";s:17:"grid_availability";s:6:"99.00%";s:17:"breakdown_remarks";s:10:"No remarks";}}

a:1:{s:10:"02-01-2015";a:13:{s:12:"control_room";s:14:"Control Room 1";s:8:"inverter";s:10:"Inverter 1";s:16:"daily_generation";s:4:"5225";s:9:"daily_plf";s:6:"21.77%";s:12:"grid_failure";s:8:"00:10:00";s:17:"force_maintenance";s:1:"0";s:9:"scheduled";s:1:"0";s:11:"unscheduled";s:1:"0";s:16:"generation_hours";s:8:"11:52:00";s:15:"operating_hours";s:8:"11:42:00";s:18:"plant_availability";s:7:"100.00%";s:17:"grid_availability";s:6:"99.00%";s:17:"breakdown_remarks";s:10:"No remarks";}}

a:1:{s:10:"02-01-2015";a:13:{s:12:"control_room";s:14:"Control Room 1";s:8:"inverter";s:10:"Inverter 1";s:16:"daily_generation";s:4:"5225";s:9:"daily_plf";s:6:"21.77%";s:12:"grid_failure";s:8:"00:10:00";s:17:"force_maintenance";s:1:"0";s:9:"scheduled";s:1:"0";s:11:"unscheduled";s:1:"0";s:16:"generation_hours";s:8:"11:52:00";s:15:"operating_hours";s:8:"11:42:00";s:18:"plant_availability";s:7:"100.00%";s:17:"grid_availability";s:6:"99.00%";s:17:"breakdown_remarks";s:10:"No remarks";}}

Now to I Want to display Data Only Within "" string

Header and Values are in Same String for Ex
"02-02-2015" is a Date, "control_room" is Header and "Control Room 1" is the Values

Now i want to display in table format
Date
Control_room
Inverter
daily_generation
daily_plf
02-02-2015
Control Room 1
Inverter
5225
21.77%
03-02-2015
Control Room 1
Inverter
5225
21.77%
04-02-2015
Control Room 1
Inverter
5225
21.77%

How to Display This using mvc razor
0
Manish Kumar10y ago
Hi Sandip,

If your data is in JSON format and you want to display data in tabular form then with the help of powerBI desktop version you can view your data in tabular form.
+1
Ranjan Dailata10y ago
You can use JsGrid to display data as per your requirement. Please refer - http://js-grid.com/demos/
0
Rahul Chavan10y ago
Hi Sandeep,

Your data is not in valid JSON format.
Try any of below solution:
Solution 1:
Get the data in JSON format, you can display it easily.

Solution 2:
If your data will be in fixed format. Then create a function which will take input as string and return you the JSON. Your function will traverse the string and select character starting with :" and till "; and add it to dictionary or JSON and create table based on it.

//Start from->:"
//End -> ";

0
Manish Kumar10y ago
is this format in JSON?
0