Closed

Read and sanitize data from the CSV file while using interfaces provided in the SRC directory.

# Summary

Your mission, should you choose to accept it, is to read and sanitize data from the `[login to view URL]` file while using interfaces provided in the `src` directory.

# Description

User supplied data is unknown and inherently cannot be trusted. .

# Setup

`composer install`

# Implementation

`[login to view URL]` and `[login to view URL]` classed provided are placeholders and should be populated. You are free to use any tool necessary to accomplish your objective. The only requirement is that `[login to view URL]` should run as is, without needing much, if any, modification. You can run `[login to view URL]` to see data manipulation and to verify your work.

### Classes

`Parser` class is responsible for interfacing with the `[login to view URL]` input file and _extracting_ its data.

`Filter` class is responsible for _transforming_ supplied file data values into sanitized values ready for permanent storage.

`Validate` class is responsible for ensuring sanitized values conform to the defined specifications below.

### Sanitation Specifications

Please sanitize `data/[login to view URL]` data according to the following rules:

* Column 1 = Account Number

Account number should be a 10 digit string with leading zeros.

For example, `12345678` should filter to `0012345678`.

* Column 2 = Account Name

Account name should be a string and should not contain any special characters, only alphanumerics and ` ` (space), `,` (comma), `-` (dash).

For example, `@Widget Co., Inc.` should filter to `Widget Co, Inc`.

* Column 3 = Transaction Fee

Transaction fee should be a number with precision of 2. Rounding is allowed.

For example, `$.201` should filter to `0.20`.

* Column 4 = Phone Number

Phone number should be a string formatted as ###-###-####.

For example, `1 (312) 555-1234` should filter to `312-555-1234`.

Skills: PHP, MySQL, Software Architecture, Javascript

See more: symfony 4 read file, csv file upload using php, fopen php output, fgetcsv, symfony read file, create csv file using php and save it into directory, read csv file using ksh, read csv file using python script, read csv file using adonet, import data csv file using dts wizard, read data csv file vbscript, read data csv file vbs, data csv file mysql database using aspnet, read process data text file using vbs, read data excel file using winapi, read data csv file insert mysql, read data csv file vba excel, read data csv file mt4, read csv file using ado, read csv file using vb6

About the Employer:
( 0 reviews ) Chicago, United States

Project ID: #23584450

8 freelancers are bidding on average $46 for this job

manaraga

Hello, I've just gone through job description carefully and am interested. I have rich experience in these fields. I am working in these fields for years, so I have enough confidence with these kinds of projects. I More

$35 USD in 7 days
(8 Reviews)
3.8
IshaqKN

Hi there, I'll write a Python script to format the data in [login to view URL] as per given spec and will save output to a new file ([login to view URL]). I'm expert in data processing inc regex and string algorithms. So More

$35 USD in 1 day
(14 Reviews)
3.9
turanskiserhii02

Hello, I have gone through the brief details mentioned on the job. I have done multiple jobs with Javascript, React,Angular,node.js, WordPresss,Python, laravel, Software Architecture which are the skills required to ge More

$35 USD in 7 days
(9 Reviews)
3.5
prsun000

Dear, hiring manager! Thanks for giving the opportunity to work for you. I am a fullstack web developer with rich experience in PHP/PhpOffice development. I can read the csv file and insert it mysql database according More

$35 USD in 7 days
(3 Reviews)
2.8
jsanahuja

Hello, I like this kind of projects so I have already implemented all you said. All in PHP and without any extra dependency. Execution result: [login to view URL] Contact me ;) Best regards, --- More

$50 USD in 1 day
(2 Reviews)
2.9
mikailsanginc

Hello, my name is Michael. I’m new to Freelancer but I have a lot of experiences in web development during my past company – RHEEM in Atlanta. Through 2 companies I’ve worked for web development for 15 years. Here are More

$35 USD in 7 days
(1 Review)
1.9
mandarvvaidya

I have FULL CONFIDENCE of completing this data manipulation coding challenge and I am ready to start IMMEDIATELY. I will populate both `[login to view URL]` and `[login to view URL]` files with relevant code so that the terminal helper More

$35 USD in 2 days
(1 Review)
0.7
Dephysics1

Let's not waste more time talking about what's needed to be done and actually get things done. hit me up and let's make ideas come to life.

$111 USD in 2 days
(0 Reviews)
0.0