Today we will see how we can data from Business Central table using new data type Text Builder.
To check how this data type work build small program as below which pick up data from customer table and export the data in text file.
Today we will see how we can data from Business Central table using new data type Text Builder.
To check how this data type work build small program as below which pick up data from customer table and export the data in text file.
Today I would like to talk about TextBuilder Data Type and how to use it to export data to a text file in Business Central.
Small post – just because I needed it recently – and it made me think of this little gem that I still had to share: what if you have to search over multiple lines in multiple files in VSCode .. something that actually might happen more than you want to admit.
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.
Earlier in January AJ Kauffmann tweeted a question about using Enum as Text Constants and a few weeks later I found a great use case for that. In this video, I show how to use Enum to store large constant strings.
The work continues on the Search App. In this episode I tackle the full text search.
Recently I found I needed to remove all the HTML tags from some text in Power Query. I searched and found a great – if complex – function from Marcel Beug here, but I realised that since that post was written the Html.Table M function has been added to the language and that it makes the task very easy. In fact it’s basically the same as the solution I blogged about here for extracting URLs from a web page.