Skip to content
Pardaan.com Pardaan.com

If your work becomes your passion…

  • Home
  • Profile
  • Tags
  • LinkedIn
  • Facebook
  • X

Split

  • Home
  • Split
Posted inDynamics NAV & BC Tips & tricks

Business Central Standard Error: The line cannot be split & There is not enough space to insert correction lines (AutoSplitKey Property)

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? Source : Dynamics 365 Lab Read more...
Read More
14 September 2023
Posted inDynamics NAV & BC Tips & tricks

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. Source :…
Read More
6 February 2023
Posted inDynamics NAV & BC Tips & tricks

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…
Read More
27 January 2023
Posted inDynamics NAV & BC Tips & tricks

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:…
Read More
11 October 2022
Posted inDynamics NAV & BC Tips & tricks

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? Source : BEYONDIT GmbH Read more...
Read More
4 July 2022
Posted inDynamics NAV & BC Tips & tricks

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. Source : Hougaard.com Read more...
Read More
8 September 2021
Posted inData & Analysis

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…
Read More
19 February 2019

Posts pagination

1 2 Next page

Menu
  • Profile
  • Tags
Categories
  • Data & Analysis
  • Dynamics NAV & BC
    • Functional
    • General
    • Technical
    • Tips & tricks
  • ERP general
  • Information management
  • Off-topic
  • Projectmanagement
  • Quote of the week
  • Visual C# / ASP.net
Stay Hungry, Stay Foolish
RSS Mibuso
  • How to call a procedure in Business Central from Power Automate
  • How to transfer custom field from service order , service line (items) to Warehouse Entry Table
  • Advice needed: Switching to AL-GO Github?
  • "all of your selections were processed" BC message
  • How to implement OIOUBL 2.1 in NAV 2017 (codeunit 13609)
  • Missing Codeunit 9998 and 9999 of Upgrade Routine NAV2017 to BC 14 Spring 19
  • How can I change my Mibuso E-mail address in my user profile?
  • Tenant Media
  • Amount on Check Ledger Entry does not match amount on Bank Account Ledger Entry
  • GST calculation issue
  • To provide Vendor Payment Bank upload file
  • Deepinserts not working
  • Adding new field to Base App Drop down field group view
  • Adding a new lookup field with a TableRelation to CRM Integration Table
  • Appending to the end of a file - BC v14, C/AL
  • How to save an ANSI file from Business Central?
  • E-Mails gets send but not moved to table Sent E-Mail
  • A part of page 13 Email Editor is not shown for some users, but for others
  • How to get Hash Certificate as Base 64 String in MS BC SaaS
  • What are the best AI coding IDEs for AL code
RSS Dynamics NAV Team Blog
  • Get started with agents for finance: Learnings from 2025 Gartner® CFO & Finance Executive Conference
  • The power of proactive engagement in Dynamics 365 Contact Center
  • Seamless scheduling across time zones in Dynamics 365 Field Service
  • Explore migration options for Microsoft Dynamics GP and Microsoft Dynamics SL customers
  • Unlock the power of record routing with real-time analytics
  • Agentic CRM systems: Learnings from organizations making the switch
  • Under the Hood: Building an AI-Driven Storefront with Dynamics 365 Commerce 
  • AI-powered proactive engagement and conversational journeys with Microsoft Dynamics 365 in public preview
  • Improve contact center operations with shift-based routing
  • Intent-based routing transforms customer support with AI
RSS Power BI
  • Open and edit any semantic model with Power BI tools
  • Power BI June 2025 Feature Summary
  • What’s New in SQL Server 2025 Analysis Services
  • Now available: two new Copilot experiences
  • Your Road to Power BI Certification Starts Here
  • Power BI Report Server May 2025 Feature Summary
  • Power BI May 2025 Feature Summary
  • The next era of Copilot in Power BI: Chat with your Data (Preview)
  • Translytical task flows (Preview)
  • Deep dive into selection expressions for calculation groups
Scroll to Top