Completed

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

DD/MM/YYYY

HH:MM (24 HR FORMAT)

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:
( 3 reviews ) Singapore, Singapore

Project ID: #22052525

Awarded to:

egg

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
(25 Reviews)
4.4

20 freelancers are bidding on average $109 for this job

P0L

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
(326 Reviews)
7.3
gangabass

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
(402 Reviews)
7.3
TonmoyRoy111

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
(344 Reviews)
6.9
onlinejob247

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
(127 Reviews)
6.5
adeelpirzada

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)
5.3
yashaswini510

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
(26 Reviews)
4.9
manwar4393

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
(86 Reviews)
5.4
writingapp

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
(21 Reviews)
4.6
AnowarRatul

$ 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
(38 Reviews)
4.3
alihaider5152

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)
3.3
billinhit

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
(2 Reviews)
2.6
languagedr

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
(5 Reviews)
3.4
SureshXobos

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
(4 Reviews)
1.2
rosemariebunagan

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)
0.0
$155 SGD in 3 days
(0 Reviews)
0.0
susanpallang

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
(0 Reviews)
0.4
richardsmith9ij

Are you crazy? What the hell are you talking about? The budget! Do you think it is reasonable? No one can do that within your budget. Furthermore, the project has got a PROBLEM needs to be considered. Anyhow that is no More

$400 SGD in 7 days
(0 Reviews)
0.0
piaohaofu

Hi, My name is Piao H. I have just read your job description and I am very interesting in your job. I am a Excel expert, expensive experience in Excel data processing, excel Macro excel VBA field. and I also have good More

$30 SGD in 2 days
(0 Reviews)
0.0
$155 SGD in 3 days
(0 Reviews)
0.0