Hey guys,
I was wondering what the best possible way it would be to parse a
string that is delimitted irregularly.
Basically, I'm going to parse a log file that will contain a nodename,
but the naming convention for the server varies...ie:
CLIN - DATACOM1
FOCUS - TESTSVR1
FCGSVR2
As you can see, some of the nodes are delimitted by a "-" and some are
not... The purpose of parsing this string will be to extract the client
name from the server. I'm needing to parse the client name from the
server and see if it matches in an array and have it output to a
specific queue.
As an example,
FCGSVR2 ** FCG would be the client in this instance
CLIN - DATACOM1 ** CLIN would be the client here
Is this possible at all?
Fast replies would greatly be appreciated... project deadline is
near..and i'm stumped!
This is what I have so far:
myarray = Split("BRMC - RME-A ")
Dim ClientArray (5)
ClientArray(0) = "AHA"
ClientArray(1) = "AVH"
ClientArray(2) = "BRMC"
ClientArray(3) = "CCS"
ClientArray(4) = "FCG"
ClientArray(5) = "FCGCORP"
clientString = join(ClientArray) ' not sure if this is even correct...
I probally have to set up some kind of loop... but I'm totally lost...
myfilterarray = Filter(myarray, clientString, True)
msgbox Join(myfilterarray)
I know this is a newbie question, but how do I convert the ClientArray
Array into a string that the filter can use (clientString) ?