Convert Bank Acc No.

Wojtekm

Hi,

I am working with NAV 5.0 SP1

I have problem with converting Bank account no.
I have 26-digit account no. in various format like:
12 1234 1234 1234 1234 1234 1234 or
12-1234-1234-1234-1234-1234-1234 or
12 123412341234123412341234 etc.

and I would like to convert it to format like this:
12123412341234123412341234

Bank Account No. is text field.

Is it necessary to create function wich will check every sign from string and convert it it is not digit?

regards
wojtekm

DaveT

Hi Wojtekm,

Use the DELCHR or DELSTR functions deleting '-' and ' '

Wojtekm

Thank you,

:oops: I sholud know this :oops:

DaveT

Hi,

No problem - there is a nice quick reference guide you can download from Mibuso

http://www.mibuso.com/dlinfo.asp?FileID=855

Savatage

I'vd found the CharsToKeep function Kriki posted a long time ago has many uses, Phone Numbers, Zip Codes, Account Numbers, etc

txtCharsToKeep := '0123456789'; 
FieldYouWantToClean := DELCHR(FieldYouWantToClean,'=',DELCHR(FieldYouWantToClean,'=',txtCharsToKeep));

Only thing left will be the digits 0 thru 9 - so it can contain any kind of seperator (space, dash, parenthasis, tilda, etc)
and it will get rid of them.