按列而非按行读取文本
【问题】
Java Read Text Column function similar to ReadLine()
I have a text file containing vector information by pin. It looks like this:
PHP Code:
xxxxxxxxxxxxxxxxxxxx pppppppppppppppppppp iiiiiiiiiiiiiiiiiiii nnnnnnnnnnnnnnnnnnnn 12345689111111111122 012345678901 Count PatAdr (Main) (Main) 1 0 1000000000000010XXXX 2 0 1000000000000010XXXX 3 0 1000000000000010XXXX 4 0 1000000000000010XXXX 5 0 1000000000000010XXXX 6 0 1000000000000010XXXX 7 0 1000000000000010XXXX 8 0 1000000000000010XXXX 9 0 1000000000000010XXXX 10 0 1000000000000010XXXX 11 0 1000000000000010XXXX 12 0 1000000000000010XXXX 13 0 1000000000000010XXXX 14 0 1000000000000010XXXX 15 0 1000000000000010XXXX 16 0 1000000000000010XXXX ...
I want to extract the information column by column. So I would like to be able to write or store each pin by line such as:
xpin1 11111...
xpin2 10000...
xpin3 10000...
Basically, what I am looking for is exactly the Java readLine() function described here:
http://java.sun.com/javase/6/docs/ap...redReader.html
but instead of reading a text file line-by-line. I want to read column by column. Anyone know of such a function or way to do this?
【回答】
要实现这个算法，需要进行集合成员的拼接和转换。java做这种集合式的运算不难，但代码繁琐比较麻烦；使用 R 或 python 都比较容易，但没法被 java 主程序集成。用 SPL 也容易完成，并且可以被 java 主程序调用 (参考Java 如何调用 SPL 脚本)，代码如下：
A |
|
1 |
=file("source.txt").read@n() |
2 |
=A1.to(2,6) |
3 |
=A1.to(14,) |
4 |
=A2.regex("(.*) (.*)";a,b).(b) |
5 |
=A4.new(mid(~,1,1),mid(~,2,1),mid(~,3,1),mid(~,4,1),mid(~,5,1),mid(~,6,1),mid(~,7,1),mid(~,8,1),mid(~,9,1),mid(~,10,1),mid(~,11,1),mid(~,12,1),mid(~,13,1),mid(~,14,1),mid(~,15,1),mid(~,16,1),mid(~,17,1),mid(~,18,1),mid(~,19,1),mid(~,20,1)) |
6 |
=A3.regex("(.*) (.*)";a,b).(b) |
7 |
=A6.new(mid(~,1,1),mid(~,2,1),mid(~,3,1),mid(~,4,1),mid(~,5,1),mid(~,6,1),mid(~,7,1),mid(~,8,1),mid(~,9,1),mid(~,10,1),mid(~,11,1),mid(~,12,1),mid(~,13,1),mid(~,14,1),mid(~,15,1),mid(~,16,1),mid(~,17,1),mid(~,18,1),mid(~,19,1),mid(~,20,1)) |
8 |
=A5|A7 |
9 |
=A8.fno().(A8.field(~).concat()) |
A1：读取source.txt文件内容,将每一行返回成字符串。
A2：取序列第2-6行数据组成新序列。
A3：取14行之后的数据组成新序列。
A4：正则匹配出需要的数据。
A5：将A4拆分成二维表。
A6：正则匹配出需要的数据。
A7：将A6拆分成二维表。
A8：合并2个二维表。
A9：将每列合并成字符串。
