pspp-users
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

how to produce a readable table from an output table ?


From: ft gmail
Subject: how to produce a readable table from an output table ?
Date: Sat, 25 Jan 2025 16:01:30 +0100
User-agent: Mozilla Thunderbird

Hi,

I want to easily copy a correlation matrix from a factor analysis for further analysis in a spreadsheet and don't find an easy way to export the output from PSPP into a spreadsheet. The intention is to make the matrix more easily readable, to eliminate the lower triangle, reduce the number of digits, mark the important correlations with a color background, etc., actions which you can't do in PSPP.
I did not succeed in this manipulation.

If I copy the output table through Click in PSPP Output Window on table & Edit > Copy into a word processor (mine is LibreOffice) the result is unusable. To get a useful result for this table you have to
- insert output table through copy into the spreadsheet,
- replace vertical delimiters by some character that does not appear in the table, for instance $,
- change text into columns with the special character as a column delimiter,
- delete superfluous vertical and horizontal line characters.

If I export the output directly into an odt format then the entire content of the output window is exported, though I want a single table only. I then  need to delete any superfluous output in the text treatment and then export the tables into the spreadsheet.
Is there any way to copy just the output table into a spreadsheet for 
further treatment ?
Thanks in advance

- ftr




reply via email to

[Prev in Thread] Current Thread [Next in Thread]