Welcome back to this three-part series on Integrating Microsoft Excel with PowerShell. Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers. 0, now the Copy-Item command supports copying files from one machine to another through -ToSession and -FromSession parameters. In both examples ‘Group Name’ is the name of the group that you want to export the member list for, and memberlist. For example for a folder named CM8252390-3, the job number is 8252390-3. replacing a line or date in a text file using powershell. filename dragonhsv1 over 4 years ago I need search then extract content from multiple. How to extract data from a PDF Nassos Stylianou introduces you to the various tools used for extracting data from PDFs, and weighs up their pros and cons… By Nassos Stylianou / Mar 12, 2014. But I can't manage to include the following lines:. Can anyone tell me how to display (using a single PowerShell command line) lines from a file that are between 2 strings? For example, the file looks like: Line 1. The result of the scripts is displayed in the PowerShell CLI console and it is not always convenient for the end user. com, you might be coming for a few different reasons. powershell: use parameters and configuration from ini file, use as splatting June 22, 2017 09:14PM I was working on one of my friends requirement for automating scripts, He wanted a safe way to use parameters and configuration values from external file instead of modifying actual script, I tried with CSV as well as cliXML file. You can import the data of a text file into current worksheet beginning at a specific cell with Text Import Wizard as the following steps: 1. Windows comes with the two command-line tools find and findstr that allow you to search in text files. Get-Unique is case-sensitive. In the worst case the file will need to be run through an optical character recognition (OCR) program to extract the text. $ grep -i "is" demo_file THIS LINE IS THE 1ST UPPER CASE LINE IN THIS FILE. ) from the original PDF file in the converted text file using the “-layout” flag. Execute the following command, (change the file path) Add-Content c:\scripts\test. hi hello aloha And I have one more file abc. I would like to use powershell to remove the text before and after a "Keyword". Hledejte nabídky práce v kategorii Powershell computer name in text file nebo zaměstnávejte na největší burze freelancingu na světě s více než 17 miliony nabídek práce. Morrow Lately I’ve been toying with the idea of using PowerShell to parse the Windows event logs and possibly adding that to my Inventory scripts. i use -match command to find the word. Introduction The Metadata Extraction Tool was developed by the National Library of New Zealand to programmatically extract preservation metadata from a range of file formats like PDF documents, image files, sound files Microsoft office documents, and many others. Before importing a file with PowerShell, we can obtain the file's information that allow us to filter whether it's been complete, what time it was created and modified, and it's overall size. But is it is a long single string without new line characters, multiline textbox still wraps it - how to get wrapped lines in this case? Rate this:. Hi, I am trying to extract some lines from a huge text file using a powershell script. PowerShell will return each line in the text file that includes the target string. The following PowerShell script reads an input file, and then outputs the strings/sentences/paragraphs that are in-between quotes. If you ask for the last several rows (as shown in the commented-out code in the example below, you will get back an array of rows. Here the script reads the groups list from text file c:\temp\groups. DHCP PowerShell in Windows Server 2012, in addition to providing cmdlets for DHCP server management, provides cmdlets for exporting (Export-DhcpServer) and importing (Import-DhcpServer) DHCP Server configuration and IP address lease data. In this recipe, we will export records to a pipe-delimited text file in a SQL Server table. Since PowerShell is built on top of the. Hope this helps and happy learning. After cleaning up the text file, save it to another file name and what should remain is just the path. txt files I need the results to be displayed like this on the csv file: Name of text file. It is here: Windows PowerShell Saturday #003 in Atlanta, Georgia (Alpharetta). I want to to extract only "file_size=8452858 rows_count=29339" from the below line. Many times you can get what you need with a simple one-line. Although storing data in a plain text file can never replace a full-blown relational database management server, they are perfect for small jobs and quick reporting. Text repair works for English, German, Spanish and other languages. Reading lines from a text file is a classic job for a loop. I'm new to powershell regular expressions and have a question on how to write one that would extract text and numeric values from. To achieve this, since the machine was Windows 7, it was convenient to use Powershell to extract a sample of the text content generated by the COM port so I could bring the generated files on my test machine and start working on my UFL Configuration. PowerShell will give you a list of all your programs, complete with the version, name of the developer, and even the date you installed it. Wondering if anyone can help me in doing that. In most of the cases, it will be more than sufficient to use very well-known PowerShell command - Import-Csv. The above function can be useful in situations where we may need to reuse it on multiple strings from within a file or message or is a good reminder of how to parse strings by character. A computer program that reads lines of text entered by a user and interprets them in the context of a given operating system or programming language. After parsing a document, and finding some elements, you'll want to get at the data inside those elements. 10 and name it as file. The icon turns to “installing”. I managed to use 'foreach file' and 'select-string', but it only outputs one of the lines I need. This will open a DOS-like command window. Install the PowerShell package: Press Ctrl + Shift + P (Cmd + Shift + P on Mac) Select 'Install Package' Select 'PowerShell' Developing. The Compress-Archive cmdlet enables you to create new archives from folders or individual files and to add files to archives; Extract-Archive can be used to unzip fi. Select-String can take in a number of options, but can be quite simple to use. And concerning a way to check the file content, if there is a timestamp at the beginning of every line, just parse the lines written since the last check (X minutes). How to Get the Last Line of a File. There’s also information on how to use Powershell to enumerate document libraries here – but you can very quickly list all files and folders from a DIRectory assuming you can get its UNC (Universal Naming Convention) path and you can access the entire document library. Below is a little Batch program to extract a range of lines from a text file and output them to the screen. Brad Linscott, a teammate of mine since the old times of SIE, came up with a very helpful idea: find an automated way to get the key/value pairs from a Dictionary object. Retrieve variable from text file I have a text file which contains some data which I need to put into a variable in powershell i just want to create two variables, which are pulled from the text file, _admin_0_name and _admin_0_pass. Inside that loop we use Get-Content to read the names of the computers held in a named text file. You should do this at the top of your PowerShell script and it should look something like this:. You can of course change the text in quotes to anything you want to help filter the lines you want to see. I tried adding multiple groups in groups. Powershell command to delete all the lines matching a word from a. lmps file), and manipulate it. If the log files are structured or predictable, it doesn't take much to create a PowerShell tool for extracting useful information. If the text file got 2 or more set of 50 data, it should extract all into the Excel. Traditional tools such as batch files or VBScript can only cope with these tasks in a rather awkward way. I would like to extract the dates and email addresses from log files and output that info to a text file. Here is a sample of the log file. I need some help creating a PowerShell script which will run through a directory and parse all of the files within (~100 files) to extract specific lines of data. Some SAMPLE lines have multiple values that need to be extracted. The Rise of PowerShell Attacks. "the last row") in Powershell? It's easier than I thought. For the purpose of discussion, we chose the following. I am trying to remove specific lines from a text file. Ideally I would be able to extract the information using regular expressions in powershell. In the second part, I'll discuss how to use the new SMBShare and SMBWitness modules on Windows 8 and Server 2012. Run this command:. Get-Content -Path. If a Version # doesn't exist, it should return the empty string or something like that. 0 Scenario You might have many layers of folders insides folders and files insides those folders in a SharePoint Library. 62" in them. 3) The output file for where the extracted data will be placed. I'm new to powershell, but I need to read a text file and copy sections out to another text file. I would like to extract the dates and email addresses from log files and output that info to a text file. Although extracting this information might already be helpful in itself, it would be overkill to use Powershell and XML only for this basic task. com Example Output - Line 2: 01/07/2013 email. are some other special characters that can be used with add-content cmdlet. hi hello aloha And I have one more file abc. txt no color color colour coloured colored. Create a file with 10 lines with 1. PowerShell One-Liners: Collections, Hashtables, Arrays and Strings The way to learn PowerShell is to browse and nibble, rather than to sit down to a formal five-course meal. How is this situation not a checkmate? How to prove that the quadratic equation has exactly two real solutions Should I be an author on. Business Problem. Given a little time and practice, you will be an expert at processing text files with PowerShell. pdf download and process file in C# and ByteScout Text Recognition SDK ByteScout Text Recognition SDK is the software development kit for automatic text recognition and OCR from pdf documents and images. Hi, I am trying to extract some lines from a huge text file using a powershell script. Thanks for posting this info. PowerShell is my favorite Business Intelligence tool that is not a Business Intelligence tool. Using powershell to clean up text file. Web servers usually don't transmit this information. Here the script reads the groups list from text file c:\temp\groups. If your going to move this file to a unix or linux computer, you’ll only need a `n there’s no need for the carriage return. December 2017 • ( Leave a comment ). At line:1 char:15 + Get-Process | Out-File -FilePath. Powershell command to delete all the lines matching a word from a file. Use PowerShell's Get-Content cmdlet to copy files to multiple computers. However, because double-clicking starts the sqlite3. If the remote host is a Windows machine you can use PowerShell remoting to read the file size:. But I need to extract all the lines in between the FILE - INACTIVE keyboards. There is an approach to make it simpler and easier, and the main idea is to extract the data of the controls into an XML file, and join the pipelines when needed from the XML file. txt, we just need to type file1. Using powershell to clean up text file. Remove Duplicate Rows From A Text File Using Powershell unsorted file, where order is important. As in Unix and DOS, you can issue commands from the prompt. PowerShell: Deleting entire lines in a text file based on a partial string match PS C:\workspace> (gc “fileToParse. From what I have observed, the HTTP response stream is buffered into memory. Step 2: Extract the files. Because get-content loads the file into an array, and % iterates through each line of the array. powershell,text,text-files. Demonstrates downloading files from an Azure Storage container but same process works for any valid online URL. Whether the string to find inside of the text file is just a single word or a complicated pattern, PowerShell has the ability to find and replace just about anything. That said, see the…. FileSystem assembly to read the contents of ZIP(archive) for without extracting them to the disk. Ho-o-o-o-t :) weblogs. Use PowerShell's Get-Content cmdlet to copy files to multiple computers. I have in one directory hundreds of text files some of them has over 700 lines some just 4 or 5. There are more nice PDF manipulations possible with pyPdf. You want to contribute? Awesome! Take a look at. The sink() function will redirect output to a file instead of to the R terminal. Welcome back to this three-part series on Integrating Microsoft Excel with PowerShell. Split and extract the first 1000 (N) rows from a text-csv-data file in Windows My new scale for measuring oldness A datedif function for excel that calculates correctly. PowerShell Basics #4: Matching and capturing with regular expressions. Summary: The Scripting Wife learns how to use Windows PowerShell to get specific lines from a text file. but the most useful file types for reporting purposes are text files, CSV files, and HTML files. FileSystem assembly to read the contents of ZIP(archive) for without extracting them to the disk. 0 introduced a new cmdlet, Get-FileHash, primarily for use with Desired State Configuration (DSC). I'd like to use VBScript if at all possible. Windows comes with the two command-line tools find and findstr that allow you to search in text files. Extract IP Address. To read the sample file line by line with the FSO, you would create a text stream object as a read source, iterate through the file line by line until you run out of lines, and then close the text stream:. 0, you can use the -First parameter,. For example, if you want to search for. Using text files for configurations can be especially useful in some environments, to avoid re-use or long arrays with many elements in them. txt”) -notmatch "< criteria> " | out-file "resultFile. exe Command-Line. Summary: Learn how to read only the first line of a file by using Windows PowerShell. This automation is efficient, however it can give you a headache when it comes to extracting very specific information from reams of characters and numbers within a raw data file. PowerShell is very powerful in that it returns objects that you can manipulate. However I have been tasked to create a Powershell script that can extract specific information from a large. I'm going to add each line to a hash table. Demonstrate how to obtain the contents of a specific line within a file. As in Unix and DOS, you can issue commands from the prompt. I recently needed to work with a file containing data structured in fixed column width lines. com/profile/04547469289790329772 [email protected] “the last row”) in Powershell? It’s easier than I thought. More information about these file signatures and which ones correspond to what file type can be found here. From there, perform your comparison and write only the 'good' lines to the target CSV. I don't know if I can ask select-string to output two lines in each file. If you want to extract the text content of a Word file there are a few solutions to do this in Python. : [code]$test = "Test string" Add-Content $home\Desktop\output. csv” which contains the names of the 4 groups that will be created. txt) like I have done years ago, but as I'm sure your aware, MS DOS command line has'nt been availible for years and your Windows Virtualization is incompatible with my new computer. Using built-in cmdlets that come with PowerShell, we can easily read and replace any kind of content inside of a text file. I have extracted some data from log files and there are millions of lines of unwanted text. The tip I've mentioned before covers In this tip I'll address the same problem as a previous tip using CLR, but to get the job done I'll use Powershell. SPContentDatabaseStatus_17-10-2013. For the purpose of this task demonstrate how the contents of the seventh line of a file can be obtained, and store it in a variable or in memory (for potential future use within the program if the code were to become embedded). It may be about getting a token from a single line of text or about turning the text output of native tools into structured objects so I can leverage the power of PowerShell. In both cases the file is saved to a location local to where the database is being ran from (on the same machine, or to a mount/drive available to the machine) The header row will need to be added to both files (which can be done using any text editor or spreadsheet program) Now you are ready to upload the new CSV File to SpatialKey. We can delete a file using remove-item command as below. For example, you may have a cell that contains a combination of text and numbers, or a cell that contains two numbers separated by a delimiter such as a comma. If you ask for the last several rows (as shown in the commented-out code in the example below, you will get back an array of rows. To create the file use your favourite text editor such as nano or vim, or simple copy this code to the command line of your system. NET's StreamReader class, which will allow us to customize our usage for increased efficiency. Hi, I am trying to extract some lines from a huge text file using a powershell script. Compression. It's free to sign up and bid on jobs. Although extracting this information might already be helpful in itself, it would be overkill to use Powershell and XML only for this basic task. You can import the data of a text file into current worksheet beginning at a specific cell with Text Import Wizard as the following steps: 1. Whether the string to find inside of the text file is just a single word or a complicated pattern, PowerShell has the ability to find and replace just about anything. Of course, one thing that you won’t find on the Windows PowerShell Week home page is a script that can extract the text that appears between the string HOSTNAME= and a blank space in a line in a text file. txt -TotalCount 5 This is Line 1 This is Line 2 This is Line 3 This is Line 4 This is Line 5 Example 3: Get a specific line of content from a text file This command gets a specific number of lines from a file and then displays only the last line of that content. Here is the full script for the copy and pasters, fika not included. replacing a line or date in a text file using powershell. Windows PowerShell is a programming language from Microsoft that is primarily designed for system administration. The following PowerShell script reads an input file, and then outputs the strings/sentences/paragraphs that are in-between quotes. Thanks in advance. PowerShell is used to store object and its representation object to a file. PowerShell 4. There is one problem with regular expressions though: it's a language that is easier to write than read. Powershell Reading text file. The first line is removed in order to use the T-SQL BULK INSERT command without specifying a format file to skip the first line. All you need to do is Get-Content the file, and then pipe it to Select-Object with the -last parameter set to 1. txt and extract the line containing the words to a new file done. The batch file appears to read the whole file first, as in a file of 500Mb it is taking a lot, and in small files it works instantly. You can do this by opening Notepad and creating a header called “name” and listing the group names line by line all in quotes as shown below. Once the file has been fully loaded, it is flushed to disk. Using Power. There are multiple ways to create a multiline string in PowerShell: You can use the special characters for carriage return and/or newline manually or use the NewLine-environment variable to insert the systems "newline" value). There is an approach to make it simpler and easier, and the main idea is to extract the data of the controls into an XML file, and join the pipelines when needed from the XML file. ps1 file and run it or run them line by line from a PowerShell command prompt. The result is an array. The below example will help you understand better. Writing text and output from analyses to a file Problem. The statement I have, works for the other columns. Go over a file line-by-line. There are two ways to use Powershell. In order to automatically extract zip files, you need a batch script, and an app that can detect the zip file and trigger the script to run. Since PowerShell is built on top of the. As the name suggests, the -ToSession parameter expects a session with the destination computer where the file will be copied. Ctrl+P is the universal search that also does “fuzzy search” of text in files open. I will always prefer either Add-Content or Set-Content to write to files but if you need a quick way to get the PowerShell output to a file, Out-File is the way to go. The JSON format has been used more and more across the internet, especially for Websites. Daz - Friday, July 15, 2011 1:23:02 PM; Great tip, I was trying to figure out the best way to deal with the array of objects. txt: It is shown in the following graphic using the command cat. When using Split() against a text file or the string output of a command, you are dealing with an array. UPDATE 2014-03-24: Note that this version is written for PowerShell version 4 and will not work in PowerShell version 2. Assuming you have completed that task, our next step is to reconnect the content databases back to their Web Applications in the new Development Farm by reading in the CSV file we created earlier. Consider the following text file test. txt and extract the line containing the words to a new file done. Text repair works for English, German, Spanish and other languages. txt $test [/code]or. I am running into issues with the first column APPP_Name and the last columns First_Insert. The merge control file is a plain text document that contains instructions on what document to merge (combine) and what options to use. I know it can be done with Wireshark manually but I need to do it from command-line so it can be used in a script. Here's an example:. It’s an external application that returns an exit code upon completion. PowerShell Package for Sublime Text 3. The resulting table T contains one variable for each column in the file and readtable treats the entries in the first line of the file as variable names. If it's not, however, well, just wait until the folks at Wikipedia get a whiff of this: a script that can extract the information found between two tags in a text file. Hi, I am trying to extract some lines from a huge text file using a powershell script. What we have to do is read each line of the text file and create a PSObject and add-member for each of the lines, then run ConvertTo-HTML. There are a few issues: 1) that I do. Range ("C3"). And concerning a way to check the file content, if there is a timestamp at the beginning of every line, just parse the lines written since the last check (X minutes). To read the text after the # characters you must read the file content up to the # characters first. Using built-in cmdlets that come with PowerShell, we can easily read and replace any kind of content inside of a text file. Use an expression for the filename, and if it exceeds some width (say, 60 characters), return a truncated version that has … either at the beginning of the file or somewhere in the middle. PowerShell made it very, very, easy. For the purpose of discussion, we chose the following. PowerShell: Get Specific Files From Zip Files For a project it was required to extract all *. Learn SharePoint,. Ideally I would be able to extract the information using regular expressions in powershell. PowerShell automatically converts each line of the text file to an element of the array. Reading large text files with Powershell Any sysadmin out there knows that log files are an invaluable asset for troubleshooting issues on their servers. In earlier versions of PowerShell the Community Extensions or. To get the value of an attribute, use the Node. The statement I have, works for the other columns. You can then use methods of the String class to find specific lines and split the text into separate fields. So if you want to read the file metadata without downloading the file, you need an API on the host that offers this data. In contrast, PowerShell offers the complete arsenal of string manipulation functions that you might know from PHP or JavaScript. The icon turns to “installing”. NET, Silverlight, SQL here. Line breaks are inserted after every line of text in the PDF file. Open PowerShell with elevated privileges. NET, C#, VB. Is this possible? I need to read the first text file line by line until I come to a specific word, (like 'keyword') then starting with the next line copy each line read to another text file until I come to another set of words. In this post, you will see various options for extracting folder name from given file or directory path. FileSystem could be used. What powershell command can I use to extract the paths unique to one of the files, lets say file2. Here's an example:. Truth be told, its not actually all that hard to do in PowerShell. It provides batch converting of Adobe Acrobat PDF files to plain text. In this post, you will see various options for extracting folder name from given file or directory path. Using built-in cmdlets that come with PowerShell, we can easily read and replace any kind of content inside of a text file. Hledejte nabídky práce v kategorii Powershell computer name in text file nebo zaměstnávejte na největší burze freelancingu na světě s více než 17 miliony nabídek práce. TB, that is all there is to using Windows PowerShell to remove extra returns and line feeds from a text file. Powershell combined with. txt -Exclude *7*. Although there are no built in command line tools that can monitor a text file for changes in real time, there are some around based on the Unix Tail command. Data file attached. I have a huge file with all the system events and trying to extract all those lines/events which have the ip "172. I'm working with a big text file, I mean more than 100 MB big, and I need to loop through a specific number of lines, a kind of subset so I'm trying with this,. Two lines above this line is empty. Sometimes it is useful (or necessary) to extract part of a cell into another cell in Excel. Create a table from the comma-separated text file. In this post I want to share with all of you my last experiences I had working with the killer feature from powershell and explain how we can work with powershell JSON file formats. Given a little time and practice, you will be an expert at processing text files with PowerShell. Read more Batch conver…. Here's an example:. I’m just going to use a simple example:. Using built-in cmdlets that come with PowerShell, we can easily read and replace any kind of content inside of a text file. If you want to extract the text content of a Word file there are a few solutions to do this in Python. Follow below steps to read the text from a file in a SharePoint library using PowerShell. I am parsing text in powershell. After doing so, converting a PowerShell script to EXE format. For now, we will code this directly and later turn it into a function:. Will windows ever add a menu item or something, to copy list of files from Windows explorer as text into an application?I would run a DOS command (dir /s c: >c-example. Copying files from one folder to another is pretty easy. org > Articles > Parse date from text file and extract lines where the date is greater than X Parse date from text file and extract lines where the date is greater than X Welcome › Forums › General PowerShell Q&A › Parse date from text file and extract lines where the date is greater than X. To get the value of an attribute, use the Node. However, within this document are a bunch of UPN's ([email protected] Use Copy to Excel code sample to copy a row of text to a row of cells in Excel and Select a name in a Word document then create a Contact to create a contact from a resume or similar file. Lets says that we have a log file which contains lines like:. Extract text and Binary Data from PDF, get Tables, Images and Attachments, run OCR. ini text files that contain the connection information I need. PowerShell need no longer be perplexing. Powershell – Parse SpamHaus. Handling Errors from non-PowerShell processes: What happens when your script needs to run an external process from PowerShell and you want to know if it succeeded? An example would be a cmdline tool such as robocopy. NET framework,. It provides batch converting of Adobe Acrobat PDF files to plain text. Anyway, the easiest way I’ve found to copy the first n lines of a text file is to use the get-content PowerShell cmdlet like so: PS > get. How to get a quick report of folders and files for a single Document Library? There are different ways to get that information: a. 136 34782 128. PowerShell General Read specific lines from a text file. txt no color color colour coloured colored. Here we concentrate on getting the most from XML. Here we learn how to retrieve text from text files and how to find text in text files, all through PowerShell cmdlets. So use PowerShell debugging, put a breakpoint at the line outputting data to the CSV and investigate. [code]with open('file1. I would to import those 2 into the Excel file in to the specific columns ( Identifier, and Recovery Key). Although extracting this information might already be helpful in itself, it would be overkill to use Powershell and XML only for this basic task. CSV would do just fine too. NET that allows you to start at the end of a file and work backwards. PowerShell Basics #4: Matching and capturing with regular expressions. Powershell get path of file. Ideally I would be able to extract the information using regular expressions in powershell. Microsoft Scripting Guy, Ed Wilson, here. txt $test [/code]or. In most of the cases, it will be more than sufficient to use very well-known PowerShell command - Import-Csv. After doing so, converting a PowerShell script to EXE format. Or if there is no timestamp, create a copy of the file and compare the last copy (X minutes old) to the new current version to extract the new lines and find your pattern. (like 'this' or 'that') then go back to reading the text file until I. And, it can be very complex when you try to process structured text files, especially if structure is not limited to single line and is not in one of natively supported formats. save the text file as below to the location on your file system such as C:\PS\MBSA\serv ers. There are a few issues: 1) that I do. In earlier versions of PowerShell the Community Extensions or. This command copies all the text files that start with the letter p unless there is a 7 in the name: Copy-Item -Path C:\test\* -Filter p*. When Select-String finds more than one match in a line of text, it still emits only one MatchInfo object for the line, but the Matches property of the object contains all the matches. PowerShell Data Basics: File-Based Data One of the frustrations of anyone beginning with PowerShell is the simple task of getting data in and out. There are a few methods here to use, but the main one that we will use is GetResponse(). Two lines above this line is empty. At the end of the script, save/close files. ps1 and put some PowerShell code in there. Using Generate File Plan Report Feature of Document Library b. If like me, you have to manipulate huge text files containing thousands of lines of data and you hate trawling through them manually, slowly, one-by-one, line-by-line then boy do I have a few tricks to teach you. Now lets talk about how to manipulate that data. /All will dump all the event logs, whatever their names are (not limited to System, Security and Application). I need to be able to extract data to a text file. Daz - Friday, July 15, 2011 1:23:02 PM; Great tip, I was trying to figure out the best way to deal with the array of objects. In this tip, we looked at some ways to obtain and save information about a file prior to importing the file. I am looking for a Powershell solution to search through all the folders and extract the job number from the folder name, and all the connection values from the ini files. Get-Content -Path. You can also exclude certain files from the copy operation. txt and put those unique paths on a new text file?. The jar-file argument is the filename (or path and filename) of the JAR file from which to extract files. Assuming you have completed that task, our next step is to reconnect the content databases back to their Web Applications in the new Development Farm by reading in the CSV file we created earlier.