Not allow specific value in item decription field

cwiginton

Hello,
I need to find a way to stop my users from entering " and , into the item desription field. We have to periodically export to a .csv file and these values are causing problems. Any advise would be greatly appreciated.

Thanks

matttrax

So essentially you need to parse your text before saving it to the database.

Look into STRPOS which will help you search for a specific character, and COPYSTR, which will let you take substrings. DELCHR might also help.

Savatage

if you use STRPOS to search the string for the characters you want and it returns a value of anything but zero then it exists.

another way is to determine the allowable characters

txtAllowedChars := 'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'; // string with all allowed characters
vDescription := DELSTR(Description,'=',txtAllowedChars);
IF vDescription <> '' THEN ERROR('Characters "%1" are not allowed',vDescription);

ara3n

Another solution is to not export it as csv, but as TAB delimited and the only value they cannot enter is TAB which is not possible to enter manually in NAV.

ara3n

another solution is to just add code to remove " when they enter it.

The following code onvalidate

Description := Delchr(Description,'=','"');

themave

ara3n wrote:

another solution is to just add code to remove " when they enter it.

The following code onvalidate

Description := Delchr(Description,'=','"');

I use a variation of this method, it works fine, before I export data, I run a processing only report on the table, it removes the charactures. I'm an end user and can't add code to the form, but you can accomplish the same end result with a processing only report.

I also wanted our customer search name field to not contain any spaces or other special charactures, it should only be letters,
so John's Truck & Equipment Co. should have a search name of
JOHHSTRUCKEQUIPMENTCO

I use a processing only report, that runs from the job queue with the following info.
using the nested delchr, deletes everything that is not a letter.

"Search Name" := DELCHR(Name,'=',DELCHR(Name,'=','ABCDEFGHIJKLMNOPQRSTUVWXYZ'));
Modify;

David_Singleton

Why not just set the CharAllowed property, no code, simple and does what you want.

Just
go to the Table designer,
go to the Description field
Open properties
Find the CharAllowed Property
In this property, enter the secret code #+ !-~

#+ !-~

That should work for you.

(copy paste the code so you get it right.

matttrax

David Singleton wrote:

Why not just set the CharAllowed property, no code, simple and does what you want.

I didn't even know that property existed.

This is one of those threads I love. Every post is a valid solution to the question.

cwiginton

David,

The CharAllowed #+ !-~ worked!!

Thank you very much!! =D>

David_Singleton

cwiginton wrote:

David,

The CharAllowed #+ !-~ worked!!

Thank you very much!! =D>

I am lazy, and a terrible typist, so I always look for the easiest solution. Glad it helped you out.

Alex_Chow

David Singleton wrote:

Why not just set the CharAllowed property, no code, simple and does what you want.

Just
go to the Table designer,
go to the Description field
Open properties
Find the CharAllowed Property
In this property, enter the secret code #+ !-~

#+ !-~

That should work for you.

(copy paste the code so you get it right.

Genius!!!

David_Singleton

Alex Chow wrote:

David Singleton wrote:

Why not just set the CharAllowed property, no code, simple and does what you want.

Just
go to the Table designer,
go to the Description field
Open properties
Find the CharAllowed Property
In this property, enter the secret code #+ !-~

#+ !-~

That should work for you.

(copy paste the code so you get it right.

Genius!!!

:oops: Thanks

southindian

there are certain special characters which i need to delete ,that cannot be mentioned in coding like for example

(Item description = SWR Pipe Type B SL á 3.6Mtr(12ft)á 90mm) . how to make navision system understand this character ( which is bold). kindly guide... i had passed these special charaters in navision like

corrstr:=DELCHR(getsrt,'<>','àû');

but still the special characters is not getting deleted. wats is the fault ?

ara3n

You wrote

corrstr:=DELCHR(getsrt,'<>','àû');

it should be

corrstr:=DELCHR(getsrt,'=','àû');

David_Singleton

southindian wrote:

SWR Pipe Type B SL á 3.6Mtr(12ft)á 90mm) .

southindian wrote:

corrstr:=DELCHR(getsrt,'<>','àû');

Actually I think also the á and à are an issue. :whistle:

southindian

yes sir... you are right ... today morning when i came i found that the special character i have entered is wroang and rectified it... now it is working fine...... :thumbsup:

David_Singleton

southindian wrote:

yes sir... you are right ... today morning when i came i found that the special character i have entered is wroang and rectified it... now it is working fine...... :thumbsup:

you're welcome.

Andwian

David Singleton wrote:

enter the secret code #+ !-~

#+ !-~

What is it mean?
Is it mean that it only allow any character: #+ <spaces> !-~ ?

Thank you.

That's such an out-of-the-box approach. Thinking simply, yet brilliant. Great! :thumbsup: