Pattern Count and Substitute

[Deepak Kumar]

Hi All,

 

Please help in calculation:

 

Scenario: I have a table, ABC which has hundreds of records. There is a field, abc_t which has multiple values in it.

 

For example:  

 

Values in the field abc_t :

 

In Record 1 :   1                  

                        2

                        3

 

In Record 2:    2

                        5

                        6

                        4      

 

Now, 1 = A ;  2 = B; 3 = C; 4 = D; 5 = E ; 6 = F

Output calculation should be like this :

 

 

For Record 1:   A

                         B

                         C

 

For Record 2:   B

                         E

                         F

                         D 

 

Thank's in advance.

[comment]

See if this helps:

http://www.briandunning.com/cf/851

[Deepak Kumar]

Thanks for your suggestion, it worked.

[bruceR]

Here is a file that includes the updated cd851 custom function. But for me - the problem still exists.

Perhaps having a concrete example file will be helpful in troubleshooting the problem.

 

CF851.fp7.zip

Edited July 7, 2015 by BruceR

[comment]

Oh, my. I am not sure what exactly happened, but somehow I managed to update only part of the function. I have fixed it now. Thank you for pointing this out to me.

[bruceR]

You're welcome. Glad the example helped. I can confirm that the update does in fact work for me. Thanks for this CF and all your many functions and contributions.