CFD Online URL
[Sponsors]
Home > Forums > OpenFOAM Paraview & paraFoam

Problem: Export one colum of spreadsheet

Register Blogs Members List Search Today's Posts Mark Forums Read

Like Tree1Likes
  • 1 Post By arvhult

Reply
 
LinkBack Thread Tools Display Modes
Old   November 19, 2013, 13:35
Default Problem: Export one colum of spreadsheet
  #1
New Member
 
Anonymous
Join Date: Mar 2012
Posts: 13
Rep Power: 4
LiteCFD is on a distinguished road
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!
LiteCFD is offline   Reply With Quote

Old   November 20, 2013, 03:58
Default
  #2
Senior Member
 
Tom Fahner
Join Date: Mar 2009
Location: Delft, Netherlands
Posts: 170
Rep Power: 8
tomf is on a distinguished road
Send a message via MSN to tomf Send a message via Skype™ to tomf
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
Use $2 in the awk print part for column 2 of the csv file or if you want only columns 1 and 3, use:

Code:
sed 's/,/ /g' <filename>.csv | awk '{print $1 "," $3}' > column1and3.csv
This is more a workaround though.

Regards,
Tom
tomf is offline   Reply With Quote

Old   November 20, 2013, 04:02
Default
  #3
Senior Member
 
Bernhard
Join Date: Sep 2009
Location: Delft
Posts: 790
Rep Power: 12
Bernhard is on a distinguished road
The pipe from sed to awk seems obsolete if you could use the IFS input for awk. Anyhow:
Code:
cut -d',' -f1 <filename>.csv
would do the job too

Last edited by wyldckat; November 20, 2013 at 18:12. Reason: Added [CODE][/CODE]
Bernhard is offline   Reply With Quote

Old   March 18, 2014, 11:19
Default
  #4
New Member
 
Carl-Magnus Arvhult
Join Date: Feb 2014
Posts: 12
Rep Power: 2
arvhult is on a distinguished road
Quote:
BTW, can I copy columns directly from spreadsheet view? Ctrl+C of Edit->Copy don't work.
I found that "file -> export scene" exports the actual selection in the spreadsheet view. It took way too much time to realize this...
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
wyldckat likes this.
arvhult is offline   Reply With Quote

Old   March 21, 2014, 19:03
Default
  #5
Super Moderator
 
Bruno Santos
Join Date: Mar 2009
Location: Lisbon, Portugal
Posts: 7,511
Blog Entries: 33
Rep Power: 74
wyldckat is a jewel in the roughwyldckat is a jewel in the roughwyldckat is a jewel in the roughwyldckat is a jewel in the rough
@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
wyldckat is offline   Reply With Quote

Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CFX results export problem ? nasir CFX 2 November 4, 2011 23:10
[ICEM] two phase export and import problem jszl ANSYS Meshing & Geometry 1 December 1, 2009 01:39
Adiabatic and Rotating wall (Convection problem) ParodDav CFX 5 April 29, 2007 20:13
simple export problem Steven CFX 3 October 14, 2006 04:25
Periodic flow boundary condition problem sudha FLUENT 3 April 28, 2004 09:40


All times are GMT -4. The time now is 18:50.