Originally posted by: Geetha Nagarajan

Hi,

I have the following as one input

HI*BF:41071*BF:570*BF:5849*BF:V667*BF:5070*BF:72888*BF:27801~

I have 5849 as the second input.

I need to compute the occurrence of BF as "3".

How can I do this?

Any help is greatly appreciated!

Thanks,
G
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: wtx_user

Hi geetha, U can use INDEX function to achieve this. If your contents are defined in a group which will occur multiple times. This function will help u
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange