Завершен

PowerShell: Import a CSV file, group-by client then by service totally on cost - and output in specified CSV structure

Looking for a component developer to complete the below in PowerShell. Code must be elegant and scale.

Import a CSV file, group-by client then by service totally on cost - and output in specified CSV structure

Brief: We have a csv file which lists charges billed to a client for services used. The total of each service per client is to be recorded in a new CSV file in the structure specified (ie group-by clientCode then by service subtotal cost).

The first tab of the attached spreadsheet shows the source CSV -

1. Delete or ignore the first (which has the text 'Active Charges'

2. Remove' (est.)' removed from 'cost' column (leaving only the $ figure)

3. Split the 'Client' column at the ## and create a new column 'ClientCode' EG. 'Rachels Lawn Bowls##OFS898' becomes 'Rachels Lawn Bowls,OFS898'

4. Split the 'Service' column at the ## and create a new column 'GLcode' Eg. Printing Colour (A4) ##PRN becomes 'Printing Colour (A4), PRN'

5. Group-by ClientCode then By Service totally Cost outputting CSV shown in spreadsheet (third tab)

See the attached spreadsheet.

First tab - shows original CSV

Second tab - shows when split at the ##

Third tab shows - desired output

Навыки: Powershell

Показать больше: j2me file upload web service, perl cgi import file, file upload distribution service, powershell read csv file line by line, powershell import-csv no header, export-csv powershell, powershell import-csv to datatable, powershell export to csv with headers, powershell import-csv to variable, powershell script to read and write csv file, import-csv powershell, powershell import-csv to array, powershell import-csv foreach, powershell import-csv select column, powershell csv, import file 3ds max life, client service management script, quickbooks excel import file, convert quark file indesign online service, import file quickbooks pro 2007

О работодателе:
( 4 отзыв(-а, -ов) ) Clayfield, Australia

ID проекта: #25462417

Поручен:

diorisaguilar

Hi there! I am a software developer with experience working with PowerShell scripts to automate tasks like the one in this project. The input .CSV file can be: 1. Assumed it's in the same folder of the script 2. In Больше

$120 AUD за 3 дней(-я)
(7 отзывов(-а))
4.7

9 фрилансеров(-а) готовы выполнить эту работу в среднем за $117

goodwork20k

I am good in powershell along with automation and development, please let me know if you are good to award this project to me

$150 AUD за 3 дней(-я)
(43 отзывов(-а))
5.5
romainlopes92

hey I'm Romain, a French Microsoft certified guy I can help you with that please contact me for more informations best regards Romain

$130 AUD за 1 день
(22 отзывов(-а))
5.3
pilica

Hi, I have over five years experience automating tasks with Powershell, I can do this job. Please see my work history for relevant feedback.

$140 AUD за 1 день
(19 отзывов(-а))
4.6
AdrianCJ

I can edit the csv accordingly, create a new ClientCode column, modify the text and edit the cost column. When you say Group-by ClientCode, do you mean alphabetically? Everything else is good.

$120 AUD за 7 дней(-я)
(6 отзывов(-а))
3.2
sachinparkhi17

Hey There, Greeting for the day... Could you please have quick discussion. I am Microsoft Certified Engineer. I have 12+ years of experience. I am Powershell Scripting Expert. for more details please have look at Больше

$100 AUD за 3 дней(-я)
(8 отзывов(-а))
3.2
Ldelcampo23

Hi: I am a system administrator with 20+ years of progressive experience. I developed several powershell scripts and i can help you with tyour project. PLease ping me via chat to talk more about your project. Regards

$120 AUD за 3 дней(-я)
(1 отзыв)
2.7
darrenskirvin

Hi, I can do this for you no problem, I will communicate with you as frequent as you like. This is something I understand very well.

$140 AUD за 2 дней(-я)
(2 отзывов(-а))
0.9
krishsathish02

Hi Client , I already done similar projects, I can finish this project soon. I’m a Senior Software Developer & Freelance Web & Automation developer with 5+ years of experiences with Master degree holder and experti Больше

$35 AUD за 1 день
(1 отзыв)
0.4