Question: How to save custom text file from database

Relating to the question on Experts Exchange: Solved: Generating custom text file sources from sql server database | Experts Exchange

The question was how to extract data from a database and save it in a specific format text file.

This type solution is quite commonly solved using Linx 5.

In order to retrieve data from the database we can use the “ExecuteSQL” component in Linx. And to save the file we use the “TextFileWrite” component.

Using a template of the text file and the FormatWith function, you get a very quick way to achieve specifically formatted textfiles.

I’ve created an example video showing how to create the exact text file required by the question. Also attached is the solution.

Link to the Video: https://www.youtube.com/watch?v=Uq3yPRAhMUk

Please feel free to ask questions on this on the Community.

To download Linx for free, go to http://linx.software

DISCLAIMER:
I work for Twenty57, the creators of Linx, but my answer here is a genuine attempt show you exactly how your problem can be solved using Linx.

SolutionForAnne.lsoz (6.9 KB)