web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

How to separate data by : and , of the blob field in Business central

(0) ShareShare
ReportReport
Posted on by 351

I am receiving data in a blob field from a third-party environment that contains multiple invoices. The data is in the format of { Name: Content, Name2: Content, ...}. I need to extract the file name and content and store them separately in a table with two columns - name and content. I have already created the table, but I am unsure of how to extract the name and content from the blob field and store them in their respective columns. Additionally, I would like to store the data in an increment format to ensure that each record is uniquely identifiable.

I have the same question (0)
  • Nitin Verma Profile Picture
    21,788 Moderator on at

    Hi,

    You can refer the below link which can provide answer of your problem.

    learn.microsoft.com/.../devenv-write-read-methods-line-break-behavior

  • Suggested answer
    DAnny3211 Profile Picture
    11,407 Super User 2026 Season 1 on at

    hi

    look this

    ashirokikh.com/.../

    DAniele

  • Suggested answer
    YUN ZHU Profile Picture
    98,358 Super User 2026 Season 1 on at

    Hi, If this is a fixed format, you can use the following method to simply split them.

    Text.Split([Text,...]) Method

    https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/text/text-split-text-method

    Here are two simple usage examples, hoping to give you some hints.

    https://yzhums.com/6617/

    https://yzhums.com/9273/

    Thanks.

    ZHU

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,965 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,125 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 961 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans