how to export txt file

[302]

Hello everyone , please help me . thanks a lot.

a. Create a new folder according to column a name to store txt files
b. If the value of column B is unique, the output TXT file has only this line
c. If the value of column B is not unique, all rows of the value are output to the same TXT file
d. Each TXT file name is named by the value in column B

[302]

Hello, please help me , thanks a lot.

[Artik]

Try it

Please Login or Register  to view this content.

Notes
The data should be grouped against column B.
The group name is taken from the first row of the group.
The root folder may not exist. It will be created. The specified drive must exist. The root folder must not be a folder reserved by the Win system (this is probably obvious ).
The resulting files contain only three columns: Number, Date and Title.
Data in result files may (but need not) contain a header row. You decide on the line:

Please Login or Register  to view this content.

If there is not to be a header, remove the last argument:

Please Login or Register  to view this content.

Artik

[302]

Sorry for the late reply. I really appreciate your help. There is a small problem: how to roughly align the title of the exported TXT document with the column.

[Artik]

I have shown how to generate files that in the future can be used for automatic processing of data from these files (it is known that the data separator is a Tabulator, so there is not much problem with dividing the data into columns). I don't know if I understood your new request correctly. For now, my understanding is that the generated files are to be used for "viewing" (they are to look nice in Notepad ). Is that what you mean? But then the value of these files as a data source becomes questionable.

Artik

[302]

I got it. Thanks a lot .