Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

929.Text generator -- How to generate a list of picture names and put into a csv file?

User: Fiona -- 2012-03-24          << 928  930 >>
Hits: 2201
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