Completed

powershell script which will extract data from a file and compare the name of the file with database and write it into a database table

example:

file name: [login to view URL],

likewise multiple files for that particular given date from a folder where file size is greter than 0 and file name ends with .bad and file modification date is greter or equal to given date.

inside file:

ghs,hshjsj,hsjjs

hehhw,hhsjs,jjj

database table data which we will compare with file name.

database:

workflow name, session name, system name

comares with the file name seperate by "."

1st part 2nd part and 3rd part

when matches we will insert all the file data set into a seperate table with some unique identifier 1,2,3,4 like that, along with workflow_name, session_name and system_name.

Skills: Oracle Database, Powershell

See more: write-datatable, write-sqltabledata examples, write powershell output to sql server table, powershell update sql table, powershell write-sqltabledata, powershell create sql table from datatable, powershell insert dataset into sql table, powershell insert data into sql server, simple script extract data urls, perl script extract data file access, perl script extract data file, perl script extract data text file, script extract data inbound email store mysql database, write perl script extract data, perl script extract data log file, script extract data file, php script extract data xml file, php script extract data html table, script extract data pdf file, write script extract data sql

About the Employer:
( 1 review ) bangalore, India

Project ID: #23419556

Awarded to:

romainlopes92

hey I'm Romain, a French Microsoft and VMware certified guy I can help you with that please contact me for more information Best regards, Romain

₹6650 INR in 1 day
(13 Reviews)
4.7

3 freelancers are bidding on average ₹3583 for this job

goodwork20k

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

₹3500 INR in 1 day
(29 Reviews)
5.2
krishsathish02

Hi Client , My name is Krish. I’m a Senior Software Developer & Freelance Web & Automation developer with 5+ years of experiences with Master degree holder and expertise in PYTHON, PHP, HTML 5, CSS3, JAVASCRIPT, More

₹600 INR in 1 day
(1 Review)
0.4