Rename the row name in csv file

Ask your PowerShell-related questions, including questions on cmdlet development!
Forum rules
Do not post any licensing information in this forum.

Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
This topic is 9 years and 2 months old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.
Locked
User avatar
superddl
Posts: 2
Last visit: Wed Dec 17, 2014 6:11 pm

Rename the row name in csv file

Post by superddl »

Hi all,

I'm new to windows powershell. I don't how to rename the row name in the csv that is from the powershell command export-csv. The rows I'd like to rename are Surname, givenName, sAMAccountName, EmailAddress, Department, Pager. Thanks.

Sean
User avatar
SAPIEN Support Forums
Posts: 945
Last visit: Thu Oct 22, 2015 1:10 pm

Rename the row name in csv file

Post by SAPIEN Support Forums »

This is an automated post. A real person will respond soon.

Thank you for posting, superddl.

Here are some hints to help you get an accurate and complete answer to your question.

Ask in the best forum: If you asked in the wrong forum, just copy your question to the right forum.

Anticipate follow-up questions!

Did you remember to include the following?
  • 1. Product, version and build
    2. 32 or 64 bit product
    3. Operating system, e.g. Windows 7 64 bit.
    4. Attach a screenshot, if applicable
    5. Attach logs, crash reports, etc., in a ZIP file
If not, please take a moment to edit your original post or reply to this one.

*** Make sure you do not post any licensing information ***
User avatar
cothomas
Posts: 32
Last visit: Sun Feb 04, 2024 7:04 am

Re: Rename the row name in csv file

Post by cothomas »

I'm assuming you are exporting a object that you pulled from AD. You would need to either create a new PSObject or reformat the existing one using select-object with custom labels.

An example of using select-object with custom labels:
http://blogs.technet.com/b/heyscripting ... dview.aspx
jvierra
Posts: 15439
Last visit: Tue Nov 21, 2023 6:37 pm
Answers: 30
Has voted: 4 times
Been upvoted: 33 times

Re: Rename the row name in csv file

Post by jvierra »

The items you are mentioning are column or field names and can be easily renamed using the "Header" parameter of import CSV.

If columns are "Surname, givenName, sAMAccountName, EmailAddress, Department, Pager" and you want to rename them to "col1,col2,col3,..." her is how:

Import-Csv file.csvt -Header COL1, COL2, COL3, COL4, COL5, COL6 |
Export-Csv newfile.csv


Of course you can choose any names you want.

If you are trying to change the value of the contents of a column then we would use a filter.
This topic is 9 years and 2 months old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.
Locked