I wasn't expecting a big RAR file but the .txt file only
Due to the structure (SublistNumber-FileNumber) of your file names I revised the query => Output:
Updated workbook available here
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi,
I want to export 1000 file names into a excel doc with 4 columns by the following instruction:
File-1.mp3 =>> column 1
File-2.mp3 =>> column 2
File-3.mp3 =>> column 3
File-4.mp3 =>> column 4
File-5.mp3 =>> column 1
File-6.mp3 =>> column 2
File-7.mp3 =>> column 3
File-8.mp3 =>> column 4
.
.
.
File-997.mp3 =>> column 1
File-998.mp3 =>> column 2
File-999.mp3 =>> column 3
File-1000.mp3 =>> column 4
All files ended with number at the end…sorted by numbers from 1 to 1000 (exactly like above)
Hi @Amin2234
With Get & Transform aka Power Query
1/ Download that Excel file
2/ In a command prompt (CMD):
2/ In Excel:
As you experienced it's not DIR *.mp3 > FileNames.txt but DIR *.mp3 /B > FileNames.txt - my bad :( + sorry about that
That said, I renamed my dummy files and without changing anything in the query I get the expected result:
I currently have no idea why this doesn't work as expected on your side. Could you:
Thank your very much @Lz._
Could you please tell me how did you apply these filters? step-by-step (sorry for asking I am not pro in Excel)...Because I have another files should be exported and sorted.
Also what is your other method which you just found ("
")?
Another and IMPORTANT question:
Is there any custom and reliable methods that work with the following ways?
I have different shape of mp3 files, sch as:
(2 columns):
Amongst Friends-1.mp3 ==> column 1
Amongst Friends-2.mp3 ==> column 2
Amongst Friends-3.mp3 ==> column 1
Amongst Friends-4.mp3 ==> column 2
.
.
.
Amongst Friends-499.mp3 ==> column 1
Amongst Friends-500.mp3 ==> column 2
============================
(3 columns):
300 most important French adjectives 1 - 25-1.mp3 ==> column 1
300 most important French adjectives 1 - 25-2.mp3 ==> column 2
300 most important French adjectives 1 - 25-3.mp3 ==> column 3
300 most important French adjectives 1 - 25-4.mp3 ==> column 1
300 most important French adjectives 1 - 25-5.mp3 ==> column 2
300 most important French adjectives 1 - 25-6.mp3 ==> column 3
.
.
.
300 most important French adjectives 1 - 25-298.mp3 ==> column 1
300 most important French adjectives 1 - 25-299.mp3 ==> column 2
300 most important French adjectives 1 - 25-300.mp3 ==> column 3
============================
Hi @Amin2234
Could you please tell me how did you apply these filters? step-by-step
I'm afraid to say that this isn't realistic. Power Query as any other techno. isn't something you learn nor teach in a few minutes
I have taken your 3 different patterns (Sublist, Amongst Friends, 300 most important French adjectives) and built a new query that should do what you want assuming files are in different folders. There's no more need to generate a .txt file with a DIR from the command prompt, the query picks the .mp3 files that exist in the Folder path:
There's another parameter (Number of output columns) for you to use...
New query is avaible here for download