cvs file problems

[alexandru.murariu1989]

Hello Sirs!

I extracted the data from dwg and i can t divide the obtained data into columns. I tryed but doesn t work. Can some1 help me and explain how to do? i need x y and cota (Z). i want to import that point file to create  a surface.

Ty sirs

[Joe-Bouza]

I just double clicked and Excel opened in cols. How are you doing it?

Count	Name	COTA	Position X	Position Y
1	PUNCT	150.79	621953.1	687453.893
1	PUNCT	150.4	621953.3	687454.076
1	PUNCT	150.29	621953.7	687453.165
1	PUNCT	150.88	621954.7	687454.046
1	PUNCT	150.64	621953.9	687453.863
1	PUNCT	150.61	621953.7	687453.946

[alexandru.murariu1989]

When i open it apear all text in a colum. Can u import points în civil with this cvs file? 

[hippe013]

I've re-ordered the points to be in the PNEZD format. See uploaded file.

[Jeff_M · Accepted solution]

@alexandru.murariu1989 , You could reorder the columns (data separated by commas in a text file are 'columns') in Excel and resave as @hippe013 did.

Another option would be to add a UserDefinedProperty "Count" as an Integer type to the drawing, then create a new PointFileFormat with the columns consisting of Count, RawDescription, Elevation, Easting, Northing. You will need to edit the first line of the csv file to be:

# Count,Name,COTA,Position X,Position Y

then SaveAs and change the file format to UTF-8  (it currently is UTF-8 with BOM). You will then be able to import the points using that new PointFileFormat. If this is something you will need to do again on another project, makes sure to save the PFF and UDP to your template.

[hippe013 · Accepted solution]

When I saved the file used bad encoding. I've re-uploaded the file. Use this one.

[Joe-Bouza]

Yes but the file you provide looks like output from DATAEXTRACTION. you want point numbers in place of count and as others stated  - reorder