Find Jobs
Hire Freelancers

boolean search tool to search csv files -Single and Two Byte

$75-175 NZD

Cancelled
Posted over 12 years ago

$75-175 NZD

Paid on delivery
I need a tool which will allow me to search through about 4000 csv files each one being about 30 mb (total is about 100 gigabytes of data) for keywords. I would like to be able to use wildcards as well. I need a visual GUI as well. also a drag and drop interface. I am attaching a sample csv file. The search should be FAST. I want the search to be fast enough to at least be able to search through all the files for a single keyword in 90 minutes. I want to have searches like ("red barron" or "green curry" or ("hot potato" and "cold soup")) and "sour dough" and NOT "french fried potatoes" I would like to have wild cards for prefixes, suffixes, and within the words or phrases. Please tell me the wild card functionality you can provide in your PM bid. Notes: If I search for the word 'wine' I don't want a word like 'swine' unless specified by some sort of wild card. THIS TOOL MUST BE ABLE TO SEARCH 2-byte languages like Japanese, Korean, Chinese. NOTICE that in the sample input file (attached) there are both two byte and single byte text in there. This must be handled properly. It can have an option box to say whether the character set is Western or not if that will speed up Western character searches. Of course, there should be an option for giving a name and location to the resulting output file. THE OUTPUT FILE MUST BE (see attached sample [login to view URL] file): return the same fields as the input file Date, Username,Text, location fields must all be quoted by default but there should be an option for whether a field will be quoted or not for any of the fields. All commas except field delimters must be removed by default but there should be an option for each field to leave them in. The key to whether the output file is in the correct format is whether it can be opened in Excel, saved by Excel, and then reopened and still have the correct number of fields. Also, Excel should read the date field as a date. There should be some sort of progress bar to show how many files have been searched. In the attached file there are 7 fields. The main field to be searched is field number 4. Other fields should be searchable as well however. Any field in the file should be searchable by selecting that field number (the default should be column 4, the "Text" field.) If I have a new format for the csv files with additional columns then the tool should be flexible enough so they should also be searchable. There should also be a Username, Location, Tweet ID range, Date Range search boxes on the tool.
Project ID: 1254040

About the project

1 proposal
Remote project
Active 13 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
1 freelancer is bidding on average $150 NZD for this job
User Avatar
Details in PMB
$150 NZD in 0 day
4.8 (148 reviews)
6.7
6.7

About the client

Flag of JAPAN
Beppu shi, Japan
4.9
53
Payment method verified
Member since Aug 30, 2005

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.