View Single Post
  #11   Report Post  
Old January 2nd 19, 07:04 PM posted to microsoft.public.excel.programming
[email protected] jaycee.lions@gmail.com is offline
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2018
Posts: 5
Default covert data from text file into columns

On Wednesday, January 2, 2019 at 11:48:23 AM UTC-5, GS wrote:
Garry, thanks for providing the solution. i have another similar file and
tried to use it but it did not work.

i can try to upload the text file if you would like to see it


Yes, I can test with it here to see why because my test file just repeats your
2 sample blocks a gazillion times. Meanwhile, try Claus' suggestion...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion



I tried Claus solution but that did not work. Yours did.

Im adding below contents of the file. I am only interested in column data for some fields NOT all which are Station Name, Hostname, Default window, default usercode. I don't know if there is a way to send you the raw file

I just took a small portion of the actual file which has 2M records. The 1st line is blank - you can copy the text below into notepad


STATION NAME = CPNTA/F2066

INSTALLATION DATA = NONE
HOSTNAME = CPNTA
DEFAULT WINDOW = MARC
DEFAULT TRANCODE = NONE
TRANCODE OVERRIDE ALLOWED = NO
DEVICE TYPE = DEFAULTDEVICE
MAP LIST = NONE
DEFAULT USERCODE = NONE
DEFAULT ACCESSCODE = NONE
DEFAULT CHARGECODE = NONE
TRANCODE POSITION = 1
TIMEOUT INTERVAL = 0:00
CONTROL STATION = NO
SUPER USER = NO
SYSTEM USER = YES
PRIVILEGED USER = YES
CONTINUOUS LOG-ON = NO
VALID SECURITY CATEGORY LIST = ALL
CLOSE ACTION = 1 (Close Window)
CLOSE WINDOW = MARC


STATION NAME = C6713

INSTALLATION DATA = NONE
HOSTNAME = 10_73_24_147
DEFAULT WINDOW = MARC
DEFAULT TRANCODE = NONE
TRANCODE OVERRIDE ALLOWED = NO
DEVICE TYPE = DEFAULTDEVICE
MAP LIST = NONE
DEFAULT USERCODE = NONE
DEFAULT ACCESSCODE = NONE
DEFAULT CHARGECODE = NONE
TRANCODE POSITION = 1
TIMEOUT INTERVAL = 0:00
CONTROL STATION = YES
SUPER USER = YES
SYSTEM USER = YES
PRIVILEGED USER = YES
CONTINUOUS LOG-ON = NO
VALID SECURITY CATEGORY LIST = ALL
CLOSE ACTION = 1 (Close Window)
CLOSE WINDOW = MARC


STATION NAME = DEFAULTSTATION

INSTALLATION DATA = NONE
HOSTNAME = LOCALHOST
DEFAULT WINDOW = MARC
DEFAULT TRANCODE = NONE
TRANCODE OVERRIDE ALLOWED = NO
DEVICE TYPE = DEFAULTDEVICE
MAP LIST = NONE
DEFAULT USERCODE = NONE
DEFAULT ACCESSCODE = NONE
DEFAULT CHARGECODE = NONE
TRANCODE POSITION = 1
TIMEOUT INTERVAL = 0:00
CONTROL STATION = NO
SUPER USER = NO
SYSTEM USER = YES
PRIVILEGED USER = YES
CONTINUOUS LOG-ON = NO
VALID SECURITY CATEGORY LIST = ALL
CLOSE ACTION = 1 (Close Window)
CLOSE WINDOW = MARC


STATION NAME = "C1001T"

INSTALLATION DATA = NONE
HOSTNAME = CPNTA
DEFAULT WINDOW = MARC
DEFAULT TRANCODE = NONE
TRANCODE OVERRIDE ALLOWED = NO
DEVICE TYPE = DEFAULTDEVICE
MAP LIST = NONE
DEFAULT USERCODE = NONE
DEFAULT ACCESSCODE = NONE
DEFAULT CHARGECODE = NONE
TRANCODE POSITION = 1
TIMEOUT INTERVAL = 0:00
CONTROL STATION = NO
SUPER USER = NO
SYSTEM USER = YES
PRIVILEGED USER = YES
CONTINUOUS LOG-ON = NO
VALID SECURITY CATEGORY LIST = ALL
CLOSE ACTION = 1 (Close Window)
CLOSE WINDOW = MARC