Dynamics 365 Business Central: How to extract characters from a string (indexing with [])

Today I would like to share another mini tip about Business Central, how to extract characters from a string.

For example, we want to know what the fourth letter of a customer’s name is, or want to add a space between each character. How to do it?

Source : Dynamics 365 Lab
Read more…

Dynamics 365 Business Central: How to save large text/string in the table

Today I would like to talk about how to save large text/string in the Business Central table.
I was asked this question the other day, they want to save a large text in the table. e.g. length of the text is 10,000 characters. However, because of system limitations, it is not possible to create such a long text field.

Source : Dynamics 365 Lab
Read more…

D365 Business Central : StringConversionManagement Codeunit

There are lots of Management Codeunit in D365 Business Central. Let us talk about one of them which is StringConversionManagement Codeunit. There are currently four procedures in this Codeunit that you can call:
– WindowsToASCII
– GetPaddedString
– RemoveDecimalFromString
– RemoveNonAlphaNumericCharacters

Source : That NAV Guy
Read more…