 |
 |
 |
|
|
|
[Sponsors] | ||||
January 16, 2017, 04:26
|
Did you export *.dat data to excel?
|
#1 |
|
Member
bye bye my blue
Join Date: Sep 2016
Posts: 37
Rep Power: 9  |
When i got data form force.dat
----- # Forces # CofR : (5.000000e-01 5.000000e-01 2.000000e+00) # Time forces(pressure viscous porous) moment(pressure viscous porous) 0.0588235 ((-2.410679e-04 -6.664707e-04 1.369046e-01) (-2.510197e-03 -8.751955e-03 2.263415e-02) (0.000000e+00 0.000000e+00 0.000000e+00)) ((-7.502434e-02 -7.484802e-04 -4.059869e-04) (-2.011000e-02 2.824375e-04 -1.691510e-04) (0.000000e+00 0.000000e+00 0.000000e+00)) ----- this is example. then how can I get data for excel without '(('??? It makes char in excel not number. help me plz |
|
|
|
|
|
January 16, 2017, 08:47
|
|
#2 |
|
New Member
Join Date: Jan 2017
Posts: 11
Rep Power: 9 |
Open the .dat file as a text file or similar format, and use replace to change the ( and ) for an empty space. Save the file, and open it with excel.
That way you can remove any unwanted character from your .dat files |
|
|
|
|
|
 |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| [General] Extracting ParaView Data into Python Arrays | Jeffzda | ParaView | 30 | November 6, 2023 22:00 |
| [OpenFOAM] Paraview doesn't seem to be picking up data generated by icofoam | MikeHersee | ParaView | 2 | January 6, 2015 09:27 |
| convert data to excel? | wan11 | CFX | 2 | December 20, 2014 13:38 |
| [General] 2 datas on one plot | Akuji | ParaView | 46 | December 1, 2013 15:06 |
| studying a valve case | mina.basta | OpenFOAM | 33 | August 30, 2013 05:46 |
Linear Mode
