Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding 13 character codes in text strings
Hi All,
I have text similar to the following.. ---------------------------------------------- field b831 B831 write AASLQ0300000l; PCPACIMTAAABl [B29 ] field B7 b7 ; field a8 @latestdate("PCP2EHSEAAAAh", jEnd); field b8 @if(a8 <jStart, @latest("PCP2EHSEAAAAh", jEnd), @avg("PCP2EHSEAAAAh", jStart, jEnd)); -------------------------------------------------------- All this code is in column A and I want excel to search through the text and copy codes (e.g. PCPACIMTAAABl, PCP2EHSEAAAAh) wherever there may be in the string, into the corresponding row in column B. These codes all share the following characteristics, 1) they are all 13 characters in length 2) the last character in the code is always either a "l", "h" or a "c". Is this possible to do using functions such as index, search or find? Any help at all will be much appreciated. If you need more explanation, please ask and I will be happily explain things further. Many Thanks Pinda. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding 13 character codes in text strings
Hi Pinda,
What are the possible delimiters? Is "eld a8 @l" a code? It is 13 characters and ends with "l" Or are there other restrictions? -- Kind regards, Niek Otten "Bhupinder Rayat" wrote in message ... | Hi All, | | I have text similar to the following.. | ---------------------------------------------- | field b831 B831 write AASLQ0300000l; | | PCPACIMTAAABl [B29 ] | | field B7 b7 ; | field a8 @latestdate("PCP2EHSEAAAAh", jEnd); | field b8 @if(a8 <jStart, @latest("PCP2EHSEAAAAh", jEnd), | @avg("PCP2EHSEAAAAh", jStart, jEnd)); | -------------------------------------------------------- | All this code is in column A and I want excel to search through the text and | copy codes (e.g. PCPACIMTAAABl, PCP2EHSEAAAAh) wherever there may be in the | string, into the corresponding row in column B. | | These codes all share the following characteristics, | | 1) they are all 13 characters in length | 2) the last character in the code is always either a "l", "h" or a "c". | | Is this possible to do using functions such as index, search or find? | | Any help at all will be much appreciated. If you need more explanation, | please ask and I will be happily explain things further. | | Many Thanks | | Pinda. | |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding 13 character codes in text strings
Hi Niek
Good spot. I suppose another charactistic is that it is a continuous string with no spaces, and the first 12 characters are always in CAPS followed by a lower case "l", "h" or "c". Hope this helps, Thanks, Bhupinder "Niek Otten" wrote: Hi Pinda, What are the possible delimiters? Is "eld a8 @l" a code? It is 13 characters and ends with "l" Or are there other restrictions? -- Kind regards, Niek Otten "Bhupinder Rayat" wrote in message ... | Hi All, | | I have text similar to the following.. | ---------------------------------------------- | field b831 B831 write AASLQ0300000l; | | PCPACIMTAAABl [B29 ] | | field B7 b7 ; | field a8 @latestdate("PCP2EHSEAAAAh", jEnd); | field b8 @if(a8 <jStart, @latest("PCP2EHSEAAAAh", jEnd), | @avg("PCP2EHSEAAAAh", jStart, jEnd)); | -------------------------------------------------------- | All this code is in column A and I want excel to search through the text and | copy codes (e.g. PCPACIMTAAABl, PCP2EHSEAAAAh) wherever there may be in the | string, into the corresponding row in column B. | | These codes all share the following characteristics, | | 1) they are all 13 characters in length | 2) the last character in the code is always either a "l", "h" or a "c". | | Is this possible to do using functions such as index, search or find? | | Any help at all will be much appreciated. If you need more explanation, | please ask and I will be happily explain things further. | | Many Thanks | | Pinda. | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How change dimensions of data label text box in pie chart? | Charts and Charting in Excel | |||
Remove last character of text string | Excel Worksheet Functions | |||
How to make a cell recognize multiple text strings? | Excel Worksheet Functions | |||
Finding Partial Text in a Cell | Excel Worksheet Functions | |||
Filter long Text strings | Excel Worksheet Functions |