Đã Đóng

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

Kĩ năng: Regular Expressions

Xem nhiều hơn: 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

Về Bên Thuê:
( 4 nhận xét ) Bahan, Israel

ID dự án: #18183182

4 freelancer đang chào giá trung bình $128 cho công việc này

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 trong 3 ngày
(1 Nhận xét)
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 Thêm

$100 USD trong 1 ngày
(2 Nhận xét)
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 trong 3 ngày
(0 Nhận xét)
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 Thêm

$222 USD trong 3 ngày
(0 Nhận xét)
0.0