Today I would like to briefly share an error handling of Business Central. I was asked this question again recently.
Have you ever experienced the following two errors?
Tag Archives: Split
How to Split a List into Sublists of size N in Business Central
The following post is related to how to divide a List into several sublists given size in Business Central.
I recently had a case where I was asked to build a process that consumes a third-party API in order to upload a JSON file.
Text splitting and formatting using Lists
I get a lot of questions from all my great viewers, and many of these questions turn into videos. This is one of them. In this video, I take a look at how we can use the List datatype to help us split strings in a controlled manner. Check it out:
Split Old fashioned C/AL Object Files
If you are working with older Dynamics NAV versions you need to handle the old fashioned objects by using fob or txt files.
Powershell is very powerful and if you need to split a big txt file full of objects, you can use or powershell script:
Split Multiline Text into Records (Regex)
Wouldn’t it be nice to copy and paste any text you like to save it directly into any table and it’s splitted automatically?
It’s annoying for users to split the lines on their own, right?
Text.Split is a great way to parse strings in AL and Business Central
In this video, I show how Text.Split and the List data type makes a great pair for text parsing. The method can avoid lots of copystr-strpos gymnastics.
Splitting Text By Character Transition In Power BI And Excel Power Query
The February 2019 release of Power BI Desktop includes some new functionality not mentioned in the summary blog post, functionality that is already in the latest Excel 365 builds (thanks Ed Hansberry for pointing this out) and will be extremely useful. It takes the form of four new options under the Split Column button in the Query Editor: