Exclude Birth Dates from "Members Without Callings" report
-
- New Member
- Posts: 5
- Joined: Sun Feb 12, 2012 5:21 pm
Exclude Birth Dates from "Members Without Callings" report
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.
- aebrown
- Community Administrator
- Posts: 15153
- Joined: Tue Nov 27, 2007 8:48 pm
- Location: Draper, Utah
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.
Questions that can benefit the larger community should be asked in a public forum, not a private message.
-
- Church Employee
- Posts: 2361
- Joined: Tue Jun 30, 2009 8:12 am
- Location: South Jordan, UT, USA
-
- Church Employee
- Posts: 92
- Joined: Tue Sep 14, 2010 3:08 pm
- Location: USA
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.
Developer, Core Systems and Services
http://clerk.lds.org
http://clerk.lds.org
-
- New Member
- Posts: 5
- Joined: Sun Feb 12, 2012 5:21 pm
aebrown wrote:A technique I have used in such situations is to do the following (on Windows):
If you try to paste directly in Excel without going through Notepad, the text won't paste into columns like you want.
- 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.
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