Checking string

[Guest]

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!

 

[NickHK]

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

NickHK

 

[Guest]

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:

 

[NickHK]

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