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.
Tag Archives: Split
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:
Split multiple columns into rows in #PowerQuery
Recently, I worked on an interesting problem. Datasource I was working with was a SharePoint list, working with SharePoint lists always turns out to be a difficult task than I first assumed. On top of that, with this particular data source; data was coming as semicolon delimited text. Basically, there were many columns like Mile Stones and Sub Milestones, their related data and so on.