Exporting data correctly in excel

General Questions
1

Good morning,

I’m trying to export the displacements of a surface to excel, in order to make some calculation.
I created a node set of the surface, and the reuslts are displayed in a ‘’.dat’’ file. But, if I copy and paste these values in excel, they are all on the same cell.
Then, I tried, by using results → history outputs → create; so, I selected ‘‘ALL’’ (because I need the total value, not the components) and then selected the surface. But I get only 100 nodes, I need all the nodes in the surface selected. If I use that second method, the values are stored correctly in excel, but I need all the node values.
Is there a way to get what I need?

Thank you.

2

In Excel you can set some data import options including custom separators. If you do it properly, the outputs should be placed in individual cells.

3

I tried, it worked, but all the -1,8E-02 are transformed in -1,8E+02

4

That’s strange. Maybe try finding and replacing all occurances of E-02 with e.g. 10^-2.

5

But I have around thousands of rows, is there a fast way for doing it?

6

In both Excel and text editors (including Notepad) there is a Search and Replace tool that can do this for all entries.

1 Like
7

I tried but doesn’t work with the ‘‘E+’’ of numbers

8

¿Don’t you mean -1.8E-02 are transformed in -1,8E+02?. Notice the point and coma difference.

*.Dat files use “.” and your Excel might be using Commas as decimal separator.

In Excel you need to use “split into columns”.

9

You’re right, I didn’t notice it, now it works because I set ‘’.‘’ into ‘’,‘’ in the conversion window.

Thank you a lot.