    Get-Content &quot;C:\start.csv&quot; | select -First 10 | Out-File &quot;C:\stop.csv&quot;

That did it

    Get-Content in.csv -Head 10 &gt; out.csv

Using -TotalCount parameter is recommended. Especially, if you have a big CSV file.
By this way, you will only read the first 10 lines of your CSV file instead of reading all lines, selecting the first 10 lines and extracting them.

    Get-Content C:\Temp\Test.csv -TotalCount 3 | Out-File C:\Temp\Test10lines.csv

This works in Powershell 2 onwards.

You can also use 

&lt;!-- language: default --&gt; 

    (Get-Content yourfile.csv)[0 .. 11]&gt;outputfile.csv


Be sure to include the header row or you could run into issues. You can also change the numbers to get whatever rows you want. The first and head flags did not work for me.


Windows PowerShell

Get-Content -First 10&#39;C:\Users\jason\Desktop\big_file.csv&#39;


When I was answering [another question](https://stackoverflow.com/q/28953795/1903116) I came across a Node.js module with a top-level `return` statement. For example:

    console.log(&quot;Trying to reach&quot;);
    return;
    console.log(&quot;dead code&quot;);

This works [without any errors](http://ideone.com/PLbu80) and prints:

&lt;!-- language: lang-none --&gt;

    Trying to reach

in the standard output but not &quot;`dead code`&quot; - the `return` actually ceased execution.

But according to the [specification of `return` statements in ECMAScript 5.1](http://es5.github.io/#x12.9),

&gt; **Semantics**
&gt;
&gt; An ECMAScript program is considered *syntactically incorrect if it contains a return statement that is not within a `FunctionBody`*.

In the program shown above `return` is not within any function. 

**Then why doesn&#39;t this throw?**

Why does a module level return statement work in Node.js?

I just recently downloaded the Android SDK.  
Downloading all the packages in the &quot;SDK Manager&quot; will take way too much time. So I&#39;m wondering whether I should deselect all the platforms except the latest one.  
Do I need all the platforms or which ones do I need?

Android SDK Manager - Do you need to install all Android platforms?

I have csv file and want to output a new csv file, that only contains the first 10 lines form the original one.
I&#39;ve so far only found code to delete single lines or lines that contain a certain word. Its probably a 15 character one-liner, but I am not sure how to approach this, any help would be greatly appreciated. I don&#39;t expect you to write code, just the right command would help me out.






Extract only the first 10 lines of a csv file in powershell

<p>I have csv file and want to output a new csv file, that only contains the first 10 lines form the original one.
I've so far only found code to delete single lines or lines that contain a certain word. Its probably a 15 character one-liner, but I am not sure how to approach this, any help would be greatly appreciated. I don't expect you to write code, just the right command would help me out.</p>


I won&#39;t get into all the details of why I need this, but users must be able to launch PowerShell as a service account and when PowerShell loads it needs to run a script. I already can launch PowerShell with the stored credentials (stored as a secure string), but for the life of me I cannot get the script (located in $args) to run. I have tried a variety of things, and below is where I am currently. Any help would be greatly appreciated.

    $user = &quot;domain\service.account&quot; 
    $pwd1 = &quot;big long huge string of characters&quot;
    $pwd = ($pwd1 | ConvertTo-SecureString)
    $Credential = New-Object System.Management.Automation.PSCredential $user, $pwd
    $args = &quot;\\domain.local\location\location\location\Script\script.ps1&quot;
    Start-Process powershell.exe -Credential $Credential -ArgumentList (&quot;-file $args&quot;)

Running PowerShell as another user, and launching a script

I am trying to run a powershell -Command to execute a powershell file as a post build event in Visual studio 2013
But i am getting  

&gt; &#39;Powershell&#39; is not recognized as an internal or external command,  operable program or batch file

error on output window and 

    Powershell -Command exited with code 9009 error

Full Error Message:

    &#39;Powershell&#39; is not recognized as an internal or external command,
    10&gt;  operable program or batch file.
    10&gt;C:\Program Files (x86)\MSBuild\12.0\bin\Microsoft.Common.CurrentVersion.targets(4429,5): error MSB3073: The command &quot;echo &quot;C:\dev\tfs\Main\Shared\AggregationComponents\GenerateSchema.cmd&quot;
    10&gt;C:\Program Files (x86)\MSBuild\12.0\bin\Microsoft.Common.CurrentVersion.targets(4429,5): error MSB3073: call &quot;C:\dev\tfs\Main\Shared\AggregationComponents\GenerateSchema.cmd&quot;
    10&gt;C:\Program Files (x86)\MSBuild\12.0\bin\Microsoft.Common.CurrentVersion.targets(4429,5): error MSB3073: echo &quot;Move the PhoenixData namespace schema suffixing it&quot;
    10&gt;C:\Program Files (x86)\MSBuild\12.0\bin\Microsoft.Common.CurrentVersion.targets(4429,5): error MSB3073: Powershell -Command &quot;C:\dev\tfs\Main\Shared\AggregationComponents\MoveAndRenameXsds.ps1 &#39;C:\dev\tfs\Main\Shared\AggregationComponents\bin\Debug\&#39; &#39;C:\dev\tfs\Main\Shared\AggregationComponents\..\PublishedAnalyticsXsds&#39; &#39;.Aggregation&#39;&quot;&quot; exited with code 9009.
    ========== Rebuild All: 8 succeeded, 1 failed, 1 skipped ==========

Powershell&#39; is not recognized as an internal or external command, operable program or batch file

I need to find the **product GUID** for an **installed MSI file** in order to perform maintenance such as **`patching`**, **`uninstall`** ([**how-to uninstall**][1]) and also for **`auditing purposes`**.

  [1]: https://stackoverflow.com/questions/450027/uninstalling-an-msi-file-from-the-command-line-without-using-msiexec/1055933#1055933

How can I find the product GUID of an installed MSI setup?

I have a string, which I have split using the code `$CreateDT.Split(&quot; &quot;)`. I now want to manipulate two separate strings in different ways. How can I separate these into two variables?


Splitting a string into separate variables

For a specific folder, I need to list all files with extension `.js` even if nested in subfolders at any level.

The result for the output console should be a list of file names with no extension line by line to be easily copy and pasted in another application.

At the moment I am trying this, but in output console I get several meta information and not a simple list.

    Get-ChildItem -Path C:\xx\x-Recurse -File | sort length –Descending

Could you please provide me some hints?



How to retrieve recursively any files with a specific extensions in PowerShell?

I just got started with Flask/Python. What I want to achieve is that I have a download button in my HTML and it calls the following function:

    function downloadPlotCSV() {
            $.ajax({
                url: &quot;/getPlotCSV&quot;,
                type: &quot;post&quot;,
                success: function(data) {
                    dataPlot = JSON.parse(data);
                    console.log(dataPlot);
                }
            });
        }

The incomplete flask code is:

    @app.route(&#39;/getPlotCSV&#39;, methods = [&#39;POST&#39;])
    def plotCSV():
    	data = open(&quot;outputs/Adjacency.csv&quot;)

The problem I am facing is that I cannot find a way to download this csv file or return it as a JSON string so I can download it using Javascript. Any idea how I can send it as JSON or maybe download it via Flask itself? What&#39;s the best way?	

Flask: Download a csv file on clicking a button

I am trying to write data to a csv file with java, however when I try opening the produced file with excel I am getting an error saying the file is corrupt. Upon opening the file in notepad it looks to be formatted correctly so I&#39;m not sure what the issue is. I am using the FileWriter class to output the data to the file. 

    FileWriter writer = new FileWriter(&quot;test.csv&quot;);

    writer.append(&quot;ID&quot;);
    writer.append(&#39;,&#39;);
    writer.append(&quot;name&quot;);
    writer.append(&#39;,&#39;);
    ...
    writer.append(&#39;\n&#39;);

    writer.flush();
    writer.close();

Do I need to use some library in java in order to print to a csv file? I presumed you could just do this natively in java as long as you used the correct formatting. 

Appreciate the help, 

Shaw


Java - Writing strings to a CSV file

I&#39;m attempting to read a CSV file into a Dataframe in Pandas. When I try to do that, I get the following error:

&gt;UnicodeDecodeError: &#39;utf-8&#39; codec can&#39;t decode byte 0x96 in position 55: invalid start byte

This is from code:

    import pandas as pd

    location = r&quot;C:\Users\khtad\Documents\test.csv&quot;

    df = pd.read_csv(location, header=0, quotechar=&#39;&quot;&#39;)

This is on a Windows 7 Enterprise Service Pack 1 machine and it seems to apply to every CSV file I create. In this particular case the binary from location 55 is 00101001 and location 54 is 01110011, if that matters. 

Saving the file as UTF-8 with a text editor doesn&#39;t seem to help, either. Similarly, adding the param &quot;encoding=&#39;utf-8&#39; doesn&#39;t work, either--it returns the same error.

What is the most likely cause of this error and are there any workarounds other than abandoning the DataFrame construct for the moment and using the csv module to read in the CSV line-by-line?



Encoding Error in Panda read_csv

I would like to use pd.write_csv to write &quot;filename&quot; (with headers) if &quot;filename&quot; doesn&#39;t exist, otherwise to append to &quot;filename&quot; if it exists.    If I simply use command: 

         df.to_csv(&#39;filename.csv&#39;,mode = &#39;a&#39;,header =&#39;column_names&#39;)

The write or append succeeds, but it seems like the header is written every time an append takes place.   

How can I only add the header if the file doesn&#39;t exist, and append without header if the file does exist? 



Panda&#39;s Write CSV - Append vs. Write

I need to create a CSV and upload it to an S3 bucket. Since I&#39;m creating the file on the fly, it would be better if I could write it directly to S3 bucket as it is being created rather than writing the whole file locally, and then uploading the file at the end.

Is there a way to do this? My project is in Python and I&#39;m fairly new to the language. Here is what I tried so far:

    import csv
    import csv
    import io
    import boto
    from boto.s3.key import Key


    conn = boto.connect_s3()
    bucket = conn.get_bucket(&#39;dev-vs&#39;)
    k = Key(bucket)
    k.key = &#39;foo/foobar&#39;

    fieldnames = [&#39;first_name&#39;, &#39;last_name&#39;]
    writer = csv.DictWriter(io.StringIO(), fieldnames=fieldnames)
    k.set_contents_from_stream(writer.writeheader())

I received this error: BotoClientError: s3 does not support chunked transfer

**UPDATE: I found a way to write directly to S3, but I can&#39;t find a way to clear the buffer without actually deleting the lines I already wrote. So, for example:**

    conn = boto.connect_s3()
    bucket = conn.get_bucket(&#39;dev-vs&#39;)
    k = Key(bucket)
    k.key = &#39;foo/foobar&#39;

    testDict = [{
        &quot;fieldA&quot;: &quot;8&quot;,
        &quot;fieldB&quot;: None,
        &quot;fieldC&quot;: &quot;888888888888&quot;},
        {
        &quot;fieldA&quot;: &quot;9&quot;,
        &quot;fieldB&quot;: None,
        &quot;fieldC&quot;: &quot;99999999999&quot;}]

    f = io.StringIO()
    fieldnames = [&#39;fieldA&#39;, &#39;fieldB&#39;, &#39;fieldC&#39;]
    writer = csv.DictWriter(f, fieldnames=fieldnames)
    writer.writeheader()
    k.set_contents_from_string(f.getvalue())

    for row in testDict:
        writer.writerow(row)
        k.set_contents_from_string(f.getvalue())

    f.close()

Writes 3 lines to the file, however I&#39;m unable to release memory to write a big file. If I add:

    f.seek(0)
    f.truncate(0)
to the loop, then only the last line of the file is written. Is there any way to release resources without deleting lines from the file?

Content Type	Original Author	Original Content on Stackoverflow
Question	Monacco Franze	View Question on Stackoverflow
Solution 1 - Powershell	Monacco Franze	View Answer on Stackoverflow
Solution 2 - Powershell	user2226112	View Answer on Stackoverflow
Solution 3 - Powershell	emekm	View Answer on Stackoverflow
Solution 4 - Powershell	Josh Groen	View Answer on Stackoverflow
Solution 5 - Powershell	Nilesh Butani	View Answer on Stackoverflow

Extract only the first 10 lines of a csv file in powershell

Powershell Problem Overview

Powershell Solutions

Solution 1 - Powershell

Solution 2 - Powershell

Solution 3 - Powershell

Solution 4 - Powershell

Solution 5 - Powershell

Android SDK Manager - Do you need to install all Android platforms?

Why does a module level return statement work in Node.js?

Attributions