Delimited data jobs

We need to extract data from a SQL datbase , we will require the following patient demographics for 2 seprate doctors • Name (First, Last, Initial) • Address (City, Province, Postal Code) • Email Address • Home Phone Number • Birth Date • Last Date Seen It must be an electronic list saved in one of the following formats: • Delimited Text • CSV • MS Excel • MS Access format

I have an accounting software (php mysql) that imports data from various sales and purchase invoices. Import txt file, delimited by pipe. What I want now is to replace that process, so that the comma delimited CSV file can be imported. (the txt and csv columns are different, that means changing the javascript parameters) Please review the following video that explains it, before applying to the project:

... All of the data collected is saved to a file (or database) on the phone and there will be an export button in the app to allow me to export the data to a text file using ASCII delimited format. When I click the export button, the app stops listening and recording, and begins the export procedure. The first line of the export file will list the field names separated by a pipe character (|). Then each subsequent line in the file will be the data containing all fields separated by a pipe character (|). Once the data is exported, the app will ask me if I want to delete the data which I just exported, if I answer yes, it deletes everything that was in the file (database). Android phones also have sensors, which capture body information. If this sen...

I have some scripts to convert csv/txt to xlsx, xls to csv/txt and txt/csv to txt/csv The script use delimited characters optional and can process single or multiple files in a directory. It was workingfine and now I have these errors: "WARNING: pip is being invoked by an old script wrapper. This will fail in a future version of pip. Please see for advice on fixing the underlying issue. To avoid this problem you can invoke Python with '-m pip' instead of running pip directly. Name: XlsxWriter Version: 3.0.3 Summary: A Python module for creating Excel XLSX files. Home-page: :" And the prompt is returned without store the converted files.

A Windows application is required to manipulate the contents of some space delimited text files Reading from One Folder and saving / Moving converted file to another See Attachment for Spec.

..."Adult Data Set") from the UCI Machine-Learning Repository we can predict based on a number of factors whether or not someone's income will be greater than $50,000. The technique The approach is to create a 'classifier' - a program that takes a new example record and, based on previous examples, determines which 'class' it belongs to. In this problem we consider attributes of records and separate these into two broad classes, <=50K and >50K. We begin with a training data set - examples with known solutions. The classifier looks for patterns that indicate classification. These patterns can be applied against new data to predict outcomes. If we already know the outcomes of the test data, we can test the reliability o...

...contains a single record with the following columns, in order: • Id of the order placed • Area where the order was delivered • Name of the product • Quantity of the product delivered in that order • Brand of the ordered product Create is the name of the input file given in the input including the .csv extension. Each file must contain r rows where r is the number of distinct products. Data should be comma delimited, and the row order does not matter. The structure of each file is as follows: 1. 0_input_file_name - In the first column, list the product Name. The second column should contain the average quantity of the product purchased per order. 2. 1_input_file_name - In the first column, list the product Name. The second column should be the most...

i need someone to write a powershell script (.ps1) that will convert xls file to a tab delimited text file. i will schedule a task in windows to run that script once a day. i only need someone to write the script. i already know how to schedule the task. the location of the file will be C:Keystrok and the converted file will also be saved in the same folder.

Project is to write a PHP function to return a list of avaiable timeslots (with adjustable timeslot size). The inputs are a comma-delimited string of availabel hours, an array of taken timeslots (may overlap), and a slot slize in minutes. Function should return a list of timeslots as an array in the same format as the taken timeslots input (but with every slot being the specified length (slot size in minutes)). Here is a sample of how a usage of this would look: $availableHours = "08:00-09:30,11:45-12:15,15:00-15:30,18:00-23:00"; $takenSlots = array( [ 'timeStart'=>'08:30', 'timeEnd'=>'12:00' ], [ 'timeStart'=>'12:15', 'timeEnd'=>'21:45' ], ); $slotSize = 15; // in minutes...

Need a software that works like print merge. As I am currently using COREL DRAW, but it takes lot time to convert it to pdf. Faster solution is MS WORD mail merge but it is not fluid as COREL DRAW. The COREL DRAW takes around 1 and half hour for 2800 pages to completly merge the .csv or .txt(tab delimited) file to design and again convert it into pdf. For processing 2800 pages twice, first merging then exporting to pdf will consume my whole 256 GB of RAM. where as The MS WORD takes around 5 min and can works on 4 GB RAM pc but with some less fluedity.

Need a software that works like print merge. As I am currently using COREL DRAW, but it takes lot time to convert it to pdf. Faster solution is MS WORD mail merge but it is not fluid as COREL DRAW. The COREL DRAW takes around 1 and half hour for 2800 pages to completly merge the .csv or .txt(tab delimited) file to design and again convert it into pdf. For processing 2800 pages twice, first merging then exporting to pdf will consume my whole 256 GB of RAM. where as The MS WORD takes around 5 min and can works on 4 GB RAM pc but with some less fluedity.

- Lite weight AI model to process video feeds - Should be able to run on lite weight hardware - Input methods (RTSP feeds, Video folders, Single video files) - Formats (all commonly available video formats) - Output - comma delimited Data Stream , CSV file - Detections to be done from the video 1. unique people count , no double counting, take care of the occlusions (i.e people crossing across) 2. detected people direction 3. Gender Important Note : This is a small project. Budget mentioned in the post is what it is. Those asking for budget to begin with will not be considered.

we have delimited txt file +- 400 rows by 12 columns (of invoice data) that we need VBA to -fetch and drop into temp tab -parse the rows into format tab ensuring alignments formats etc attached is png of before and after we do this allot and are looking to outsource these. you should budget 6-8 hours to do this well (4 hours will get it done but not tidy) you need to be used to parsing txt files with vba

Title pretty much says it all. I am new to FMP 19. I just need to take a selected record and export the data in a tab delimited format with a header row of the fields

SAMPLE DATA =========== Model (YOLOX): (and ) -> Test image: (see uploaded files here) Analysis done with YOLOv7: !python --weights --img-size 1344 --source ... --save-txt Results (see uploaded files here): as text: image: TASK ==== Inference with C++ ------------------ Remark: Only use OpenCV via vcpkg, no other libraries are allowed. (You can ask if you want to use another library.) 1) Setup a concole C++ Visual Studio 2022 project (or Embarcadero C++ Builder 11 project). No cmake! 2) Use *.onnx trained model from above 3) Calculate images from above with CPU, show results (rectangles around objects found), save results as tab-delimited text file 4) Results have to

Please Sign Up or Login to see details.

Milestone #1 ($50) (1) Project initiation Milestone #2 ($100) Custom watchface for Galaxy Watch 5, based on the attached mockup, and featuring: (2) 24 hour analog outer ring (3) A single hand that moves smoothly along the outer ring every minute (4) Ability to add an arbitrary number of milestones at specific times. For the first milestone, these times can be hardcoded, perhaps with a comma delimited string (e.g. “8:00,17:00,00:00”). However, wherever it’s coded, it must be easily accessed, updated, and reloaded by future developers. (5) A supplementary digital readout of the time, in hh:mm:ss format, that will automatically appear above or below the pivot in order to avoid overlap with the hand. (6) Bright and dark modes (7) An aesthetic and layout closely m...

I have 5 backup Ebay Turbo Lister files Each backup has two files, a .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 it had been exported Turbo Lister. I need this done to import the CSV files into SixBit software. There are approximately 400 records for each backup, thus, a total of 2,000 records

Need assistance in creating a VBA macro using combination of excel and tab(delimited) files. Need a common macro for that.

Hi! My father created a family tree with a lot of notes, but that was in the 1990s and the file format is old. We have a GEDCOM file, but it doesn't properly upload to so it's probably some ancient version of the GEDCOM format or may have a tiny error. I have one .uds file and more usefully a tab delimited .txt file. I'd like a software engineer to read in one of these file formats and process it into a clean and modern GEDCOM file that I can upload to Ancestry.com. It should be a pretty easy and fun project. Thank you!

I need to make 2 python scripts. Both scripts must have JSON file as configuration file to define all the variables. First script is to copy column or multiple columns from source or multiple source files to destination file. In this case as sometimes these type of copies cause some columns ends with bad notation as exponential for example 4.5E34 is added also to ...values and search in a source file for other values, then that new values are copied to destination files that will be in output directory to avoid damages to the original files. Reports are made for this of the process found and copied. both scripts must run as python We can’t run exes for the security installed on system. Source files to be entered can be xls, xlsx, csv and txt tab delimited They are minimal...

...a script to convert from txt, csv, xls, delimited by character, txt delimited tab excel type file to xlsx. The way to add is to configure a txt file where are two options. First is by processing the all files inside a directory or if there is a special file (delimited by character) add them one by one. The configuration text would something as: directorypath=“any directory” - If empty this feature will not do anything and will be ignored. Empty means =“” This feature is for process whole files in a directory directorypathdelimitedcharacter= “⁓” - I used the character “⁓” to delimit columns but can be anything as comma “,” or pipe “|” or anything. If empty =“” will not use delimite...

SAMPLE DATA =========== Sample images are in the attached zip under CreatedImages The annotations are given in the text files Suppose data is in Google Drive under '/content/gdrive/MyDrive/SampleObjectDetection02/od01/' So start with an Colab notebook like: from import drive ("/content/gdrive", force_remount=True) dir = '/content/gdrive/MyDrive/SampleObjectDetection02/od01/' %cd {dir} TASKS ===== I) Training in Colab -------------------- Remark: This all has to be done in Colab. (For development you nust ahve a Colab environment on your own!) 1) Prepare data for use in training using a pretrained YOLOX model 2) Train model and show how to set the following training features: - selection of pretrained model (YOLOX-s, YOLOX-x

I am converting word course workbooks to online courses. I am currently cutting and pasting into a course lms which is really inefficient. I need a script i can run between Word/google docs and/or excel/google sheets that converts doc content into delimited text to be imported into a spreadsheet. The text needs to be separated by the documents applied text styles ie Title, heading 1, heading 2, paragraph, para bullet list, para numbered list, figure etc so each style is a seperate field/ column when imported into excel. The document also contains text boxes, tables, charts and pictures, if possible is there a way to capture those as well. The content structure / list levels and associated paragraphs/tables/ images etc needs to remain in section group, order/ same row se...

C# code function that will process excel csv file delimited by comma but at the same time columns may contain extra commas .. so these extra commas have to stay as part of data

I’m looking to convert all fields within a JSON/JPRO file into a .txt (delimited) file using PowerShell. I have an existing PowerShell script that partially does this. However, it is missing some logic to loop through all the fields and is only getting the main categories and missing the subcategories. It is essential that the PowerShell script remains generic and is not hard-coded to retrieve any fields. The script will be used for other files with different column headings/data.

...using C# in Visual Studio 2022. Third party libraries are fine provided they do not require an additional paid subscription/license for use. For validation and demonstration of the solution, I have attached an input data set of 53,006 records, with tab delimited fields containing an item identifier, a reviewer identifier, and the star rating that the reviewer assigned to the item. The stars in the sample data range from zero to five, not one to five. Please allow the star rating to have decimal places if it would not overly complicate the implementation. The desired output data set would list the items and their calculated star rating, with decimal places. No GUI required....

I need to (batch) create PNG image mask files from a tab-delimited import file (or spreadsheet). I have a windows PC but I'm open to solutions that don't run on a desktop. We use Photoshop (Desktop) and we also use a windows server for our website so asp or aspx would work. Each row of the import file includes a file name (add .png for final image), image dimensions, and the coordinate positions and dimensions of the rectangular mask areas. 0x0 is defined as the upper left edge and the box positions are in relation to that position. The final image should be 72 dpi, have a transparent background and 1-2 black rectangular areas. Some images will only have 1 defined (rectangular) area. If the BoxHeight is 0 that box will not be included in the mask. As an example, the 3rd...

I regularly have gift cards that I need to check the balances for. I would like a script that can be run on a company's website that will check the balances on about 25-250 gift cards at a time then output a text file with the remaining gift card balances. I'm open to suggestions on implementation but the input data would come from an excel file. I believe the easiest method would be to first save the input as a CSV file. The output file could then be comma delimited and have a line for each checked gift card containing the gift card number, PIN and any remaining balances on the gift cards so that I can import it back to excel. This would be to check the gift cards for single company such as Gap, Sears, Lowe's,etc. If the program is satisfactory then I would ...

Please Sign Up or Login to see details.

I am looking for a python expert to build me a webscraping script that scrape online food delivery website: Web to scrape: Requirements: - Script must be written in python - Not a headless browser scraping, I want to get data from the browser api instead - Able to scrape whole country in one run - Scrape all restaurant and menu information (can be split from 2 stages, restaurant data from search result page, and menu from restaurant page) - Not get blocked by website owner, use a proxy if you need - output in newline delimited json Delivery output: - executable python script

...build a php script/or similar to automate my work. This is the job: Right now I can only look up 1 business/keyword at a time and I need to look up BULK business data fast. 1. Go to and open a free account OR look at my uploaded screenshots for better explanation; 2. I need a php script/or similar that I can put in a TEXT BOX my keywords and then when I click SUBMIT the script automatically generates the proper URL and open a NEW TAB in CHROME browsers with each keyword and performs a search for me; (30-50 keywords at a time / 30-50 CHROME TABS at a time) 3. That is it! I need to be able to paste keywords delimited with a space and 1 per line ie: "keyword1 keyword2". Right now I doing this manually by modifying the url manually with the keywords and then openi...

1) The indicator executes its alogo and ALL hits are written to the Output File. 2) Currently,...overwrites the content with the new results to the output file. 5) The change, I want:- 5.1) the original content not to be overwritten 5.2) Only the new HITS that are not already held in the Output file to be concatenteated to the end of the line 5.33) The Ouput File will only have a single line -- delimited by "/n" 6) Example:- - New Symbol hit "EURGBP;SP500" ---- New symbols must be added at the end. - All symbols must be on a single line - No duplication - All symbols delimited by ";" - Last symbol must be #S-BIDU - Last symbol has no delimiter. 6.1) Old line:- XAGUSD;SP500;Nd100;XAUUSD;#S-BIDu 6.2) New line:- ...

I've attached the details but I need a query that will read a pipe delimited txt file and compare 2 fields to 2 fields in the oltp oracle table then update the oltp oracle table description from the text file description when the 2 fields equal. Attachment explains it better and need this as soon as possible within an hour.

...rework the design. I know my list have lot of items and it's could be important to get a pretty nice page. Probably you will need to be creative to put all this on the same page and get a awesome user experience! ;-) This page > The major issue i'm looking to fix : - Better responsive view - The section of countries and provinces are not clearly delimited. We don't know where to start and where to end. - Add a Top trails section - Add a Top parks section - Add a Cities section (To display the most popular cities) - Add a FAQ section - Add a section to switch to another outdoor activties > ski, mountain bike, etc... And this page : You will can reuse some design part. The major issue i'm

Need a python expert who can work immediately . I want this done by the next hour ### 1. Retrieving TOKEN activity data using Google's Admin Reports API The desired result is a Python script that retrieves token activity events from the Google Workspace API. - The first time this script is run, we should collect events from the last 48 hours. - the results should be stored in a newline-delimited JSON file. - Subsequent runs of the script should resume collection from where the last collection left off. - each run should store its events in another newline-delimited JSON file. - we would like to ensure as best as we can that we do not miss any events between runs. - state can be stored on the local filesystem.

I am receiving load sheets in CSV format (Drupal format) and need to convert them to Shopify format. The main issue are images. For Drupal, the images are in one cell delimited by a vertical line | , but for Shopify multiple images for one product requires a separate line with the product ID and second image link. It is very time consuming to manually convert the files so I would like to have a macro or other conversion tool created to convert these CSV files. Example of the CSV I receive (1.58mb file) and example of a small sample of corrected CSV is attached.

Can we still add the file name to the other .txt files? Or add a record id? I'm looking for a way to keep the records unique (or at least within each imported json).

The project is to write a small application to read the JSON input file record by record and create the output file in the delimited format defined in the spreadsheet. There is some logic to be appied to calculations and an exclusion criteria but basically its a transformation of the JSON data to a delimited input format so that the data can be imported to an SQL92 database.

...and so on. (Drag and Drop to re-arrange the trip order) - Predefined first trip will be shown at the beginning to help data entry and subsequently added by user in the next line - Each trip will contain it's own trip id which is 1:1 mapped to Container # (user input) - Each trip will also contain Date, Location 1 to Location 2, Container Size (20/40FT) Remarks, Vehicle-Driver, Trailer #, Vehicle-Driver Predefined Docket Pay, Container #, Documents for each trip, Upload Document, Trip Status. - Hover over each trip will contain the uploaded documents and show details of the trip updated by the driver - Multiple Container # can be assigned to a single Trip, field-input delimited by space. - Assignment of Vehicle-Driver & Trailer (each trip will only have one vehicle...

... Two indicator variables that I change at each iteration. variables: Duration and Offset (strategy tester: Format: inputs) from their existing level I decrement down to zero /zero. see example 1 below. Each new variable pair produces new results under (strategy tester: overview) tabs of Net profit Percent profitable Profit factor With each iteration record these values to a comma delimited file .CSV, with each variable pair. Duration, Offset, Net profit, Percent profitable, Profit factor Can you give me a quote with this ? I put a minimal amount in the budget, as I do not want it to affect your quote. I will judge your offer relative to other offers. likely logic open file For d = duration to 0 step -1 move d to duration For t = offset to 0 step ...

Need a .net tool, that will take below input from a json file and execute A. Program to execute (.exe or .bat) B. Parameters if any (date, or any other delimited values) C. Schedule to run week day and time , can be daily once or multiple times

I mainly need to create two macro buttons to generate worksheets from other sheets, and then export them to CSV/Tab delimited files.

The grabber must import the following information: - short description - Description - further information - additional photos csv delimited by,

Dear colleague: I need your help with importing a new tab-delimited file into Postgres. It gives me ERROR: invalid byte sequence for encoding "UTF8": 0x89. I posted the input files here . Please let me know , if you can fix this for a fixed amount.

C:LitigationProductioninput: This is where files which need to be renamed are located. All files are named as follows: Original Petition_<7-digit suitKEY>. For Example: Original Petition_2564064 C:LitigationProductionoutput: This is where renamed files will go. The suitNUMBER will be prefixed to the file name: 202167501_Original Petition_2564064 : This is a semi-colon delimited text file which contains a {suitKEY;suitNUMBER} ​pair. PROCEDURE The script should read file, compare suitKEY with the name of the files in input folder. If the suitKEY matches the suitKEY in the file name, it should copy the file into the output folder and rename it by prefixing the suitNUMBER to the file name. If the scrip does not find a matching suitKEY for a file, it should copy the file

I have a SQL Server .BAK backup file. I need somebody to restore it and extract the contents of five tables into tab-delimited files with headers. Then deliver those files to me.

First of all I need to make clear that I want the actual macro so I can do this myself in the future if I need to and don't just want to result. I have an Excel document and want to move the contents of 7 fields from there to a different document (csv-delimited and this format cannot ne changed in any way). The fields on both documents will always be in the present order. From source I need column B (name) to Company in Destination, column D (street) in Address, column F (city) in City, column G (state) in State, column H (zip) in Zip, column I (phone_number) in Phone and column M (classification) to Tags. On Destination the First Name, Last Name and Email columns will stay blank. Please provide both the macro and the result using the examples in Source- thank you.

Report Printer with QR Image Purpose The motivation behind this project is that new regulation in my country demands that there is a QR image that contains invoice details. The current programs running in our company is dos based and will be difficult to add QRs with the government regulations into. Goal The program will take a tab delimited text file from a directory, The application should capture this text file and populate a report and put the dynamic QR into. And save this pdf to the system and send it directly to printer. Type of program Running as a service in the background with logging such as if error occurred, if file is found, etc …. With time stamps This program should be installable on many devices and have a conf file to specify some items such key and d...

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