Ditutup

5 minutes script, batch command on text or csv file -

I have downloaded scv file from google forms.

UNfortunately broken and need correction before useable.

Tasks which i do manually but want to apply by script. (script and incorrect file in same folder; output in same folder)

1. REPLACE NEW DELIMITER CHARACTER THAT MIGHT BE IN TEXT: "§" by "+"

2. REPLACE delimiter character "," by "§"

3. Replace correct linebreaks "^p "###

4. Replace incorrect linebreaks ^p by space

5. Replace Space before semicolon with comma space; ->;

6. semicolon and space with comma and space space -> ,space

7. changeback correct linebreaks "### with "^p (linebreak)

note that ^p is the sign for linebreak in word. I am not sure what is the code for that when you apply on text file

The final file need to have every line starting with the timestamp

Sample of incorrect file is attached.

Pls start your bid which "can be done immnediately" to ignore generic bids.

Thanks

Kemahiran: Excel, Scripting

Lihat lagi: create batch file to run command, batch file codes, batch file examples, batch file commands, how to create batch file, batch script, batch file tutorial, batch file output to csv, read csv file using python script, uploading csv file mysql php script, script import csv file database, csv file upload script, script send webform data csv file, script converting text file csv file, script web form posting csv file, windows script convert csv file text file, bash script add term beginning csv file, save text csv file php script, asp html form values save text csv file server, aspnet save form data csv script send webform data csv file

Tentang Majikan:
( 78 ulasan ) munich, Germany

ID Projek: #18971211

20 pekerja bebas membida secara purata $27 untuk pekerjaan ini

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Lagi

$50 USD dalam 0 hari
(659 Ulasan)
8.4
ScareCrow01

I think i can do it Thank you

$55 USD dalam sehari
(19 Ulasan)
4.2
shahinrahimi

"can be done immediately" I can help you with this. I have rich experience in excel and VB, and I do my best to save your time and pocket. Please feel free to contact me. MySkills: • Data Management ............. Lagi

$30 USD dalam 0 hari
(14 Ulasan)
3.5
senet

can be done immediately Hello, This is Prosenjit. I can write small PowerShell to achieve the goal. The prerequisite is: 1. PowerShell major version should be 5 Let's start to discuss further

$40 USD dalam sehari
(1 Ulasan)
3.7
martini002

can be done immnediately. Hello, I'm a software engineer & linux sysadmin. Instead of a batch script I can give you a exe program, open it, select the file and work done. I can deliver it in the next 2 hours. So Lagi

$35 USD dalam sehari
(2 Ulasan)
2.1
vfxsabbir

WE CAN DO WORK FOR YOU AS PER YOUR REQUIREMENT, IN YOUR BUDGET AND TIME FRAME. WE CAN HELP YOU MAKE THAT HAPPEN!!! Let's discuss.

$20 USD dalam 3 hari
(0 Ulasan)
0.0
goodwork20k

I am good in perl scripting along with php, mysql and powershell I can write perl script for your data conversion and i had good experience in data conversion Please let me know if you are good to award this proj Lagi

$30 USD dalam sehari
(0 Ulasan)
0.0
abuakar21

Hi, I'm Abubakar and I'm a python programmer with 2+ years experience. I can write a simple script to automate the formating of your csv file. this can easily be done using the CSV module. It will be an honour to work Lagi

$30 USD dalam 2 hari
(0 Ulasan)
0.0
Anis1666

I am capable to do this job very smoothly, this is the reason i have taken the risk very short price.

$24 USD dalam sehari
(0 Ulasan)
0.0
MrSayyed

can be done immnediately! :) I am a Web Developer and Programmer with full command on C++,PHP, and Python. I have over 8 years of experience in this field and have done almost all kind of Project in these langua Lagi

$25 USD dalam sehari
(0 Ulasan)
0.0
metageness

Hi, I interested with this job, I have flexible work time and can typing 60 words per minute. Thanks

$15 USD dalam sehari
(0 Ulasan)
0.0
nubelo_ZKUF8McV

It's an easy job, I'm an excel expert. Give me the opportunity and I won't disappoint you. Relevant Skills and Experience A lot of experience in excel.

$15 USD dalam sehari
(0 Ulasan)
0.0
yousufmandhra

Hi I am yousuf from Aptech World wide. I am a professional website designer/developer Iam C# programing [login to view URL] C++ Ms Office EXCEl Word Powerpoint Iam working Iam Graphic Desinger LOGO Desinger Iam POTO Editor Lagi

$20 USD dalam sehari
(0 Ulasan)
0.0
mspratt249

Can be done immediately Hi there I can fix your file for you right now. I can If you want me to get started just let me know

$25 USD dalam sehari
(0 Ulasan)
0.0
ExcelDataModels

Can start immediately, and can finish quickly (if you accept my method of completing). Rather than a macro, I would like to use newer free add-ins for Excel to clean the data per your rules. You'll be able to downl Lagi

$25 USD dalam 2 hari
(0 Ulasan)
0.0
bhanuinfy210

Hi, I am an excel, word and VBA scripting specialist who can manipulate the script based on the need. I can complete this requirement in the next 2-3 hrs provided with an opportunity. Please chat in case you are Lagi

$20 USD dalam sehari
(1 Ulasan)
0.1
zarnabnadeem95

Hello there i am a professional designer. i have three years experience in Excel, work and power Point with 2D and 3D Graphs. Also i have great experience in Data Entry. I am new Freelancer. Please hire ME Thank Lagi

$25 USD dalam sehari
(0 Ulasan)
0.0
mahmoudmohamed28

I am a professional that makes an effort to respond as quick as I can to be able to serve you , I am ready to provide you the best quality services

$20 USD dalam sehari
(0 Ulasan)
0.0
gjiki98

Hi there, I’d like to be considered for writing your project. I have working experience in Algorithms(Advanced Level), Data Structures, Object Oriented Programming, AI, Machine Learning, Desktop Development, Android De Lagi

$20 USD dalam sehari
(0 Ulasan)
0.0
kubraismail123

However, I am almost new to here and looking to get a few clients that I can build upon. If you look at my work and feel that I could help you, I will do it at a lower rate. You will get all the expected stuff like a g Lagi

$20 USD dalam 3 hari
(0 Ulasan)
0.0