Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to replace a set of characters in Excel using client_ole2?

2726274Apr 9 2015 — edited Apr 14 2015

Hi,

Is it possible to replace a sequence of characters with different sequence in excel using client_ole2 in oracle forms?

This I need to do in all the cells for a particular column.

Say for eg., in Column B in excel, I have all the values prefixed with 'REP' like REP00001, REP5678 etc and I want to replace REP with say blank or other characters 'ABC' for all the cells under column B.

This I need to do by opening the excel through Oracle forms.

Forms version - Forms [32 Bit] Version 11.1.1.7.0 (Production). How could I acheive this?

Regards,

Nagaraj

Locked Post

New comments cannot be posted to this locked post.

Locked on May 12 2015

Added on Apr 9 2015

#forms, #moved-from-devops

4 comments

968 views