Tamamlanmış

Modify Data in CSV data in Powershell

An automated system, which I cannot modify directly, produces a CSV file to update products on my website, this is done at regular intervals throughout the day in time spans as few as every 15 minutes to the point that manual file intervention is not feasible. We have an immediate need to modify some data based on criteria in the file prior to upload.

I need a Windows Powershell Script to:

(1) When called, read the CSV file ([login to view URL])

(2) when the column / field VendorNum = 203214 (ideally, a list of numbers but one number is sufficient), change the value of the column/field visibility from 4 to 2.

(3) save the file back onto itself using the same name.

(4) leave all other records the same

- the source file path and file name will always be the same ([login to view URL], the csv file and the script can/will live in the same directory)

- there is no requirement to log or output a list of records change

- needs to run without user intervention, will be run automatically through part of a larger automated task scheduler sequence

- must maintain escaped strings where present, string data may have commas, html characters and occasionally special characters within the codeset of the file (this is rare).

- field order must be maintained.

The attached / uploaded file is a sample from a larger data set which has representative records. I can/will supply a full normal data set to the person who takes this project on.

Validation and Testing I have to upload to our website data processor.

Beceriler: Powershell

Daha fazlasını gör: php create table csv data, upload data csv file mysql, import csv data sql server table, source code export sql data csv file vb6, import data csv file sql 2005, php script form data csv, mysql read delimited csv data, website csv data feed reader, search data csv excel vba, retrieve data csv file, csv data capture, using dts import data csv database, howto export data csv excel format php mysql, mysql update data csv, send form data csv file asp, create invoice import csv data, csv data compiler, dbf data csv data, script modify data csv

İşveren Hakkında:
( 1 değerlendirme ) Baton Rouge, United States

Proje NO: #24746467

Seçilen:

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

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(21 Değerlendirme)
5.2

Bu iş için 15 freelancer ortalamada $97 teklif veriyor

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(36 Değerlendirme)
5.3
dsengar121

Hi I can provide you with the powershell script to update the csv file as per the requirement specified. I have extensive expertise in powershell scripting.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(32 Değerlendirme)
4.7
writingapp

Hi. I have written many automation PowerShell scripts. I am ready to write your project. Will complete within 2 days

$75 USD in 2 gün içinde
(3 Değerlendirme)
2.5
AHTOAH

Hello, I'm a Powershell expert with great experience in creating CSV related scripts. Let me know if you are interested and I'm ready to discuss further details and start creating the needed Powershell script. Regard Daha Fazla

$40 USD in 3 gün içinde
(6 Değerlendirme)
2.5
fastlabindia

Greeting!. Yours work is one of the tasks that can be done very perfectly by us. We work within your budget, Within your deadline. We are highly experienced Post Graduate Engineers, IT, ITES, Software, Infrastructure P Daha Fazla

$250 USD in 7 gün içinde
(1 Yorum)
1.0
(0 Değerlendirme)
0.0
nemanjadj20

Yes. I have done a lot of jobs like this. So i can help you if you want. Hope to work with you. I can deliver in 1 day. Thanks.

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

Hi, I can write a PowerShell script to Modify Data in CSV data in Powershell by following the instructions provided.

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

Hi, I am FULLY CONFIDENT of lending you a hand in creating PowerShell script for modifying the CSV file exactly as you want. Don't worry about keeping the comma escapes intact. If a field value contains "White Gold Lo Daha Fazla

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

Dear, I am a Microsoft Certified Professional (MCP) and I have extensive experience developed on powershell, I can in a few minutes make the script to work with N values to search, if you like write me and I will do th Daha Fazla

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

Hello Sir, Greeting for the day... I have very good experience in Powershell Scripting. I am new here and looking for the project, hence ready to accept this in low budget, however I am very much confident and I can Daha Fazla

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

Hi, Greetings! I have gone through the job description and understand your requirements. Instead of powershell scripts I can use the task scheduler and excel VBA to complete this [login to view URL] on my understanding i have cr Daha Fazla

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

I can do this like a script file which do: 1. Open files form path and name (mask) - done (You can set path and file in scriptfile) 2. Search value in column and change visibility - done (You can set list wendornum, i Daha Fazla

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

Hi there, I don't directly have experience modifying a csv file from command line but I create numerous Bash Scripts at my current company and this problem seems simple enough. I can create a quick test solution to thi Daha Fazla

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