| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking for a particular string in a cell | Excel Worksheet Functions | |||
| checking for a string & No. | Excel Worksheet Functions | |||
| Spell Checking a String | Excel Programming | |||
| Checking to see whether a string contains a certain character | Excel Programming | |||
| Checking the value of the end of a string | Excel Programming | |||
Hybrid Mode
