问题描述
大家好,
我有一个如下的平面文件。
101 | 1234 | 0 | 0000002500 | 03/12/2017 | 43242 | 0000010271 | 23423 | 243242
201 | 0000002500 | 1 || 0 | re | ref-30-1100
202 | 0000002500 | 1 | 1 | 03/31/2017 | 2.0000
203 | 0000002500 | 1 | 1 | 1 | 100.0000 | 2.0000
101 | 1234 | 0 | 0000002500 | 03/12/2017 | 43242 | 0000010271 | 23423 | 243242
201 | 0000002500 | 1 || 0 | re | ref-30-1100
202 | 0000002500 | 1 | 1 | 03/31/2017 | 2.0000
203 | 0000002500 | 1 | 1 | 1 | 100.0000 | 2.0000
202 | 0000002500 | 1 | 1 | 03/31/2017 | 2.0000
203 | 0000002500 | 1 | 1 | 1 | 100.0000 | 2.0000
101 | 1234 | 0 | 0000002500 | 03/12 / 2017 | 43242 | 0000010271 | 23423 | 243242
201 | 0000002500 | 1 || 0 | re | ref-30-1100
202 | 0000002500 | 1 | 1 | 03 /31/2017|2.0000
203 | 0000002500 | 1 | 1 | 1 | 100.0000 | 2.0000
203 | 0000002500 | 1 | 1 | 1 | 100.0000 | 2.0000
依旧。
这里的事情是行开头,2不是固定的事。
任何人都可以帮我创建平面文件架构。
谢谢,
VJ。
Hi All,
I have a flat file like below.
101|1234|0|0000002500|03/12/2017|43242|0000010271|23423|243242
201|0000002500|1||0|re|ref-30-1100
202|0000002500|1|1|03/31/2017|2.0000
203|0000002500|1|1|1|100.0000|2.0000
101|1234|0|0000002500|03/12/2017|43242|0000010271|23423|243242
201|0000002500|1||0|re|ref-30-1100
202|0000002500|1|1|03/31/2017|2.0000
203|0000002500|1|1|1|100.0000|2.0000
202|0000002500|1|1|03/31/2017|2.0000
203|0000002500|1|1|1|100.0000|2.0000
101|1234|0|0000002500|03/12/2017|43242|0000010271|23423|243242
201|0000002500|1||0|re|ref-30-1100
202|0000002500|1|1|03/31/2017|2.0000
203|0000002500|1|1|1|100.0000|2.0000
203|0000002500|1|1|1|100.0000|2.0000
and so on.
Here thing is line start with 2 is not a fixed occurrence.
Can anyone help me to create flat file schema.
Thanks,
VJ.
这篇关于平面文件架构与不均匀的结构化平面文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!