Page 1 of 1
Exclude Birth Dates from "Members Without Callings" report
Posted: Sun Feb 12, 2012 5:25 pm
by bfrancom
Is there a CSV export so I can massage the data? I need to remove birth dates so I can send this report to leaders via e-mail.
Posted: Sun Feb 12, 2012 5:34 pm
by aebrown
A technique I have used in such situations is to do the following (on Windows):
- Select all the text in the report (from the beginning of the first row to the end of the last row).
- Copy to the clipboard (Ctrl+C)
- Paste the text into Notepad
- Copy all the text you just pasted
- Paste that text into Excel
- Remove whatever columns you don't want.
If you try to paste directly in Excel without going through Notepad, the text won't paste into columns like you want.
Posted: Mon Feb 13, 2012 12:51 am
by jonesrk
aebrown wrote:If you try to paste directly in Excel without going through Notepad, the text won't paste into columns like you want.
You can paste directly into Excel if you use Paste Special and then Unicode Text. (tested copying from Firefox)
Posted: Mon Feb 13, 2012 12:51 pm
by jkitterman
Many of the screens have the option to hide the age. I'll log a feature request to add the option to hide the birth date as well. It seems like you would frequently want to hide the birth date along with the age.
Posted: Mon Feb 13, 2012 5:46 pm
by bfrancom
aebrown wrote:A technique I have used in such situations is to do the following (on Windows):
- Select all the text in the report (from the beginning of the first row to the end of the last row).
- Copy to the clipboard (Ctrl+C)
- Paste the text into Notepad
- Copy all the text you just pasted
- Paste that text into Excel
- Remove whatever columns you don't want.
If you try to paste directly in Excel without going through Notepad, the text won't paste into columns like you want.
I'm running Linux. I got it figured out though in a similar fashion. I even tried this before the initial post, but the problem is that it is hard to select starting with the "name" column header (at least in FF or Chrome on Linux) down to the bottom.
Instead, I had to select from the bottom of the report to the top. Then copied & pasted into Leafpad. Finally, copied and pasted into LibreOffice calc,
Then I was able to modify, export as PDF & then send to Ward Council members.
Thanks,
-Ben