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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

ER Import file with either LF or CRLF line break

(0) ShareShare
ReportReport
Posted on by 794

Hello, 

I'm trying to import a txt file with ER. When I build the format I have to choose what kind of line break I want (LF, CRLF or CR):

pastedimage1610732767044v2.png

My problem is that the files I want to import could be either type of line break. 

What approach should I take? It doesn't seem this feature is extensible by code.

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    301,069 Super User 2025 Season 2 on at

    Hi Arcadi,

    Can you tell the scenario where you will get files with different codepages? I would recommend to see if you can solve it from the source by choosing one as a requirement.

  • Arcadi  Profile Picture
    794 on at

    Thank you for your answer André,

    It's a file that's used to send data between companies. The party who "standardizes" it does not have requirements about page breaks or encoding nor I can enforce any party to use a certain codepage.

    Because there are no rules I may have problems with encoding in the future, but at the moment that has not ben an issue because it's used only for regional communications. But I do have files with different type of page break, to the best of my knowledge this depends on the character that's used, Windows uses CRLF while Unix/Linux uses LF.

    Probably the files will have to be standardized before importing them to ER, but this will be a hassle because there could be different file sources.

  • André Arnaud de Calavon Profile Picture
    301,069 Super User 2025 Season 2 on at

    You can also try to create multiple ER configurations. But then you will need to know which file has what codepage used.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
Martin Dráb Profile Picture

Martin Dráb 592 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 478 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 305 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans