Small and medium business | Business Central, N...

Special Characters in BC

(0) Share

Report

Posted on by Trublu849

275

Hey,

What special characters can not be used in BC? i.e any of the following...!@#$%^&*()= in item creation, job creation etc. or in BC totality

Thanks!

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

JAngle 133 on at

Like (0)

Report

Some helpful resources:

support.jetglobal.com/.../219402397-NAV-and-Navision-Code-and-No-fields-with-Special-Characters

https://youtu.be/cr9UCF-jEz0

www.navug.com/.../viewthread

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (1)

Report

Hi, there are not too many restrictions in BC. I recently discovered that you can even enter emoticons in the code field and text field.

For example:

But for system developers and administrators, I definitely don’t want to use these special characters.
Hope the following link will help.

How to prevent users from entering special characters inside an input field: https://yzhums.com/5734/

Thanks.

ZHU

Was this reply helpful? Yes No
Dev-Master 65 on at

Like (0)

Report

Hi, I am going in a situation where i have product name with special character like 1001-B(101) .

as i am already using the .filter function with filter criteria of ignore case

itemRec.SetFilter("No.", StrSubstNo('@%1*', ProductName));

it gives error The filter "@(" is not valid for the No. field on the Item table. An error occured while interpreting the filter: Did not expect '('.

when i apply this filter.

itemRec.SetFilter("No.", StrSubstNo('*%1*', ProductName));

and try to search with this filter it gives error "The filter "*(*" is not valid for the No. field on the Item table. An error occured while interpreting the filter: Did not expect '('.

How can i apply both ignore case filter '@' and any special charter in the item name for product name searching like 1001-B(101).

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

Hi,

Try like this

itemRec.SetFilter("No.", '%1',StrSubstNo('@*%1*', ProductName));

Was this reply helpful? Yes No
Dev-Master 65 on at

Like (0)

Report

Hi thank you for your response.

Can you please elaborate working of this filter. I am new in business central so i just know basic understanding of set filter function.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (1)

Report

Hi,

I have used only simple setfilter function only the catch is I have provided the values extracting from the function STRSUBSTNO with special characters in between of @* string*

please check if it works for you

Was this reply helpful? Yes No
Dev-Master 65 on at

Like (0)

Report

Yes thank you it worked for me. but i am getting exception if the product name is like this DS-2CD2132F-IW(4MM).

It give exception of

The length of the string is 22, but it must be less than or equal to 20 characters. Value: @*DS-2CD2132F-IW(4MM)*

How to solve this?

Was this reply helpful? Yes No