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