Hi all,

I got the solution myself.. closing this topic Thanks a lot.

Thanks a lot to both Luis and Dwain.

I am able to get the expected output.

Regards,

Kumar.

Hi chris,

Thanks for sharing the function.

I got below output from your code: ( two numbers in a single column)

20.16

50.41

30.25

325

Expected output: ( two numbers in a two separate...

Thanks a lot Chris !!!

Regards,

Kumar

Hi Chris,

Thanks for your response.

It is the case that based on pattern matching, we have to retrieve the index number.

If pattern matching fails,then identify the error record for...

Thanks Eugene Elutin for your help.

Its working!!!!!!!!!!!!!!!!

Kumar.

Hi,

I have updated my problem statement as per given guidelines. Hope it is fine now.

Thanks

Hi,

I am expecting a generic solution so that even if the attributes change,it should work

Hi Cadavre,

Thanks for providing the solution.

observed case :

Input : A1(1).B22(10).C345(100)

received output from your code : A1(1).B2(10).C3(100)

Desired output : A1(n).B22(n).C345(n)

output is giving only one integer from each substring...

Hi Cadavre,

Thanks for your great help.

I observed that for this input :

@STR = 'A1(1).B2(2)'

output from your code : Ann).Bnn)

Desired output : A1(n).B2(n)

String manipulation shoud effect only the...

Hi Lowel,

Thanks for immediate response.

Still same output from your code:

A(n).BC(nn).DEF(nnn)

Expected output : A(n).BC(n).DEF(n)

( whatever the number enclosed in brackets should be replaced with single 'n')

Thanks,

santosh kumar