How to differentiate Letters & Numbers

Business Central/NAV Developers Forum
1

Hi All

In Navision how can i differentiate Letters(a,b…) and Numbers(1,2…)

I want to put a validation in the customer numbers that it should contains only 2 letters & 6 numbers

2

Why dont you create a No.Series and untick Manual No’s

3

Nope, they will enter nos manually only

4

Hi, take a look at the string function DELCHR. I have used this as a function in some of my coding solutions:

txtChartoKeep := ‘ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890abcdefghijklmnopqrstuvwxyz’;

EXIT(DELCHR(BeforeText,’=’,DELCHR(BeforeText,’=’,txtChrtoKeep)));

Parameters: BeforeText - text(50)

Return Value - Text(50)

Variables - txtChrtoKeep - Text(200)

I believe your solution would be a variation to this. Give it a shot!

5

use delchr to find & remove all letters and then again to remove all numbers - have the remaining characters put into two variables. Use STRLEN to test if you have two letter & 6 numbers and if so you allow the insert else you throw an error.