Đã Đóng

Powershell mapping file

I want a powershell script which I can feed a mapping file to and a file of output (which both have different column headers). I want to create a new file which has the headers from the mapping file but input from the output file. Example attached:

In the zip file are three files.

1. cm1hr1_cm1hr1~[login to view URL] – this is the output file

2. [login to view URL] – the mapping file

3. [login to view URL] – the desired outcome

So the headers in the converted file will always be E1:end (in this case AK1) from the mapping file. We can also feed the powershell script the desired row to look at (in this case it’s CM1HR1 which is row 25).

For each of the headers in the converted file the script either needs to copy the column listed in row 25 (so for MATH_RES_IF (F1) it needs to copy column C_MATHRES_IF from the RAFM output for example). If the column is listed as ‘NotUsed’ then it just needs to add a column of 0s.

Hopefully that makes it clear?

Kĩ năng: Powershell

Xem nhiều hơn: batch file clear cache cookies, batch file clear cookies, powershell adodbconnection file dsn, powershell remove mapped drive, powershell map network drive for all users, powershell mapnetworkdrive, powershell new-psdrive, powershell map network drive on remote computer, powershell list mapped drives, powershell new-psdrive credentials, powershell map network drive with credentials, batch file clear cookies cache, powershell last file directory, file maker front end mysql, inline powershell batch file, powershell batch file, powershell excel file user account creation, powershell ini file, powershell batch file convert, file list front end cmsms

Về Bên Thuê:
( 0 nhận xét ) United Kingdom

ID dự án: #17585157

16 freelancer đang chào giá trung bình £162 cho công việc này

venkat071292

Greetings!! I am an Microsoft certified professional with expertise in Windows Powershell I have done various automation projects using Powershell for the past 4+ years. I can accomplish the given task using W Thêm

£140 GBP trong 3 ngày
(21 Nhận xét)
4.3
dany3j

Hello Mr I can help you with this Script. I would like to know more about the project. contact my by chat to get more information. Best Regards

£166 GBP trong 7 ngày
(4 Nhận xét)
2.6
AhmadSameer

Hey I'm a System and Network Engineer with coding skills. I had done many projects using PowerShell. I can help.

£250 GBP trong 5 ngày
(3 Nhận xét)
2.1
AdrianCJ

I can do this. I guess the actual csv files are a lot larger and the native cmdlets will take a very large amount of time. But is okay, I've done something similar on this website and I pull monthly csv/xls reports fro Thêm

£70 GBP trong 3 ngày
(4 Nhận xét)
1.8
TheMacStack

Hello I have allot of experience with PowerShell and would be happy to help you with this. Please reach out to discuss details. Thanks Callum

£111 GBP trong 2 ngày
(1 Nhận xét)
2.0
Shuchi144

Hello, Yes, I have read and I am an expert in PowerShell Script. Please have a look at my previous work. [login to view URL] I can create a new file which has the headers from th Thêm

£200 GBP trong 3 ngày
(0 Nhận xét)
0.0
khuntibharatc

Hello, I can provide you PowerShell script that generate CSV file based on Mapping and Output file. Is it okay to create PowerShell script that run PS 5.0 or more? Looking forward to your replay Thanks, Bhar Thêm

£200 GBP trong 3 ngày
(0 Nhận xét)
0.0
sanyukta14

Hello There, We are the trusted partner with Microsoft and has been awarded with Microsoft BizSpark program. In a nutshell, you can take me as your long-term IT partner. I can assure you that my development cost w Thêm

£190 GBP trong 3 ngày
(0 Nhận xét)
0.0
£222 GBP trong 5 ngày
(0 Nhận xét)
0.0
guptarajesh001

Extensive experience of more then 6 yrs on power shell and past experience of working on such project.

£277 GBP trong 4 ngày
(0 Nhận xét)
0.0
martinadolfi

I'll need some more detail, but it seems that it's not that hard. I've plenty of experience in powershell and think I can get this done very quickly. I've done from small things like this to big projects with workfl Thêm

£111 GBP trong 3 ngày
(0 Nhận xét)
0.0
Ghosh1992

Dear Sir/ Madam, I hope that you are doing great. I have gone through you requirements and I can complete your project on time and within your budget. Though I have experience of more than 4 years in Powershell script Thêm

£112 GBP trong 1 ngày
(0 Nhận xét)
0.0
suruchisingh965

hi,I have 3 years experience on powershell and i have done several such scripts,I will surely deliver you required script within 2 days.

£150 GBP trong 3 ngày
(0 Nhận xét)
0.0
Vikrant9977

I have developed automation tools using powershell while working for a MNC client. I can provide you the exact solution script that you need.

£66 GBP trong 1 ngày
(0 Nhận xét)
0.0
ram4694

I have over 4 years of industrial experience in Powershell. I can assure you quality anf submit the project on time

£72 GBP trong 1 ngày
(0 Nhận xét)
0.0
WTechServices

Experience in Powershell for different type of scenarios. Includes Parsing engines, WMI, Parallel script execution and Remote Powershell.

£250 GBP trong 5 ngày
(0 Nhận xét)
0.0