Ehhr yes I tried that route without much of success, somewhere end next year they said, problem with an answer like that is it can now next year but then next year it still can ne next year, so in fact never :(
Regex would have been a solution for this but that seems not available.
Kind Regards,
Ruud Reinold
| Ruud Reinold Telecom Manager | ruud.reinold@bnpparibas-pf.co.uk Chadwick House, Blenheim Court SOLIHULL Tel: +44 33 0165 3933 Mob: +44 78 2164 3677 |
|  Do not print this document unless it is necessary, consider the environment |
********************************************************************* BNP Paribas Personal Finance is a trading style of Creation Financial Services Limited. Registration Number: England 1091883. Registered Office: Chadwick House, Blenheim Court, Solihull, West Midlands, B91 2AA. Creation Financial Services Limited is authorised and regulated by the Financial Conduct Authority. BNP Paribas Personal Finance is a trading style of Creation Consumer Finance Limited. Registration Number: NI32565. Registered Office: 4th – 6th Floor, Wellington Buildings, 2-4 Wellington Street, Belfast, BT1 6HT. Creation Consumer Finance Limited is authorised and regulated by the Financial Conduct Authority. This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. Any views or options presented are solely those of the author and do not necessarily represent those of BNP Paribas Personal Finance. Internet communications are not secure and therefore BNP Paribas Personal Finance does not accept legal responsibility for the contents of this message. If you are not the intended recipient, you are hereby notified that you have received this e-mail in error and that any use, disclosure, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. BNP Paribas Personal Finance will not be liable for direct, special, indirect or consequential damage arising from alterations of the contents of this message by a third party or as a result of any VIRUS being passed on. Any pricing details or other offers delivered via e-mail are not binding on BNP Paribas Personal Finance. If appropriate, an official quotation confirming pricing and bearing an authorisation signature will be provided by post or fax on request. If you have received this e-mail in error, please notify the sender immediately and delete the e-mail without taking any copies or forwarding it elsewhere. *********************************************************************
Original Message:
Sent: 11/8/2022 3:56:00 PM
From: Paul Simpson
Subject: RE: How to compare User numeric input with alpha-numeric data from a data dip?
Hey Ruud!
In a previous life, we had a similar need. We ended up getting the folks providing the CRM API add an extra return field that contains the numeric portion of the house number only. Proved to be easier than trying to process the result when it got into Architect!
HTH
------------------------------
Paul Simpson
Eventus Solutions Group
------------------------------
Original Message:
Sent: 10-20-2022 11:53
From: Ruud Reinold
Subject: How to compare User numeric input with alpha-numeric data from a data dip?
Hi all,
In our architect flow we are requesting the house number that a caller lives at to be compared with the data on their contract.
We do a Data dip and retrieve their records but for extra security on certain options we require the caller to ID&V at a next level comparing their house number with what is on their contract. We found that when a caller presses 134 but on their contract it states they live at 134e that the authentication fails.
I need to compare only the numeric part of what is coming from the DB with the user input on the call.
How do I strip the alpha characters?
#ArchitectureandDesign
------------------------------
Ruud Reinold
BNP Paribas Personal Finance UK
------------------------------