且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

从文本文件中读取块并生成数据表

更新时间:2023-02-19 21:32:00

如果要读取文本文件内容并将其转换为DataTable,那么您的文件内容应为xml类型或应为json序列化字符串。首先,将文件内容修改为json或xml格式,然后尝试将其转换为datatable ..为此,您可以使用
 json.pa RSE(YourFileTextString); 


I have a text file whose content is like below


---------------------Start file-----------------------------------------------------------------
[BEGIN STATEMENT BATCH]
A1 data.............................
H1 data.............................
F1 data.............................
D1 data.............................
[BATCH 1]
A1 data.............................
[STATEMENT 1]
H1 data header1, data header2, ...
D1 data value1, data value2, ...
D1 data value1, data value2, ...
D1 data value1, data value2, ...
D1 data value1, data value2, ...
D1 data value1, data value2, ...
F1 data footer1, data footer2, ...
[END OF PAGE]
[STATEMENT 2]
H1 data header1, data header2, ...
D1 data value1, data value2, ...
D1 data value1, data value2, ...
D1 data value1, data value2, ...
D1 data value1, data value2, ...
D1 data value1, data value2, ...
F1 data footer1, data footer2, ...
[END OF PAGE]
[STATEMENT 3]
H1 data header1, data header2, ...
D1 data value1, data value2, ...
D1 data value1, data value2, ...
D1 data value1, data value2, ...
D1 data value1, data value2, ...
D1 data value1, data value2, ...
F1 data footer1, data footer2, ...
[END OF PAGE]

.
.
.
.
.
.
.

[END BATCH]
[END STATEMENT BATCH]
-------------------------End file-----------------------------------------------------------


can you let me know how to get output , a collection of Syste.Data.DataTables like below,

Statement1:
data_header1 data_header2 ....
data_value1 data_value2 ....
.
.
.
data_footer1 data_footer2 .....

Statement2:
data_header1 data_header2 ....
data_value1 data_value2 ....
.
.
.
data_footer1 data_footer2 .....

Statement3:
data_header1 data_header2 ....
data_value1 data_value2 ....
.
.
.
data_footer1 data_footer2 .....

.
.
.
.
.

If you want to read your text file contents and convert it to DataTable, then your file content should be of xml type or should be json serialized string.. First, modify your file contents to json or xml format, and then try converting it to datatable.. For that, you can use
json.parse(YourFileTextString);