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 :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to get the first w...
Finance | Project Operations, Human Resources, ...
Answered

How to get the first word of a text field of D365FO in Electronic Report

(0) ShareShare
ReportReport
Posted on by Eric_Santos 46

Hello all.

I need some help with this. I have an Electronic Reporting model mapping and I need to retrieves in a specific field the type of address of the vendors such as Street, Avenue, etc. I need a formula that can get the first word of the vendor address. How can I do that ?

Thanks in advance.

  • Verified answer
    huijij Profile Picture
    huijij 19,813 on at

    Hi Eric,

    You can search for regular expressions on the google and use them with Replace,eg:

    REPLACE ("+1 923 456 4971", "[^0-9]", "", true) applies a regular expression that removes all non-numeric symbols, and it returns "19234564971".

    docs.microsoft.com/.../er-functions-text-replace

  • Eric_Santos Profile Picture
    Eric_Santos 46 on at

    Thank you so much Judy. I needed to made a combination with other formulas, in this case I used REPLACE, CASE and MID. . But at the end it's worked fine. Here is the formula that I used below.

    REPLACE(Doc_Fiscal.'find()'.'<Relations'.'EFDocumentCity_BR.FiscalDocument'.'getThirdPartyPostalAddress()'.Street, Doc_Fiscal.'find()'.'<Relations'.'EFDocumentCity_BR.FiscalDocument'.'getThirdPartyPostalAddress()'.Street, CASE(MID(Doc_Fiscal.'find()'.'<Relations'.'EFDocumentCity_BR.FiscalDocument'.'getThirdPartyPostalAddress()'.Street, 1, 3), "RUA", "RUA", MID(Doc_Fiscal.'find()'.'<Relations'.'EFDocumentCity_BR.FiscalDocument'.'getThirdPartyPostalAddress()'.Street, 1, 8)), FALSE)

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 543 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 415 Super User 2026 Season 2

#3
CU-1234529-002 Profile Picture

CU-1234529-002 188

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans