Đã Đóng

date and time extraction from excel text parsing

I have a excell file which has a specific column of text which contains date and time information as a text data-there could be other irrelevant details like names of people. The task is to extract valid date-time from the cell text and store the result as a valid date field in the adjacent column with column name as "valid date"--this request parsing text cell.

Example

Input date format (similar data will be each row for this column)

"Posted/Updated Wednesday, May 30 17:14:43, 2012"

Expected output to be extracted

a) valid date in extracted to adjacent column

b) valid Time extracted to the next column

c) rest of the text snippet is saved in the the third column as text

d) the original column is left as it is

Kỹ năng: Excel, Perl

Xem thêm: excel parsing date text, parsing input, date time extraction, text parsing, row b, date, data extraction and input, excel contains, cell names, excel specific, excel row column, perl rest, excel column row, excel format cell, excel cell format, excel cell, text row, parsing text perl, column text, perl extract data excel, perl text extract excel, format cell, excel text column, column row excel, date extraction

Về Bên Thuê:
( 0 nhận xét ) Chennai, India

Mã Dự Án: #1671812

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

gangabass

I can do this for you. See PM for details.

$250 USD trong 0 ngày
(155 Đánh Giá)
6.0
Toperfection

Dear trggopi, Greetings! Highly experienced with Excel programming,Please refer to your private message box for further details. Thank you.

$250 USD trong 6 ngày
(23 Đánh Giá)
5.9
srinichal

I can deliver the project as I am an expert in such automation projects

$290 USD trong 5 ngày
(25 Đánh Giá)
5.8
SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

$350 USD trong 10 ngày
(20 Đánh Giá)
5.7
danielgpratidya

Hi, Let's do it now

$250 USD trong 1 ngày
(59 Đánh Giá)
5.4
nagybatonyi

Such jobs are my daily practice. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Please, see PMB for a draft solution. Regards!

$250 USD trong 1 ngày
(38 Đánh Giá)
5.3
ineedWorkJob

Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve, for more info please cheek your message box for this project(Private)

$250 USD trong 3 ngày
(21 Đánh Giá)
4.9
microk

Expert here.. Please check PM...

$250 USD trong 1 ngày
(16 Đánh Giá)
3.9
manishadk

Very easy job for us. please check PMB for details.

$250 USD trong 1 ngày
(10 Đánh Giá)
3.8
hddh

I can do it.

$250 USD trong 3 ngày
(3 Đánh Giá)
3.4
sofina2006

Hello Sor, I can do it. I think you set the wrong bid range... If you change it I can bid for less. Could you send me the excel file please? (or a subset of this?)

$250 USD trong 0 ngày
(7 Đánh Giá)
3.3
afua23

Very experienced data entry person here. I can do this job for you very well. Please see PM

$250 USD trong 2 ngày
(8 Đánh Giá)
3.2
shagoon2u

This can be easily fixed through excel formulas. Experts are ready to start immediately.

$250 USD trong 0 ngày
(3 Đánh Giá)
2.9
devctang

Only 100 USD in 1 day work. Pls check the PM/ 250 is too much.....

$250 USD trong 2 ngày
(1 Đánh Giá)
2.7
lokeshk9936

Hi, I am an expert text parsing with Perl. Please see PM.

$250 USD trong 2 ngày
(3 Đánh Giá)
2.6
roaima

I can do this for you - I've been using Perl since the early/mid 1990s (!) Please see my PM for further details

$250 USD trong 3 ngày
(2 Đánh Giá)
2.4
ALSOFT10

Sir, Please check your PMB. Regards, ALSOFT

$250 USD trong 0 ngày
(2 Đánh Giá)
2.0
vineetpmishra

Hi, I can do this. Please a chance to me. Please check PM. Thanks Vineet

$250 USD trong 1 ngày
(1 Đánh Giá)
1.8
lifeiseasy

Hi, my name is Maria. I can do this job for you.

$250 USD trong 1 ngày
(1 Đánh Giá)
1.1
moussa1

I'm ready for this project

$250 USD trong 1 ngày
(1 Đánh Giá)
1.0