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.
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
38 freelance font une offre moyenne de $284 pour ce travail
Dear trggopi, Greetings! Highly experienced with Excel programming,Please refer to your private message box for further details. Thank you.
We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.
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!
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)
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?)
I can do this for you - I've been using Perl since the early/mid 1990s (!) Please see my PM for further details