Closed

Regex function - parse a column of values

I have a column containing around 8000 of values

The column describes a volume of alcohol bottle.

The job is to parse the column and reduce to new columns:

1. Clean volume

2. is no. of bottles >1

For the cleaning regex there are several rules but it easier to show an example of the first 100 values,

I attached an example of the parsing in the attached file

The output should be a file with the 2 columns filled.

This is a onetime run no need to build a tool to auto run it - once the data is cleaned i release the payment

Skills: Regular Expressions

See more: script fetch particular column values csv file perl, sum column values target excel, excel parse column, regex for csv file extension, regex csv column, csv regex java, regex parse csv with quotes, regex extract csv fields, alteryx split function, alteryx split string formula, regex validate csv, function calculate pip values mql4, excel vba copy column values, parse column csv file using php, excel assign rank value based column values, parse column csv php, column values loop php, duplicate column values excel, parse column wise csv file php, sql function parse icalendar

About the Employer:
( 4 reviews ) Bahan, Israel

Project ID: #18183182

4 freelancers are bidding on average $128 for this job

aki003iitr

I am a data scientist and data engineer with more than 4 years of programming experience in Python and have proficiency with using regular expressions.

$100 USD in 3 days
(1 Review)
3.0
gangabass

I can write a simple script that will parse your column and generate another Excel column just like you want. It will process all 8000 values you have. I can complete it in 5 hours and all I need to start is your so More

$100 USD in 1 day
(2 Reviews)
2.7
cemalkendo

Hi, Sample does not provide data for 2. Col but if there is 70cl x 8 than first col is 70cl and second is 8>1=true lets make it done.

$90 USD in 3 days
(0 Reviews)
0.0
siddyy7777

I am new here and looking for these kind of jobs which i can do it and trust me once given the responsibility i won't disappoint [login to view URL] consider me for this project it will help a new comer like me on freelancer to More

$222 USD in 3 days
(0 Reviews)
0.0