I recently looked into a support incident where there were some problems when importing text data from an XML file into NAV. One of the problems was that in the xml file the string contained a lot of useless extra spaces.
Tag Archives: String
Simple tool to replace a string or character in Microsoft Dynamics NAV
Ever got a task to replace a string or character in a string in Microsoft Dynamics NAV but unable to find the simplest solution for this problem.
Don’t worry I have a simple solution for this task.
Learn AL: New string features
The AL language is bringing some nice features to Dynamics NAV developers. I want to cover a couple of the cool new string features.
Power BI, SSAS Multidimensional And Dynamic Format Strings
If you’re building reports in Power BI against SSAS Multidimensional cubes then you may have encountered situations where the formatting on your measures disappears. For example, take a very simple SSAS Multidimensional cube with a single measure called Sales Amount whose FormatString property is set in SSDT to display values with a £ sign:
Passing filters to Power BI reports using the URL / query string
It was only recently that I discovered this – you can pass filters to Power BI reports by deep linking to it and adding a filter in the URL (also called query string). I am not even sure this is a feature, since it only seems to work for ‘equals’ and does not work on Dashboards in Power BI.
Append String – Use DotNet Variable
As a Developer there many scenario comes up where we need to append a text value. This kind of needs do comes up when we need to maintain a certain string length. As a common NAV Developer we use to write the below piece of code.
String Comparison – Use DotNet Variable
I guess many Developers might have had faced this Issue, Whenever we used to compare a Text variable in CAL Coding something like –