s_reynisson wrote:In the Replace dialog box, tick Regular expression, then find the
character you want to replace and put \t instead. Like:
Find ;
Replace \t
You can use space instead of ; or whatever character your file contains.
Well, I tried the option. In the original file, all figures are seperated by a space, like
X Y Z I70196
-0.769456 0.552627 -10.205126 -292
-1.942732 2.053394 -15.427015 -201
-0.399627 1.197550 -11.791374 -9
0.835625 1.545872 -12.746904 -185
3.094027 1.640548 -14.280273 -154
1.498426 -0.400455 -6.673387 -166
5.285493 1.156440 -12.835963 -275
-3.413767 0.132826 -7.879129 -173
-3.498506 0.303052 -8.457050 -145
-6.292206 2.241328 -15.652557 -340
-3.077534 0.318110 -8.547789 -4
After the replacement, it becomes
X\tY\tZ\tI70196
-0.769456\t0.552627\t-10.205126\t-292
-1.942732\t2.053394\t-15.427015\t-201
-0.399627\t1.197550\t-11.791374\t-9
0.835625\t1.545872\t-12.746904\t-185
3.094027\t1.640548\t-14.280273\t-154
1.498426\t-0.400455\t-6.673387\t-166
5.285493\t1.156440\t-12.835963\t-275
-3.413767\t0.132826\t-7.879129\t-173
-3.498506\t0.303052\t-8.457050\t-145
-6.292206\t2.241328\t-15.652557\t-340
-3.077534\t0.318110\t-8.547789\t-4
what I expect should be,
X Y Z I70196
-0.769456 0.552627 -10.205126 -292
-1.942732 2.053394 -15.427015 -201
-0.399627 1.19755 -11.791374 -9
0.835625 1.545872 -12.746904 -185
3.094027 1.640548 -14.280273 -154
1.498426 -0.400455 -6.673387 -166
5.285493 1.15644 -12.835963 -275
-3.413767 0.132826 -7.879129 -173
-3.498506 0.303052 -8.45705 -145
-6.292206 2.241328 -15.652557 -340
-3.077534 0.31811 -8.547789 -4
Any comments are welcome.
Save the file, import into that spreadsheet.
HTH
binjiang wrote:Hi, I have a text file in TextPad and would like to save it as text file format (Tab delimited - one format used in Excel). Any advice is appreciated.