Delimited datapekerjaan

the task description, SQL table template and the tab-delimited input data are posted here

Sila Dafter atau Log masuk untuk melihat butiran.

****Only accept this project IF YOU CAN START WITHIN THE NEXT 3 HOURS AND DO IT TODAY! *** Hi! I need a very basic prototype built. It can be CLI , doesn't have to have an interface. You can use Python, PHP, C# Inputs: A. Line delimited txt file containing URLS B. Threads C. Sleep between scraping. D. Maximum Timeout I only need the URLs to be accessed -- I do not need to save ANY DATA from them at all..... I only need to know if a URL fails. URLS will all be LocalHost urls. This is a very simple project, no bells and whistles, and I need it done TODAY. I am a Python / PHP programmer, I can walk you through any development today with you via TeamViewer. If you are an intermediate programmer in any of the above languages , it should take you no longer than 2-3 hou...

An app is required to manage a list of an artist's songs and cover versions by other artists. Song data is stored in a file; either delimited text format or object file e.g. jonimitchell.txt. A song is identified by a unique id and has a title & album also stored. For each cover version, the following data is stored: cover number, artist, and a flag to indicate whether or not it was a live version.

... URL-   There are 925 Data Sets/Records. Need to collect as much as fields you can. ***I NEED TO collect all fields. I can send a Google sheet url which contains fields. **** This includes scraping some information from multiple pages (pagination), and following links to reach additional pages with more information to collect. Generally, this means going to the base URL with a "list" of links, following a link, collecting information, going back to the original "list", following the next link, and then moving on to another set of links when the list for that pages has been exhausted. The data is part of the links that are included under the heading "Find the right data for your business" on this page: The code

I need an application to view and graph all Log files, or any delimited file for that matter. It will graph any field and be able to analyze data, they will automatically be detected and available for view and display. There is a few app like that in the market, but we need to build our own. I attach some screenshots to give a better idea of what we need.

...  There are 925 Data Sets/Records. Need to collect as much as fields you can. This includes scraping some information from multiple pages (pagination), and following links to reach additional pages with more information to collect. Generally, this means going to the base URL with a "list" of links, following a link, collecting information, going back to the original "list", following the next link, and then moving on to another set of links when the list for that pages has been exhausted. The data is part of the links that are included under the heading "Find the right data for your business" on this page: The code should be written in Python. The data collected should be written to as standard delimited form...

I need to create PDF invoices created dynamically from Java and crystal Report. The Program will be a service that will be running 24/7. The program should create QR images from the fields and send the image to crystal report dynamically This service will take the invoice fields from a text file and send them to crystal re...need to create PDF invoices created dynamically from Java and crystal Report. The Program will be a service that will be running 24/7. The program should create QR images from the fields and send the image to crystal report dynamically This service will take the invoice fields from a text file and send them to crystal reports to print as pdf and send it to printer. The text document will be tab delimited with fields such as company name , company email , produ...

I need to collect information from a specific website. This includes scraping some information from multiple pages (pagination), and following links ...collect. Generally, this means going to the base URL with a "list" of links, following a link, collecting information, going back to the original "list", following the next link, and then moving on to another set of links when the list for that pages has been exhausted. The data is part of the links that are included under the heading "Find the right data for your business" on this page: The code should be written in Python. The data collected should be written to as standard delimited format. Code will be delivered on completion of the project, and should run from at least a com...

I need a PHP or Python script which will be run periodically to scrape the data I describe in this project and store it locally in a MySQL database running in a typical LAMP environment on a Debian 11 server. The script should start by emptying the table to be used (TRUNCATE), the populate the table only with the results of the new data scraping described in this project. The source data is on a public county GIS mapping server and is strictly limited to the owners of property in the subdivision for which this script is being written. Currently, we do the very tedious work of manually updating our data. To get to the data I need manually, I use these steps: 1: Open web page: 2: Use the Search Field and enter "Upper Little Warm Spring Creek"...

Files will be pushed to Landing area i.e. ADLSGen2 1. ADF Evenbased trigger need to copy file from Landing to Raw layer land Log the telemetry in sql table. 2. Azure Function (python) for File Health check: file meta data will be available in ADLSGen2 as key value, Function should read the metadata and check the file health and is that following metadata or not, then write back health details to SQL Table. I will complete details and requirement document.

...user members area after login that when clicked will show all messages that require his attention per below: 1. see screenshots ( ignore API imports if you do Google BCC) allow the user to upload his own contacts and assign tags to these contacts under my contacts. Allow the user to Broadcast or Fw the transactions to the contacts he selected . manual upload or via text file ( specific Tab delimited format ) all import each email  with first name last name Email Phone ( email required)and user must assign a tag for it or general All user to remove or edit a contact when showing in his interface See screenshots 2. Add the word Broadcast/Next to Forward this transaction See screenshot 3. for each transaction create additional column called: Inquiries History that wil...

We are in need of someone to help us create a macro transform excel spreadsheets. The spreadsheet will have a series of lines. Based on the contents of each line, we need to create anywhere from one to five lines on a different sheet in excel. A sample format is attached. The deciding field in each import line is UD2. It has a pipe "|" delimited value. Each value between pipes means a new line in the "export" sheet needs to be created. If the value is 0, a line does not need to be created. Format: {internet}|{wifi}|{tv}|{telephone}|{other} Example A: 550|25|150|200|400 --In this instance, five different line items would be created. (See example spreadsheet) Example B: 0|25|0|0|0 --In this instance, one line would be created in the export sheet. The remainde...

Take a look at www . xest . com / trymeon . php To see what's involved before bidding. This webpage is populated from an online game via PHP. I already have a function that can receive the data from the game and the game script can be changed to accomodate your PHP file. My current PHP file is just a proof of concept i can supply if required. PHP file to receive data from a call from another server. All listboxes to be listboxes not dropdown menus You will see from the link above the following: Your Try Me On Server Contents. (ListBox Right hand side of page) This ListBox is populated from the users data from MongoDB on page refresh. (I will complete) What i need in the PHP function: Demonstrate how to add an item in the listbox with a checkbox then text (It...

...script does the rest - displaying output to the screen. I have included a test sample of the input and output. I have attached 6 files to be used to create and test this Windows desktop ap as follows. File A is my PHP script and files B-F are a single test case of input and output to verify the ap is working. Below: A is my PHP script. C is a test input txt file (made by saving B as a tab delimited txt file) read in by A. D is the output created by A for input C, saved as a chrome webpage. E and F are jpegs that show you what D looks like. A. is a Version 7.2.34 Architecture x64 PHP program that I wrote using Windows xampp. B. jobs with description - (Excel spreadsheet used to create file C.) C. jobs with description - (File A reads in file C and creates

need a script that will run on a mac that will read a text file (either comma or tab delimited) and change the value in one field by merging it with values from 2 other fields. so basically ... read each row... capture the value of 3 columns... build a new string of text... and rewrite the value of one column with that new string... and do this for each row in the text file script should be easy to modify user needs to be able to easily define the text file for the script to run on.. so a simple gui... also ideally would like to be able to change the script ... so not something compiled

I need data extracted from an MS Access 2007 (.mdb) used by ZKTeco, not all data are extracted, only select columns from different table. What I require: 1. Script needs to be vbscript (text-based, executed by Windows ). 2. Script should have option to fetch data based on specified date/hours/minutes at runtime. 3. Script should have option to specify the location of the database at runtime. 4. Script output is text-based (.csv). 5. Script is NOT obfuscated for checking and validation by IT Security group. 6. Script does NOT require custom app/3rd part apps to run. Should be running on built-in Windows 10 with NO helper files/DLLs required. 7. Script can be run on local user account only, no Administrator rights required. Script should run on PC with: 1...

Hello, I need an architectural drawing (3d style or not), to illustrate our construction project. It's a tennis center. We don't need interior views for now (maybe in the future). The black rectangle are 9 meters high buildings (3 floors). You can see the entry of the big building, make it class. :) There is als...future). The black rectangle are 9 meters high buildings (3 floors). You can see the entry of the big building, make it class. :) There is also a terrace (=terrasse), add some umbrella. Finally, add some solar panels on the roof, and a bar rooftop, the siez of the terrace but on the roof. Add some people playing tennis on the outdoor tennis courts and the fence around. On the 2nd picture, I just delimited where there are windows on the buildings. It will be co...

This website contains links to score summary data for the STAAR test given to Texas students in every year from 2011-12 to 2020-21: Each link goes to a page with data summarizing students' test scores in different grades and subjects for the given year. I would like you to download all the data in comma-delimited format, at the school and district level (not the state or region level). The data files will have the suffix .dat. Please change it to .csv. In addition, please download, in text format, these files describing the variables, formats, and descriptions: Again, please change the file suffix .dat to .csv. Please

PYTHON PROGRAM TO REFORMAT DATA Deliver a Python program to reformat two types of data-file. One type is in text format, lined up in columns; the other type has lines that are strings of words. Reformat both types to comma-delimited files in .csv format. Test the program on two data-files, one of each type. Return the Python program and the csv-format files. This completes the Milestone stage. When that has been agreed, run the Python program on 26 files, reformatting them all. This is the ProjectCompletion stage. Data: - The two files to be reformatted are in the Reformat/Milestone directory (see Attachments). They can be read by a simple text editor, and contain only ascii characters. - The returned csv-format files should use only the comma as a ...

Sila Dafter atau Log masuk untuk melihat butiran.

I have a multirow input javascript calculator, that takes input from rows of comma-delimited inputs. There are 12 inputs. There are about 30 output values, but I want to reduce the number. I would like to simplify this into a 1-row input calculator, where the inputs are more akin to a classical calculator. Needs to be formatted to be responsive, so accessible via mobile.

...empty). This will hold checkboxes and must work like the "Access" box/process but it doesn't need any JS to trigger when clicked. - New data set will be provided. - added the name of the "From Type" name to the Final string after the @ delimiter (ex: @558) - added the ID for "Reason for Request" at the end of the Final string after the @ delimiter (ex: !558) - "Final" string is stored in a simple SQL Server table. Needed changes for v2: - when the page loads, check if there is an ID passed in (ex: id=3). If not, the current process works fine and can remain unchanged because this is a new entry. If there is an ID, it needs to get the corresponding delimited value from the database (I will include database objects), load ...

In Tableau: Use a tab delimited file and create a bunch of insights / charts / graphs / calculated fields / business relevant info. Must complete in next 4 hours… by 9 PM CT = 2 AM UTC. Will pay $100. Must have a bunch of valuable business insights with charts / graphs in Tableau. Bonus Tip is possible if really good insights / data science analytics are done.

Need to write a very simple script to parse a simple semicolon delimited .CSV data file and calculate averages of its rows. I'm running MacOS and would like to run it as command line script under MacOS shell terminal. It should look something like this: #parse_data_and_average This is sample data from the .csv file: 005d4034-0000-0000-0000-000000000000;2019-05-08T00:36:38.0340266;2019-05-08T00:36:38.0340266;5874;0.464359;5873.21;0.97753 005d4034-0000-0000-0000-000000000000;2019-05-08T00:36:38.0760000;2019-05-08T00:36:38.2273925;5873.98;0.242696;5873.22;0.5 004ad5c8-0000-0000-0000-000000000000;2019-05-08T00:36:38.0831033;2019-05-08T00:36:38.0831033;5874;0.464359;5873.21;0.97753 005d4034-0000-0000-0000-000000000000;2019-05-08T00:36:39.0820000;2019-05-08T00:36:3...

I am wanting to do a s...the second image and respond as described above. This sequence will continue until the participant has responded to 20 pairs of images. After the participant has responded to the 20th pair of images, an end of program image (”End_image”) should appear on the display. The participant’s “Participant Number,” their response, and response time for each pair of images should be stored as a comma delimited .txt file. The fields in the file should include “Participant_number”, “Time_1”, “Response_1”, “Time_2”, “Response_2”, …“Time_20”, “Response_20”. After the file is stored, pressing “Enter” should cause the program to end. I w...

We have a need to read a Pipe delimited file and move it to a Record in cobol. Code is needed that can be reused on many different files. The code should be created using COBOL 85 Standards. The files are pipe delimited.

...It will then sort the email addresses according to a specified list of mx records or based on other criteria. Kindly note that the email addresses are all mine and software is for educational purposes. Linux based or Windows based app, Any development language is acceptable. similar app: Here is an example senario: I have a list of email address delimited by new lines, say 200,000 emails. What the app would do is in two ways. One, I will browse to the .txt file that contains the email using the app to either load the email list into the app or point it to the source. Then the app will have to dig for MX record of each domains of the email and sort them according to their output different MX records. I have about 12 targeted MX records under which

...project you need to be familiar with a .NET Core file and its format. The requested PowerShell script needs to be able to add /edit/remove any element on any level of a file This PowerShell script should prompt the user to enter parameters like - Location of the file or path - Information about the element that needs to be altered. The way I see it is a pipe delimited string where the script needs to dig through the different levels using the pipe as the splitter between level - information about the value of the element that needs to be added or updated. - Ideally the script should allow user to enter multiple elements to alter using a [HashTable] object as parameter to hold the element keys, values and action (add/edit/remove). ...

Below is the conditions Taking the file as an input, export a csv that has the below columns vmname owner environment OS roles applications custom_grains The field will be derived by: vmname: salt-name owner: [platform, bussys, ...applications == bussys*, bussys find pattern for most devops find pattern for most prodops if nothing, owner is orphaned environment:which pillar is this OS: if name contains '.' windows roles: applications: custom_grains: a concatinated text list of the custom grain pairs. thing1:stuff thing2:otherstuff thing3:morestuff always lowercase space delimited General: all field other then name: should be lower case. use '_' instead of space or comma no symbols other then _ are allowed no icinga grains

Hello. I have a comma delimited data file WITH double quotes as a text qualifier. I need a T-SQL Script to import this data file as I will be receiving these on a regular basis in the future. Text qualifier is important because the PARTY field contains names with a comma: "SMITH, JOHN" Sample is attached. I need this within the next few hours if possible.

- I am looking for someone who can set the setting to import the csv file delimited by | I can safely import xml files, but not those in csv. I need to import csv - cron for automatic csv file download

I have an existing program written in Delphi that is outdated and needs to be redone or recompiled , so it is compatible with Windows 10. The program is designed to read inbox from a POP3 account and forwards the message to group of recipients based on the subject line ...address should be different for each group" - Need setting for POP3 (SSL, TSL, PORT) - Setting how often to check pop - Need setting for SMTP (SSL PORT) - Program needs to be nice GUI - Program should have option to display log, for example every time it checked pop, if there is message to send to group, and display when sending to which recipient its being sent) - DB I want should be a coma delimited (for example Name,Email,Group1,Group2,Group3) These are the options in a nut shul, feel free to ask any que...

...environment over 5.0) and there is one major monthly task I must complete with it. Every month we receive a prospects list from a business partner in an Excel workbook- between 8,000 and 15,000 records. Data entry originally performed by simians. The data I receive is fairly messed up; data in incorrect fields, data badly formatted, bad phone numbers, convoluted first/last names. It takes me about three hours to prepare the spreadsheet to be entered into a special Access DB I created for the purpose of automating the remainder of the task which is supposed to allow me to import a tab-delimited text file into our database in the cloud. This second part takes a lot of time also as it all requires human eyes to distinguish between a true middle name, or a...

I need someone to create a very simple react.js code to read a file from a local drive and parse the data and create a JSON payload of that file. The file is a comma-delimited file with the first row as a header. The file has only three columns. Please use papaparse. The UI doesn't need to be pretty, all it needs to have is a button to load the file, a progress bar to show load completely, and a text box to show the JSON payload. Ref:

This is not a programming task. Just a single text file delivery. We need a unicode-type Arabic text file (.txt type) containing all Arabic words (root and non-root words) found in a public Arabic dictionary or thesaurus. Words can be separated by comma (comma delimited) or space or whatever you see appropriate. Basically required is a digital copy of the Arabic words found in an Arabic Dictionary or Thesaurus. Expected file size ~10MB or more. You might already have this file or need to recreate it from existing dictionary.

Need someone to change the code a little to read the comma delimited ta from Sd card and split them into 3 integers which I can then use for my servo. In playback this will be the output per line "203,202,200" coming from the SD card. I want to have this split in 3 variables which I can use as position for my servo. Who can add that code? See this url:

I have a CSV file I need to submit to a third party and they only accept the format of XML or TAB Delimited File.

We have sales data in text files delimited by pipe (|). There are about 20 files for sales of each month, the files contain about 30-50k rows each and 20 columns. We need all that data converted into a single Excel in separate tab per month, and then some Key Performance Indicators extracted from it, like most profitable product, product category with most turnover and a few others. Also around 10 charts need to be generated on the sales data to represent growth/decline in sales and profit. We are open to suggestions for chart representations.

..."duedate": "2021-06-10T07:00:00.000Z", "text": "CAI", "where": "zoom" }, { "customer": "Flavio Soarin", "duedate": "2021-06-11T00:00:00.000Z", "text": "121" } ] In other words, the parser output an array whose elements starts with an minus sign at column 1 Each element (record) is composed by text and zero or more attributes Each attribute is delimited by an hash followed by the name of the attribute (attribute names have variable lenght and must be an input of the parser!) Attribute value starts immediadly after the attribute name and ends at the first whitespace (either space, n, r or t) If the attribute...

I require someone to build an AWS Glue job that takes a parquet file from a s3 bucket and copies the file to another s3 bucket after doing some transformations. The transformations are not overly complex, the SOURCE S3 Parquet file will have a column that contains a string delimited by comma. This comma separated string just needs to be broken down into separate columns and the new file copied into a TARGET s3 bucket. The Glue job when triggered should only load new parquet files ( I am assuming using Job bookmarks ) Two same versions of the AWS Glue Job must be built - one using Python Shell and one using PySpark. So that i can learn the differences. Code for AWS Glue to transform and copy files using Python

Would like an Excel spreadsheet with Name, Company, Address, and Email address for active Certified Financial Planners in Arizona. Spreadsheet should be in a comma delimited or tab delimited Excel format.

The file in the CSV has data for example - Column 1 Column 2 Column 3 Column 4 Column 5 Column 6 ...... Column X id 1 A X, Y, Z <NULL> B L, M id 2 C O, P <Null> D Q So the output in pipe text would be : id 1 | A | X id 1 | A | Y id 1 | A | Z id 1 | B | L id 1 | B | M id 2 | C | O id 2 | C | P id 2 | D | Q The actual sample data is attached. Sheet 1 has data and sheet 2 has the output ( but this output needs to be in pipe format )

i have a backup turbo lister file when it backs up it produces 2 x files .tlb and .imb files i want you to convert the them to CSV file comma delimited i want the converted CSV file exactly as if i had exported the file from turbo lister to a csv file in the turbo lister program the reason i need this done is because turbo lister can only export 200 files at a time my file consist of 17,000 records

...New Customer, fill in customer info and choose the tasks and price. Sum the prices for total. Print the form, send confirmation email to the customer. Save data in database. 2) Edit the form, input the name, or phone, or the email address and bring back all customer data input at step 1) and repopulate the form and allow changes on the tasks and/or prices. Save it. Print the form, send confirmation email to the customer. Save edited data in database. 3) Create a new customer, the form should be completely blank when New Customer is selected. Go to step 1). Next, prep the Customer Data (only) for export to Excel, comma delimited (CSV) and export on demand. I don't need the tasks exported. They will continue to reside in the databas...

Hi Ivan, I'm hoping that you are interested in working on my project again. You delivered a python script for a previous project which I am looking to modify. I only want to the "objectClass: nsManagedMailList" entires in the LDIF file to be in the CSV. There's also a another change regarding the "Members" column. If the "M...that you are interested in working on my project again. You delivered a python script for a previous project which I am looking to modify. I only want to the "objectClass: nsManagedMailList" entires in the LDIF file to be in the CSV. There's also a another change regarding the "Members" column. If the "Members" entry matches a value in the "List" column then add it to a new column &qu...

I'm a researcher who's building a database of manufacturers. This website has all of the data that I need: I need someone to scape this website and to put the data in a delimited file that lists: Manufacturer name Specialty/focus Founded date (year) Founded name(s), if provided Country Notable module Website Specifically, I'd like to be able to import these data into a spreadsheet, where each row is a unique manufacturer. Thanks!

Parse and pull certain attributes and their values from the LDIF file, remove some characters and words, and add delimiters (CSV). Skill and language preference is up to the freelan..."HIDMEM" add "STEALTH" to column D "Visibility" (all other values add "FULLVIS" to column) Parse "mgrpAllowedDomain", if present add "TRUE" to column E "Internal" (if not present add "FALSE" to column) Parse "mgrpRFC822MailMember", for each value add to column F "Members" (semi-colon delimited for each) - remove any characters between "" and the symbols "<" and ">" and spaces (intended to only capture SMTP address, see example) Parse "uniqueMember", for each...

I want to convert excel file to CSV ; (semi colon delimited) using macro, i would also need code

Develop a script for accessing Big Commerce API ver3 to extract product data that create Google Feed with all necessary fields according to Google Feed Specifications (txt tab delimited) Develop using PHP, Python, or advise which language you would use.