Add line break import-csv

Question

Add line break import-csv

Sam White 26

I want to create some new users and add street address which a multi-line string. I have a csv file with the user name and street address. I want that when I add the users the Street and City are added on the new line and not added on the same line. How can I achieve this?

Rich Matheisen 47,901 Reputation points

2021-03-05T20:21:16.827+00:00

When you say that you "want to create some new users", do you mean "users" in the Active Directory???

You say you have a CSV file with the name and street address. If you look at that CSV file in, say, Notepad, what does the "street address look like"?

If there's no way to separate the street from the city value I don't know how you can accomplish your stated goal.

3 answers

Your answer

Rich Matheisen 47,901 Reputation points

2021-03-05T20:21:16.827+00:00

When you say that you "want to create some new users", do you mean "users" in the Active Directory???

You say you have a CSV file with the name and street address. If you look at that CSV file in, say, Notepad, what does the "street address look like"?

If there's no way to separate the street from the city value I don't know how you can accomplish your stated goal.

Answer 1

Sam White 26

Currently the street address is added like: Street1 City1 so I want the City1 to appear on a new line.

Rich Matheisen 47,901 Reputation points

2021-03-05T20:24:17.41+00:00

Do you really mean "on a new line" (where "line" is a "row")? Or do you just want the Street and City to be treated as a multi-line value in the same row within, say, an Excel spreadsheet?

Answer 2

Rich Matheisen 47,901

Something like this?

Import-Csv C:\junk\x2.txt |
    ForEach-Object{
        $_.Address = $_.Address.Split(" ") -Join "`n"
        $_
    } |Export-Csv C:\junk\x2.csv -NoTypeInformation

I have no idea what your real data look like so how you go about separating the street address from the city name is unknown.

Sam White 26 Reputation points

2021-03-05T06:06:22.637+00:00

No this will not work as the street address and city address would also have spaces. I know that I am going to always mention the street address on the first line and the city address on the second line. I am trying to do something like described in the article, however this find replace is not working for me:
https://devblogs.microsoft.com/scripting/csv-add-a-carriage-return-for-powershell-import/
I want something like a here-string in the csv file, where the multiple line format is maintained when importing a csv file where a cell has data in multiple lines.

Answer 3

Hi，

Does this meet your needs?

$file = 'D:\temp\users.csv'  
$output = 'D:\temp\users2.csv'  
$address = @'  
{0}  
{1}  
'@  
Import-Csv -Path $file | foreach-object {  
    $street, $city = $_.address -split ' '  
    $_.address =  $address -f $street, $city  
    $_  
} | Export-Csv -Path $result -NoTypeInformation

If the street address and city address also have spaces, you have to separate them with some other symbol instead of the space.

Best Regards，
Ian Xue

============================================

If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

Add line break import-csv

3 answers

Your answer