按列的位置取数
【问题】
I have a text file which has all the information I need in lines and this needs to be converted into a .csv file.
Example:
abbccccdeffffiiiiiiiiiiiiiijjkkkkkkkkkkkllmmmmmmnnooo
abbccccdeffffiiiiiiiiiiiiiijjkkkkkkkkkkkllmmmmmmnnooo
abbccccdeffffiiiiiiiiiiiiiijjkkkkkkkkkkkllmmmmmmnnooo
abbccccdeffffiiiiiiiiiiiiiijjkkkkkkkkkkkllmmmmmmnnooo
abbccccdeffffiiiiiiiiiiiiiijjkkkkkkkkkkkllmmmmmmnnooo
abbccccdeffffiiiiiiiiiiiiiijjkkkkkkkkkkkllmmmmmmnnooo
So basically
- 1.“a” is first column with just one char
- 2.“bb” is second column with length 2
- 3.“cccc” is third column with length 4
- 4.“d” is fourth column with length 1
- 5.“e” is fifth column with length 1
- 6.“ffff” is sixth column with length 4
As we can see from this example, I cannot use a delimiter with space or commas, they are all of different lengths. Please point me to the right direction. I just need an idea of how to approach to this problem.
【回答】
按列取记录可用SPL实现，代码简单易懂：
A |
|
1 |
=file("d:\\source.csv").import@si() |
2 |
=A1.new(mid(~,1,1),mid(~,2,2),mid(~,4,4),mid(~,8,1),mid(~,9,1),mid(~,10,4)) |
A1：读取source.csv文件内容。
A2：使用mid(s, start{, len})函数获取字符串的子串 ，以便把A1每一行拆分成一个二维表。
计算结果是二维表，可以继续进行排序、查询，或分组汇总等运算。
