Fermé

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

Compétences : Excel, Perl

Voir plus : 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

Concernant l'employeur :
( 0 commentaires ) Chennai, India

N° du projet : #1671812

38 freelance ont fait une offre moyenne de 284 $ pour ce travail

gangabass

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

250 $ USD en 0 jours
(155 Commentaires)
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 en 6 jours
(23 Commentaires)
5.9
srinichal

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

290 $ USD en 5 jours
(25 Commentaires)
5.8
SigmaVisual

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

350 $ USD en 10 jours
(20 Commentaires)
5.7
danielgpratidya

Hi, Let's do it now

250 $ USD en 1 jour
(59 Commentaires)
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 en 1 jour
(38 Commentaires)
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 en 3 jours
(21 Commentaires)
4.9
microk

Expert here.. Please check PM...

250 $ USD en 1 jour
(16 Commentaires)
3.9
manishadk

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

250 $ USD en 1 jour
(10 Commentaires)
3.8
hddh

I can do it.

250 $ USD en 3 jours
(3 Commentaires)
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 en 0 jours
(7 Commentaires)
3.3
afua23

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

250 $ USD en 2 jours
(8 Commentaires)
3.2
shagoon2u

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

250 $ USD en 0 jours
(3 Commentaires)
2.9
devctang

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

250 $ USD en 2 jours
(1 Commentaire)
2.7
lokeshk9936

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

250 $ USD en 2 jours
(3 Commentaires)
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 en 3 jours
(2 Commentaires)
2.4
ALSOFT10

Sir, Please check your PMB. Regards, ALSOFT

250 $ USD en 0 jours
(2 Commentaires)
2.0
vineetpmishra

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

250 $ USD en 1 jour
(1 Commentaire)
1.8
lifeiseasy

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

250 $ USD en 1 jour
(1 Commentaire)
1.1
moussa1

I'm ready for this project

250 $ USD en 1 jour
(1 Commentaire)
1.0