HELP - LIST IMPORTER - anyone?? HELP - GoFuckYourself.com

retronerd · 03-07-2006, 08:32 PM

i have a list of files.... all text files... i need to import the list of file names into an excel or text document.. for example.. my files are called house1.txt house4.txt tax4.txt etc... i need to import hundreds of these FILE NAMES into an excel document like this

house1
house4
tax4

etc

anyone know how to do this?

Ace_luffy · 03-08-2006, 12:21 AM

bump for the cause.....

Linguist · 03-08-2006, 12:27 AM

In linux/unix (or use cygwin if you're in windows), put them all into one directory and then:

ls -1 > file.txt

if you want to open it in Excel:

ls -1 > file.csv

Linguist · 03-08-2006, 12:31 AM

I misread the question, if you don't want to have .txt displayed at the end, do this:

ls -1 | cut -d . -f 1 > output.txt

Make sure none of the files have "." as a part of their file name.

03-07-2006, 08:32 PM	#1
retronerd Registered User Join Date: Mar 2006 Posts: 1	HELP - LIST IMPORTER - anyone?? HELP i have a list of files.... all text files... i need to import the list of file names into an excel or text document.. for example.. my files are called house1.txt house4.txt tax4.txt etc... i need to import hundreds of these FILE NAMES into an excel document like this house1 house4 tax4 etc anyone know how to do this?

03-08-2006, 12:21 AM	#2
Ace_luffy www.creationcrew.com Industry Role: Join Date: Feb 2005 Location: CREATIONCREW.COM CREATIONCREW.COM CREATIONCREW.COM CREATIONCREW.COM CREATIONCREW.COM CREATIONCREW.COM Posts: 12,110	bump for the cause..... __________________ ++ Adult and Mainstream Websites Designs \| 10 banners for only $50 \| html5 Banners ++ email : [email protected] Telegram : https://t.me/creationcrew \| HTML5/Responsive Site - Div/CSS - ElevatedX - NATs - Wordpress

03-08-2006, 12:27 AM	#3
Linguist Confirmed User Join Date: Apr 2004 Location: Toronto, ON Posts: 1,706	In linux/unix (or use cygwin if you're in windows), put them all into one directory and then: ls -1 > file.txt if you want to open it in Excel: ls -1 > file.csv

03-08-2006, 12:31 AM	#4
Linguist Confirmed User Join Date: Apr 2004 Location: Toronto, ON Posts: 1,706	I misread the question, if you don't want to have .txt displayed at the end, do this: ls -1 \| cut -d . -f 1 > output.txt Make sure none of the files have "." as a part of their file name.