COnvertCSV creating issue

Question

I have data in text file as below which have been saved to .txt from .xlsx file. You can see that text data in the file below.

I tried multiple times but every time I am getting below warning. Please help where is wrong, is it something wrong with file content.

Answer 1

Hi @sns ,

it looks like in the line of "Contact = Ram" is a tab in the "Address City" column -> Hyd Hyderabad. Within a column of a tab separated file there should no tab inside the data.

If it's not a tab but spaces it's fine.

What are you trying to achieve with the two lines in the script?

If you just want to read the content of the file with tab delimited data you can use this:

$rows = Import-Csv -Delimiter "`t" -Path "c:\users\kumar\downloads\Customers.txt"  

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

Answer 2

The error says that member "ac" is already present. But I don't see any "ac" in the first line of the file.

Here's a small demonstration of how to reproduce that error:

$text = "ac`tac", "ac1`tac2"
$rows = ConvertFrom-Csv -Delimiter "`t" -InputObject $text

The screenshot of your Customers.txt file content does not agree with the error. Are you sure you're dealing with the correct file?