web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... How to set fixed width...

Finance | Project Operations, Human Resources, ...

Suggested Answer

How to set fixed widths file format

(0) Share

Report

Report

Posted on by CU21091228-0

230

Hi Team.

Using below link i have generated the .txt file.

https://www.feelyconsultants.com/blog/create-and-save-csv-or-text-file-in-d365-finance-and-operations///

Currently i am getting data like below.

////

Expected Data;-

Each column have fixed width and data should come based on fixed width.

Like below

////

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (0)

Suggested answer

Martin Dráb 237,912 Most Valuable Professional on at

Like (0)

Report
I see it's a continuation of your other questions about TextStreamIo.

Simply add extra spaces to values before writing them to TextStreamIo. For example:

strLFix('sdfsdf,', 13)

Was this reply helpful? Yes No
Martin Dráb 237,912 Most Valuable Professional on at

Like (0)

Report

Note that F&O comes with a data management framework, which supports export to both delimited and fixed-width text files.

I also successfully used FixedWidthParserWriter when dealing with fixed-width text files in Azure Functions.

Was this reply helpful? Yes No
CU21091228-0 230 on at

Like (0)

Report
for sting value will use

strLFix

Please let me know for integer value and real value what should i use?

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,912 Most Valuable Professional on at

Like (0)

Report

There is nothing like a number with spaces. It must be a string.

You already know how to deal with strings, therefore the solution is obvious: convert numbers to strings and use strLFix() (or strRFix()).

Was this reply helpful? Yes No
Martin Dráb 237,912 Most Valuable Professional on at

Like (0)

Report

Has your question been answered? If so, please verify the answer. If not, please tell us what else you need for us before it can be considered answered.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

Martin Dráb 559 Most Valuable Professional

#2

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

#3

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans