Informatica Help Need.

[massmaharaj]

/a/b/c/d/abc.txt
/a/b/c/d/abc1.txt


table column ala undi dataa


output

abc.txt
abc1.txt


ila raavali pls elaa

[JerryAcapulcoP]

1. is the characters in the beginning are fixed? [color=#282828][font=helvetica, arial, sans-serif]/a/b/c/d/ - if yes, you can use a substr[/font][/color]
2. if the above is not then, hopefully the "/" is fixed and use instr and looking for the 5th /

The above two just assumptions, let me know the complete problem. so i can help you better.