grap some information from data text file then put it on table
i want to get some information from text files and import it to each cell on table
*i try it and came out that everything is in a cell*
this is example of my study text file (my real project is more complicate than this)
dadadadadadadadadadadadadad hahahahah stupid me stupid me stupid me stupid me
lsb.ibm.kbank:FinCheck:AIX:6.3.2:dserver1:198.168.65.108:C:F:FC SCSI:user1
lsb.ibm.kbank:FinCheck:AIX:7.3.1:aserver1:178.168.65.188:C:F:FC SCSI:user3
hahahahahahahah crazy crazy no skill i'm suck toobad lksdjflskdhfsdkfj bla bla bla
dadadadadadadadadadadadadad hahahahah stupid me stupid me stupid me stupid me
lsb.ibm.kbank:FinCheck:AIX:7.3.2:dserver1:178.168.65.118:C:F:FC SCSI:admin
lsb.ibm.kbank:FinCheck:AIX:6.3.0:dserver1:178.168.65.108:C:F:FC SCSI:user2
hahahahahahahah crazy crazy no skill i'm suck toobad lksdjflskdhfsdkfj bla bla bla
dadadadadadadadadadadadadad hahahahah stupid me stupid me stupid me stupid me
lsb.ibm.tbank:NoCheck:AIX:5.3.0:dserver1:198.168.65.108:C:F:FC SCSI:user1
lsb.ibm.kbank:FinCheck:AIX:6.3.1:dserver1:178.168.65.198:C:F:FC SCSI:Admin
dadadadadadadadadadadadadad hahahahah stupid me stupid me stupid me stupid me
dadadadadadadadadadadadadad hahahahah stupid me stupid me stupid me stupid me
sb.ibm.kbank*:FinCheck:AIX*:6.3.1*:dserver1*:178.168.65.198*:C:F:FC SCSI:Admin*
section with (*) is where i want grap to put on my table
CS | OS | Ver| Serv |IP|User <-----------------------the table that i want it look like but i end up everything go into one cells - - can't separate anything
Thank you i just want direction of CODE to study......... Please Guide me
take a look
take a look here:
http://excelexperts.com/export-and-import-tab-delimited-text-file
:D
Thx you i got it now