Write a simple batch file or script to convert excel raw data timestamp to proper formatted data

Looking for assistance creating a batch file or script to run against an excel document to particularly convert a field of raw data as such:

"Sat Aug 03 08:54:48 SGT 2019"

Into 2 separate fields resulting in



Excel file dump has hundreds and thousands of records, almost impossible to do this manually on a frequent basis.

Skills: Excel, Visual Basic, Data Processing, Data Entry, Software Architecture

See more: sqlserver write file script, free script convert sign file, write simple email backup script, batch file script access update, upload convert flv file script, write simple excel program, batch file script, imagemagick batch file write log, excel vba write xml document file, script convert text file htm, script convert rar file zip, batch file script install, convert batch file powershell script, convert batch file autoit script, write simple pdf file, batch file convert text excel file, convert batch file shell script

About the Employer:
( 5 reviews ) Singapore, Singapore

Project ID: #22052525

Awarded to:


Hello, sir. I can do it for u, it is easy for me to do it. Can complete in 2 hours. Can start work right now. Thanks.

$30 SGD in 1 day
(33 Reviews)

18 freelancers are bidding on average $97 for this job


Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$100 SGD in 1 day
(361 Reviews)

I can provide you a simple VB function that will convert your raw data into two separate fields as you want. You'll get a working script in 2-3 hours for just 140 SGD.

$140 SGD in 1 day
(422 Reviews)

Dear client I can write a script for you which will solve the purpose. I understand the requirements. Please contact me. Roy

$80 SGD in 1 day
(370 Reviews)

Okay. I have huge experience in working with these projects. If you need sample work just send me a message. Waiting for your quick reply.

$250 SGD in 3 days
(130 Reviews)

$ 30 SGD Only ------ In just 2 Hours ------- Excel Data Management, VBA Macro Coding, Automation and Formula Generation Expert ---- I can create your VBA Macro script with a dedicated button.

$30 SGD in 1 day
(91 Reviews)

Dear Sir/Madam, I AM READY TO START NOW I have read your project details and I would like to work with you on this project!! . I have vast experience in web-based data entry work like data copy from the website and ma More

$30 SGD in 1 day
(89 Reviews)

Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL More

$80 SGD in 2 days
(39 Reviews)

Greetings for the day, i have done scrapping almost on Half of Worldwide web including eCommerce giants (Amazon, eBay, craigslist) News Feed, Social media websites, API's. I develop my own scrapers and Bots bas More

$175 SGD in 7 days
(21 Reviews)

Hello I will write a bash script for you so that the first column containing the Login Time would be separated in to two columns of Date and time. I am an experienced system admin and i can do this job in a couple of h More

$50 SGD in 1 day
(34 Reviews)

Hello, I am strong on nodejs javascript, and also worked on excel file using javascript. i suggest to use javascript to complete this project. I am ready to handle and confident of completing this project on time Pleas More

$61 SGD in 1 day
(4 Reviews)

Hi there, There's no need for a separate script. Just a couple of excel functions will do the trick. Trust me. It is a small task and I can do it in 5 mins.

$51 SGD in 1 day
(13 Reviews)

Hello, Thank you very much for reading my response. I read your requirement and I have a strong belief that I can complete it with quality. Freelancer is a big community and it's a bit confusing to choose the best. I d More

$56 SGD in 3 days
(3 Reviews)

Hi,Thank you for your job posting. I have read your job post just before. I can do your work using Python. I have a strong knowledge of Python, Django VPython, Jupyter, Keras, Flask, Python-OpenCV, Tkinter GUI... I More

$80 SGD in 2 days
(1 Review)

I read your project and understand it. I am interested to do your project. I will provide you complete work right at that time, you can hire me and trust me. My career thus far in data entry is extensive, as you see on More

$30 SGD in 3 days
(6 Reviews)

H there, I can help you on this project. Let's work together and I assure I will finish the project as soon as possible. Have a great day.

$200 SGD in 3 days
(0 Reviews)
$155 SGD in 3 days
(0 Reviews)
$155 SGD in 3 days
(0 Reviews)