Computing.Net > Forums > Windows XP > Find string in folder and copy file (.xlsx)

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Find string in folder and copy file (.xlsx)

Reply to Message Icon

Name: Drkr
Date: November 7, 2009 at 12:29:37 Pacific
OS: Windows XP
Product: Microsoft Windows xp professional edition
Subcategory: Software Problems
Tags: String, Copy, batch
Comment:

I would like to do the following:

I have a folder a) with lots of files
I have a folder b) which is empty

I would like to search the folder a) for string "blablabla" and if this string exists in the file then copy the file to folder b). There is a previous response by Mechanix2Go that does the job beautifully for most files including .xls. However it does not recognize .xlsx files. Is there a way to solve this.

Thanks
Kåre



Sponsored Link
Ads by Google

Response Number 1
Name: Mechanix2Go
Date: November 7, 2009 at 14:39:06 Pacific
Reply:

Does it not recognize the .xlsx files or does it not want to look into them?

What is a .xlsx file?


=====================================
Helping others achieve escape felicity

M2


0

Response Number 2
Name: Mechanix2Go
Date: November 7, 2009 at 14:48:09 Pacific
Reply:

OK, Found this:

http://filext.com/file-extension/xlsx

It is a combination of XML architecture and ZIP compression for size reduction.

Looks like you're out of luck. If compressed, the text won't be readable.


=====================================
Helping others achieve escape felicity

M2


1

Response Number 3
Name: Drkr
Date: November 8, 2009 at 06:14:08 Pacific
Reply:

Thank you very much. I will stick to the standard uncompressed Excel file format. Thanks again.
Kåre


0

Response Number 4
Name: tvc
Date: November 8, 2009 at 06:21:25 Pacific
Reply:

Well, know that both XLS and whatever type derived from that, is a binary file, and when you start doing text searches in binary files, your result will be based on luck, and luck only.

It was a coincedence already that you've found the text in the XLS already. If you know the other format is a compressed one, don't even bother doing text search in there.

My advice would be to not do text searches in binaries, over which you have no control, which obviously is the case for XLS files (that is, if they are true Excel files).

Your result may be questionnable. It may work, it may not, it may not work tomorrow, but if may also do.


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More






Use following form to reply to current message:

Login or Register to Reply
LoginRegister


Sponsored links

Ads by Google


Results for: Find string in folder and copy file (.xlsx)

Audio CD lags when copying files... www.computing.net/answers/windows-xp/audio-cd-lags-when-copying-files/98143.html

Error in Copying File or Folder www.computing.net/answers/windows-xp/error-in-copying-file-or-folder/115444.html

Copy files in dos www.computing.net/answers/windows-xp/copy-files-in-dos/108625.html