Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to separate data b...
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 user 123 163

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.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,696 Super User 2024 Season 2 on at
    RE: How to separate data by : and , of the blob field in Business central

    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

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,272 Super User 2024 Season 1 on at
    RE: How to separate data by : and , of the blob field in Business central

    hi

    look this

    ashirokikh.com/.../

    DAniele

  • Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: How to separate data by : and , of the blob field in Business central

    Hi,

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

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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans