a**n 发帖数: 56 | 1 我现在有一堆很大的数据要处理,大概有十几万个数吧(5列,几万行),txt file,格
式是:
1,2,3,4,5,
6,7,8,9,0,
。。。
11,22,33,44,55;
我打算用origin处理,但先要把这堆数据转换成一列(十几万行吧):
1
2
3
4
5
6
7
8
9
0
。。。
44
55
我用import,只能得到
1,2,3,4,5,
6,7,8,9,0,
。。。
11,22,33,44,55;
这样的格式。怎样才可以得到我希望的那样的一列数呢?
我试过了Matlab,Excel,JMP,都搞不定。哪位给支个招?多谢了! | a******s 发帖数: 232 | 2 perl,fortran,c,c++,any programming lang can do it.
【在 a**n 的大作中提到】 : 我现在有一堆很大的数据要处理,大概有十几万个数吧(5列,几万行),txt file,格 : 式是: : 1,2,3,4,5, : 6,7,8,9,0, : 。。。 : 11,22,33,44,55; : 我打算用origin处理,但先要把这堆数据转换成一列(十几万行吧): : 1 : 2 : 3
| n******m 发帖数: 14 | 3 Very easy.
1) You may use Mivrosoft Word to open the TXT file.
2) Then you click the menu "Edit" --> "Replace" to open the find&replace
window.
3) Find ",", and replace it with "^p" (it is a mark of line break).
4) Click "Replace All".
5) Save the file.
Done!
,格
【在 a******s 的大作中提到】 : perl,fortran,c,c++,any programming lang can do it.
| x*****u 发帖数: 3419 | 4 Do you know to do this in emacs? Thanks.
file
【在 n******m 的大作中提到】 : Very easy. : 1) You may use Mivrosoft Word to open the TXT file. : 2) Then you click the menu "Edit" --> "Replace" to open the find&replace : window. : 3) Find ",", and replace it with "^p" (it is a mark of line break). : 4) Click "Replace All". : 5) Save the file. : Done! : : ,格
| n******m 发帖数: 14 | 5 Sorry, I don't know. But you may try this website:
http://www.gnu.org/software/emacs/emacs.html
Good luck.
【在 x*****u 的大作中提到】 : Do you know to do this in emacs? Thanks. : : file
|
|