User: Fiona -- 2012-03-24 << 928 930 >> |
Hits: 4392 |
Type: Text generator |
Search all Text generator examples |
Description: |
I have a separate csv file and pictures in jpg. Is there a possibility to use replace pioneer to generate a (excel/csv) list of picture names so that I can include them into the csv file in the right order? I now do this by hand one for one, but having a list of the picture names to integrate in bulk into the csv file would be great and save me lots of time. |
Input Sample: |
files: 2.jpg 1.jpg 3.jpg |
Output Sample: |
generate a list.csv with specified order: 1.jpg 2.jpg 3.jpg |
Answer: |
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
1. open "Tools->Batch Runner"¡¡menu 2. drag multiple jpg files from "windows file browser" to "batch runner" window 3. click the "input file" column, to sort files by name, or drag the horizontal scroll bar to the right, and click title of "date" to sort files by date, and so on. 4. click "export list" button, and edit the "File List Format" entry, change it: If you need to include folder, you can enter: If you don't need folder info, you can enter: If you don't need extension like "jpg", you can enter: You can add other letter or multiple columns like: 5. Click "Next" and enter an output filename such as list.csv, done. |
Similar Examples: |
How to generate a list of sentences from template sentence? (63%) How to convert a vcf file with multiple entries into a csv file? (63%) How to batch rename last part of filenames to the strings from a file? (61%) How to generate a list of strings with sequence id decreased? (61%) How to insert first 7 characters of filename into the end HTML file? (60%) How to generate a list of web pages with 2 numbers increased in sequence? (59%) How to extract tables from many html files into one csv file? (58%) How to generate a list with random numbers between 10 and 70? (58%) |
Check Demo of Text generator |
Keywords: |
horizontal hori pictures avi picture excel include extension export full batch file sort columns batch file list in columns batch file letter generator file extension info batch horizontal add column names in multiple csv files add column names csv batch 1 letter generator |