Text Formatting Project; Combine 6375 Records into 85 Separate Text Strings.
Budget: $30 – $250 USD
This project is to perform some basic text formatting tasks on a set of 6375 text records that are currently stored in an Excel workbook.
The 6375 text records consist of simple word groupings surrounded by quotation marks.
Posted below are the first five records as an example:
"Killed by Roses"
"Wasmuth Portfolio Frank Lloyd"
"Daniell's Oriental Scenery"
"Miller Five Ring Circus"
"Official Ferrari Opus"
The task in this project will be to assemble the 6375 records into 85 sets. Each set will be formatted as a single text string that will be made from 75 records (75 x 85 = 6375).
Each of the sets will be formatted as a single text string. The string will be formatted with parentheses at the beginning and end of the string. The main body of the string will consist of the individual text records (referred to as “search inputs) placed in the order that they appear in the file, and with each input separated by a comma.
As an example, the first five records posted above would be combined into the following text string:
("Killed by Roses", "Wasmuth Portfolio Frank Lloyd", "Daniell's Oriental Scenery", "Miller Five Ring Circus", "Official Ferrari Opus")
The only difference between the above example set and the actual sets to be be delivered is that the actual sets will each be made up from 75 text records (rather than the 5 text records used to create the above example set).
The final deliverable will be either a Notepad file or an Excel file containing the 85 completed sets. This project includes the following two attached files:
* An Excel file containing the 6375 text records to be used as inputs.
* A Notepad file containing the first two completed sets (to be used as examples for generating the remaining 83 sets).
The 6375 text records consist of simple word groupings surrounded by quotation marks.
Posted below are the first five records as an example:
"Killed by Roses"
"Wasmuth Portfolio Frank Lloyd"
"Daniell's Oriental Scenery"
"Miller Five Ring Circus"
"Official Ferrari Opus"
The task in this project will be to assemble the 6375 records into 85 sets. Each set will be formatted as a single text string that will be made from 75 records (75 x 85 = 6375).
Each of the sets will be formatted as a single text string. The string will be formatted with parentheses at the beginning and end of the string. The main body of the string will consist of the individual text records (referred to as “search inputs) placed in the order that they appear in the file, and with each input separated by a comma.
As an example, the first five records posted above would be combined into the following text string:
("Killed by Roses", "Wasmuth Portfolio Frank Lloyd", "Daniell's Oriental Scenery", "Miller Five Ring Circus", "Official Ferrari Opus")
The only difference between the above example set and the actual sets to be be delivered is that the actual sets will each be made up from 75 text records (rather than the 5 text records used to create the above example set).
The final deliverable will be either a Notepad file or an Excel file containing the 85 completed sets. This project includes the following two attached files:
* An Excel file containing the 6375 text records to be used as inputs.
* A Notepad file containing the first two completed sets (to be used as examples for generating the remaining 83 sets).
Related categories:
Data Processing
Data Entry
Excel
Word
Scripting
Data Analysis
Automation
Data Management