|
[Sponsors] |
[OpenFOAM] Problem: Export one colum of spreadsheet |
|
LinkBack | Thread Tools | Search this Thread | Display Modes |
November 19, 2013, 12:35 |
Problem: Export one colum of spreadsheet
|
#1 |
New Member
Anonymous
Join Date: Mar 2012
Posts: 13
Rep Power: 14 |
Hi all!
I have problem with paraview results export; After data load i use Contour filter. It's required for drawing free surface. Then i try to export only coordinates of contour point: - select necessary column from spreadsheet - File -> Save Data. But in result csv there are all arrays (P, U, alpha, etc) Please help. What I'm doing wrong? May be I also should use another filter? BTW, can I copy columns directly from spreadsheet view? Ctrl+C of Edit->Copy don't work. Thanks a lot! |
|
November 20, 2013, 02:58 |
|
#2 |
Senior Member
|
Hi,
Usually I use some shell commands to modify the content. Something like this should work: Code:
sed 's/,/ /g' <filename>.csv | awk '{print $1}' > column1.csv Code:
sed 's/,/ /g' <filename>.csv | awk '{print $1 "," $3}' > column1and3.csv Regards, Tom |
|
November 20, 2013, 03:02 |
|
#3 |
Senior Member
Bernhard
Join Date: Sep 2009
Location: Delft
Posts: 790
Rep Power: 21 |
The pipe from sed to awk seems obsolete if you could use the IFS input for awk. Anyhow:
Code:
cut -d',' -f1 <filename>.csv Last edited by wyldckat; November 20, 2013 at 17:12. Reason: Added [CODE][/CODE] |
|
March 18, 2014, 09:19 |
|
#4 | |
New Member
Carl-Magnus Arvhult
Join Date: Feb 2014
Posts: 12
Rep Power: 12 |
Quote:
This is ParaView 4.1.0 64-bit. I share your opinion that a simple copy-paste functionality would be helpful! Warm regards, Carl-Magnus Arvhult |
||
March 21, 2014, 17:03 |
|
#5 |
Retired Super Moderator
Bruno Santos
Join Date: Mar 2009
Location: Lisbon, Portugal
Posts: 10,975
Blog Entries: 45
Rep Power: 128 |
@Carl-Magnus Arvhult: Many thanks for sharing your finding!
By the way, if anyone needs to do this in Python within ParaView: http://markmail.org/message/anlxxwlrlyacmsr6 |
|
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
[OpenFOAM.org] Compiling OpenFOAM 5.0 on the Titan Supercomputer | wildfire230 | OpenFOAM Installation | 20 | May 6, 2020 07:30 |
[foam-extend.org] foam-extend-4.0 gcc errors & maybe paraFoam | powerline332 | OpenFOAM Installation | 3 | May 24, 2018 21:16 |
[General] Export spreadsheet from pvpython | wgan | ParaView | 0 | June 10, 2016 15:53 |
[Commercial meshers] Problem with export unstructured mesh in OpenFOAM | AdrianoCT | OpenFOAM Meshing & Mesh Conversion | 2 | June 24, 2015 03:56 |
CFX results export problem ? | nasir | CFX | 2 | November 4, 2011 21:10 |