I think this is not an easy task as you'll need to check the string character by character trying to match your conditions. You can use functions like Is_Number or Ascii to check if the character are in the range you are looking for.
Is it always the same character that will be in between the numbers . ?
Character will not be same everytime, it will different.
Yes, it would be easier to find a pattern in the string.
Another option, you could try to perform the extract process in the source or target database. I think you'll have the same problem than within Informatica, but maybe you can use a loop.
First question: is this always one letter, or can there be more than one letter?
Second question: will there always be (at least) one letter between the two numbers, or may it happen that there is no such separating letter?
In the easiest case (always one or more letters) you can go the following route;
Reg_Extract( inport, '(\d*)[A-Za-z]*(\d*)', 1)
Reg_Extract( inport, '(\d*)[A-Za-z]*(\d*)', 2)
Thanks alot Nico.
I have implemented the mentioned solution and it's perfectly working fine.
Thank you David for quick assistance !!