Kapalı

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

Beceriler: Excel, Scripting

Daha fazlasını gör: 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

İşveren Hakkında:
( 78 değerlendirme ) munich, Germany

Proje NO: #18971211

Bu iş için 20 freelancer ortalamada $27 teklif veriyor

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 ( Daha Fazla

$50 USD in 0 gün içinde
(659 Değerlendirme)
8.4
ScareCrow01

I think i can do it Thank you

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(19 Değerlendirme)
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 ............. Daha Fazla

$30 USD in 0 gün içinde
(14 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
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 in 3 gün içinde
(0 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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 Daha Fazla

$30 USD in 2 gün içinde
(0 Değerlendirme)
0.0
Anis1666

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
metageness

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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 Daha Fazla

$25 USD in 2 gün içinde
(0 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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 Daha Fazla

$20 USD in 3 gün içinde
(0 Değerlendirme)
0.0