Seven Questions To Ask At Functions Used In Nav.

Hi All,

This post is all about functions which are available in MS Dynamics NAV for Technical customisations.

So the First we have present is :-

1. STRSUBSTNO

Syntax :-

NewString := STRSUBSTNO(String [, Value1] ,...) 

It replaces all the %1 , %2 used in message.

Example:- 

STRSUBSTNO('Your balance is %1',Customer.Balance);

2.STRPOS

Syntax:-

Position := STRPOS(String, SubString)

It provides you the position of the string.

Example:-

Position := STRPOS('Navision','v');

3.STRLEN

Syntax-

Length := STRLEN(String);

It provides the length of the string .

Example :

Length := STRLEN('MSDYNAMICSNAV');

4.INCSTR

Syntax:-

NewString := INCSTR(String)

It increases the integer part in a string.

Example :

NewString := INCSTR('APU12');

Result will be APU13

5. COPYSTR

NewString := COPYSTR(String, Position[, Length])

It copies a part of string into new string.

Example :

Str := COPYSTR('Apurwa', 1, 3);    

6. MAXSTRLEN

MaxLen := MAXSTRLEN(String);

It returns the maximum String Length of the Variable.

Similarly, we have STRLEN to return the Actual String Length of a variable.

7. PADSTR

Str := PADSTR('MS DYNAMICS NAV', 50, 'd'); 

It can be used to select a part of a string on behalf of length and add a string if we want in a part.

8. DELCHR

NewString := DELCHR(String [, Where] [, Which])

To delete a particular character from a string.

You can use where as =,>,<,<>,AND,NOT

9.CONVERTSTR

Str := CONVERTSTR('MS DYnamics Nav', 'D', 'L');

It converts some string to another if present in the orignal string.

10. UPPERCASE & LOWERCASE

It converts a string in Lower and uppercase of orignal string.

11. SELECTSTR 

It retrieves the part of comma separated in a string.

Str := SELECTSTR(2, 'MS ,DYNAMICS ,NAV');

12. DELSTR & INSSTR

It deletes and inserts a part of string in orignal String.

Str := DELSTR('MS DYNAMICS NAV', 3, 8);

Str := INSSTR('MS DYNAMICS NAV', 'Anand', 8);

Thanks for giving your time to read this blog. Please do comment if you want more such post.

these are the system functions provided in MS Dynamics NAV.