DSXchange

Hey Vajranatah, Try out this function in Transformer stage : Trim(Convert('ABC',' ', DSLink3.Example)). Hi All, This function is working and its converting multiple charcters into one specified character. Regards Nagesh. Trim(Convert('ABC',' ', DSLink3.Example)). above function works. Thanks for all

As per what I got from your example - in scenario one values will be appended with ABC and second prefixed with ABC. case 1 - Use the Index first to locate the occurence of ABC and then from input extract substring starting from 1 till (value returned by Index - 1). case 2 - Extract the substring s...

I have data in column like this 1) 1ABC 12ABC 123 ABC in each record ABC present . only 3 letters. i want output like 1 12 123 can any one help me in this? 2) Column records are ABC1 ABC12 ABC123 I want output like 1 12 123 help me ..