Intelligent Advisor

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!

Translate a sort code with hyphens to without

Paul Howard-MillerDec 6 2019 — edited Dec 13 2019

We collect a sort code with hyphens in the format of ##-##-## eg 10-10-10.

Our back end system can't handle the hyphens, so we need to translate this to pure number ###### eg 101010.

So I want to collect it with the hyphens, then using rules, translate into a non-hypenated version, which I can then map into OSvC.

I've been scratching my head about this for a few days now, anyone have any suggestions?

Thanks,

Paul

This post has been answered by Matt Sevin-Oracle on Dec 6 2019

Jump to Answer

Added on Dec 6 2019

#intelligent-advisor-general-discussion

2 comments

192 views