Data post-processing using powershell or batch-script

I have a daily csv file generated, and required a program to do post-processing to insert the missing data in the below logic.

- 1st, based on a starting and ending sequence numbering, the program need to insert the missing sequence when match against the reference series. For example

Starting is CHEM_R13719, CHEM_R13720, CHEM_R13721 .....CHEM_R13741 (Ending). Any missing sequence, the program will auto-insert it.

- 2nd, when inserting the missing sequence, it will auto-populate the last value of the LimitString tied to the sequence. For example, CHEM_R13731 was missing, and the last CHEM_R13731 LimitString value is 0, so the program to auto-insert CHEM_R13731, with the LimitString value as 0

-3rd, for the _time field, it will take from the last record read.

The post-processed file will be output as CSV

I have attached a output file for the post processing test.

There are 7 group of sequences to be referenced to. So the program need to allow input of starting sequence and ending sequence. I have attached the sequence group in the image file for reference. All sequence are in running numbers.

Compétences : Programmation C++, Powershell

en voir plus : perl script convert xml csv file, convert batch script powershell, sabnzbd post processing script, embed powershell in batch file, powershell batch processing, powershell run batch file in background, run powershell command from batch file, powershell run batch file, run batch file from powershell with parameters, powershell create batch file, powershell start process batch file with parameters, data processing, c++programming, php script parse format csv file, convert dos batch script powershell, script receive data post, run script computers listed csv file, perl script read columns csv file, create batch script extract xml data data feeds, batch script powershell coverter

Concernant l'employeur :
( 16 commentaires ) Singapore, Singapore

Nº du projet : #16486119

Décerné à:


Dear, I WILL DO THIS JOB FOR $100 After checking the CSV file, I feel everything is clear and I am ready to do the job. I will create a desktop app to select the CSV file and the app will do the job automaticall Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(6 Commentaires)

8 freelance font une offre moyenne de $430 pour ce travail


Hi, Dear Employer! How are you? I am really interested in your project. I have enough experience on power shell, C/C++, C#, java programming. I am 100% sure i can satisfy your requirements perfectly. User-Friendl Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(99 Commentaires)

hi, client nice to meet you. I've read your job posting carefully and I am very interested. I think your project is quite simple and I can finish your project in a day. I have a good skill in windows programming us Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(9 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(2 Commentaires)

Dear Sir, I have gone through your project details and understand that you need Data post-processing using powershell or batch-script. I have 5 years of experience in C++ Programming, Powershell I will make a Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(9 Commentaires)

I can create such simple program in less than a day for just $100. Your budget is too high for such job but I can't place bid less than $250. My script will post process your CSV file and insert missing sequence, _t Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(24 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(1 Évaluation)

A proposal has not yet been provided

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)