VBA Access Parse out Strings in Text Strings

[starke1120]

I have a table (tblVAS) that contains a field called VAS (Value Added
Servies). This field is imported from an AS/400 and the filed contains
several codes that relate to Value Added Services. The problem is that
they are not ALWAYS seperated with a space, but sometimes are.

I am in need of query the field and matching up the codes to the
actually description in another table. example

VAS coloum in tblVAS may have the following

GOHSLBL MSRPCLIPHTAG

in another table (tblDesc) I have the the code and the description like
so:

GOH - Goes on Hanger
SLBL - Soccer Lift etc...
MSRP- Manufactor Sugesste etc
CLIP - etc

Not all records in the tblVAS will have all the VAS codes in the
string. I need to parse out the ones it has. I hope this makes sense.
But I can not figure out out to parse out all the codes in the VAS
column of tblVAS.

Any help is appreciated.

Thanks,

Dave

[Tom van Stiphout]

On 11 Dec 2006 19:36:47 -0800, st********@hotmail.com wrote:

The AS/400 people probably can help you by revising their export
routine. Take that route first.

-Tom.

>I have a table (tblVAS) that contains a field called VAS (Value Added
Servies). This field is imported from an AS/400 and the filed contains
several codes that relate to Value Added Services. The problem is that
they are not ALWAYS seperated with a space, but sometimes are.

I am in need of query the field and matching up the codes to the
actually description in another table. example

VAS coloum in tblVAS may have the following

GOHSLBL MSRPCLIPHTAG

in another table (tblDesc) I have the the code and the description like
so:

GOH - Goes on Hanger
SLBL - Soccer Lift etc...
MSRP- Manufactor Sugesste etc
CLIP - etc

Not all records in the tblVAS will have all the VAS codes in the
string. I need to parse out the ones it has. I hope this makes sense.
But I can not figure out out to parse out all the codes in the VAS
column of tblVAS.

Any help is appreciated.

Thanks,

Dave

[starke1120]

I shouldn't have said imported. I'm actually querying for this based
on an order number. The query returns all SCC that have VAS Codes,
but I can't read the string as is and I dont have access to the RPG
programmer so I was hoping there was some sort of VBA trick to do this.
But its beyond me :-(

Tom van Stiphout wrote:

On 11 Dec 2006 19:36:47 -0800, st********@hotmail.com wrote:

The AS/400 people probably can help you by revising their export
routine. Take that route first.

-Tom.

I have a table (tblVAS) that contains a field called VAS (Value Added
Servies). This field is imported from an AS/400 and the filed contains
several codes that relate to Value Added Services. The problem is that
they are not ALWAYS seperated with a space, but sometimes are.

I am in need of query the field and matching up the codes to the
actually description in another table. example

VAS coloum in tblVAS may have the following

GOHSLBL MSRPCLIPHTAG

in another table (tblDesc) I have the the code and the description like
so:

GOH - Goes on Hanger
SLBL - Soccer Lift etc...
MSRP- Manufactor Sugesste etc
CLIP - etc

Not all records in the tblVAS will have all the VAS codes in the
string. I need to parse out the ones it has. I hope this makes sense.
But I can not figure out out to parse out all the codes in the VAS
column of tblVAS.

Any help is appreciated.

Thanks,

Dave

[Lyle Fairfield]

st********@hotmail.com wrote:

If you wrote down very clearly what you would like to happen it would
help me.

I know that

GOHSLBL MSRPCLIPHTAG

is the input.

I know that criteria include GOH, SLBL etc.

But I don't know what you want.

Does input contain criterion x? That's pretty simple. So I'm guessing
it's something else.

How many criteria does input contain?

What are the members of an array or list of all the critera contained
in input?

Something else?

If you wrote down very clearly what you would like to happen it might
even help you

By the way, isn't "GOHSLBL MSRPCLIPHTAG" what that girl who did those
funny things in the back of the bus on our high school field trips
always saying?