|
LQ Newbie
Registered: Mar 2016
Posts: 8
Rep: 
|
how to import text out of .txt file and put/sort them in a libre office tables?
How do i import text bellow from text file (large .txt file) and
sort to libreoffice or comma separate file,
is there any way to do it ? or simple script or example?
_________________________________________
235603: ** vpbx001
** REPORT : CTID=002, NAME=customer1 **
errorcount,barrier,limit
0,1.7,2.7
0,1.7,2.7
== END ==
________________________________________
** REPORT : CTID=003, NAME=customer2 **
errorcount,barrier,limit
0,17.2,27.0
PROBLEM: 2255726,17.2,27.0
== END ==
________________________________________
235603: ** vpbx3
** REPORT : CTID=18, NAME=customer3 **
errorcount,barrier,limit
0,1.7,2.7
PROBLEM: 1,1.7,2.7
== END ==
________________________________________
** REPORT : CTID=82, NAME=customer4 **
** REPORT : CTID=25, NAME=customer5 **
errorcount,barrier,limit
0,1.7,2.7
0,1.7,2.7
== END ==
__________________________________________
errorcount,barrier,limit
0,1.7,2.7
0,1.7,2.7
== END ==
_______________________________________
235603: ** vpbx14
235603: ** vpbx18
** REPORT : CTID=47, NAME=customer6 **
** REPORT : CTID=30, NAME=cutomer7 **
errorcount,barrier,limit
0,1.7,2.7
0,1.7,2.7
== END ==
________________________________________
** REPORT : CTID=15, NAME=customer8 **
errorcount,barrier,limit
0,1.7,2.7
PROBLEM: 289,1.7,2.7
== END ==
________________________________________
errorcount,barrier,limit
0,1.7,2.7
problem 2500,1.7,2.7
== END ==
________________________________________
235603: ** vpbx12
** REPORT : CTID=81, NAME= **
errorcount,barrier,limit
0,1.7,2.7
PROBLEM: 111,1.7,2.7
== END ==
_________________________________________
the way the text could be imported and separate in libreoffice
tables like example below ....
vpbxXX | CTID=XX | NAME=XXXXX | 0,1.7,2.7 | PROBLEM: 289,1.7,2.7
do any sitting with already solution please help..
Last edited by webodin; 03-10-2016 at 04:33 PM.
Reason: spelling
|
