Checking string
 

Hi! I have a matrix that contains names of companies and some info about
these compaines. For every company there is an array that contains rating
info. These ratings are written with a special syntax. What I want to do is
to find which rating agency is used. The ratings are written with a special
syntax. First comes three letters and an underscore and then comes (an
abbrevation of) the name of the ratingagency. Eg a raing looks like: RTG_SP*.
Here I want to single out the SP. The start indicates that there might be
additional info that I am not intreseted in. There are only three rating
agencies that I want to single out; SP, MDY and FITCH. But how do you check
an array and look for the names? Please any help appreciated! Thanks alot!

Checking string
 

Arne,
Is there an end-of-agency marker ?
Something between the "SP" and the rest of the info ?

NickHK

"Arne Hegefors" ...
Hi! I have a matrix that contains names of companies and some info about
these compaines. For every company there is an array that contains rating
info. These ratings are written with a special syntax. What I want to do
is
to find which rating agency is used. The ratings are written with a
special
syntax. First comes three letters and an underscore and then comes (an
abbrevation of) the name of the ratingagency. Eg a raing looks like:
RTG_SP*.
Here I want to single out the SP. The start indicates that there might be
additional info that I am not intreseted in. There are only three rating
agencies that I want to single out; SP, MDY and FITCH. But how do you
check
an array and look for the names? Please any help appreciated! Thanks alot!

Checking string
 

Hi NickHK! Yes there is such a marker. Let me give you an example of how it
looks like: RTG_SP_LT_ISSUER_DEFAULT. As you can see there is always RTG_
before the abbrevation of the rating agnecy name. After that name you also
have an underscore. Does that make it easier?

"NickHK" skrev:

Arne,
Is there an end-of-agency marker ?
Something between the "SP" and the rest of the info ?

NickHK

"Arne Hegefors" ...
Hi! I have a matrix that contains names of companies and some info about
these compaines. For every company there is an array that contains rating
info. These ratings are written with a special syntax. What I want to do
is
to find which rating agency is used. The ratings are written with a
special
syntax. First comes three letters and an underscore and then comes (an
abbrevation of) the name of the ratingagency. Eg a raing looks like:
RTG_SP*.
Here I want to single out the SP. The start indicates that there might be
additional info that I am not intreseted in. There are only three rating
agencies that I want to single out; SP, MDY and FITCH. But how do you
check
an array and look for the names? Please any help appreciated! Thanks alot!

Checking string
 

Arne,
If it always going to be the 2nd value in the list wth at least 1 "_", then
RatingAgency=Split(Matrix,"_")(1)

Not sure what you matix is ; cell value, array value etc

NickHK

"Arne Hegefors" wrote in message
...
Hi NickHK! Yes there is such a marker. Let me give you an example of how
it
looks like: RTG_SP_LT_ISSUER_DEFAULT. As you can see there is always RTG_
before the abbrevation of the rating agnecy name. After that name you also
have an underscore. Does that make it easier?

"NickHK" skrev:

Arne,
Is there an end-of-agency marker ?
Something between the "SP" and the rest of the info ?

NickHK

"Arne Hegefors"
...
Hi! I have a matrix that contains names of companies and some info
about
these compaines. For every company there is an array that contains
rating
info. These ratings are written with a special syntax. What I want to
do
is
to find which rating agency is used. The ratings are written with a
special
syntax. First comes three letters and an underscore and then comes (an
abbrevation of) the name of the ratingagency. Eg a raing looks like:
RTG_SP*.
Here I want to single out the SP. The start indicates that there
might be
additional info that I am not intreseted in. There are only three
rating
agencies that I want to single out; SP, MDY and FITCH. But how do you
check
an array and look for the names? Please any help appreciated! Thanks
alot!