DSXchange

Thanks Chowdary. I will give that a try and let the forum know probably tomorrow.

Regards !!

Craig,

Thanks for the reply. The index or count functions are different from what I am trying to do. I want to find the word "Reversal" (case insensitive) in the string? Any idea how I would make that search case insensitive?

Thanks!!

Hello All, I want to find the word "Reversal" from one of the column in the transformer stage from the string. Example Column A has 100 rows, first 5 are Client Reversal, REVERSAL Coding W/O Contractual Allowanced Diversified Payment Reversal & Patient Payment I want to add a logic in ...