Merge .Txt Files From Single Folder into Excel, Export as .CSV
$30-100 USD
În desfășurare
Data postării: circa 13 ani în urmă
$30-100 USD
Plata la predare
VBA Excel. This Macro will open folders listed in an excel sheet by their directory paths, each row in the left-most cell containing a new folder. All text files from that folder will be imported into Sheet 2, one whole text file per line. On sheet 2, in the first column second, will be the title of the text file, and in the next column will be the entire .txt fit into a cell. The next row will contain the same Title, Content format until all the .txt files from the folder are listed. For example:
Title Content
Ralph Went to the market...
Tom Sat in the rain
Mary Watched TV
Please note the Content will be multi-paragraph, multi-page content
Sheet 2 will be saved then be exported as a CSV file, the name of the CSV will be the name of the folder, and saved in the same folder as this spreadsheet. This completes one iteration of a folder name. The Macro will then proceed to the second folder directory, and repeat the sequence. This will continue until all folder names have been completed.
ID-ul proiectului: 3328214
Despre proiect
7 propuneri
Proiect la distanță
Activ: 13 ani în urmă
Vrei să câștigi bani?
Avantajele de a licita pe platforma Freelancer
Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte