NotePage, Inc. Forum Index

Tab Delimited Reports

 
Post new topic   Reply to topic    NotePage, Inc. Forum Index -> PageGate Support
View previous topic :: View next topic  
Author Message
Immrec



Joined: 27 Jul 2012
Posts: 30
Location: Australia

PostPosted: Mon Oct 07, 2013 6:28 pm    Post subject: Tab Delimited Reports Reply with quote

Is there a way to create reports in Tab Delimited format instead of the default Comma Separated Values format? The comma is used regularly for punctuation in our call centre and plays havoc with the Monthly Recipient Sent Messages report when creating our Pivot Table in MS Excel


Back to top
View user's profile
Tech Support



Joined: 25 Aug 2003
Posts: 4351

PostPosted: Tue Oct 08, 2013 8:18 am    Post subject: Reply with quote

Which version of Excel are you using?

I ask because I just ran a test by sending out a few messages like this:

This is, a test of, how comma placement, effects Excel.

I then ran a report of sent messages and wrote the report to a file. When I opened the file in Excel 2010, it walked me through the import wizard. I selected Delimited as the file type, then I specified , as the delimiter and " as the Text Qualifier and it opened the file and kept everything in its own respective fields.



_________________
Tech Support
support@notepage.com
http://www.notepage.net
Back to top
View user's profile
Immrec



Joined: 27 Jul 2012
Posts: 30
Location: Australia

PostPosted: Tue Oct 08, 2013 6:56 pm    Post subject: Reply with quote

I've used Excel 2003 & 2010 with the same result. I'll send a copy of the latest export to support so you can experiment with the same file I'm creating.


Back to top
View user's profile
Display posts from previous:   
Post new topic   Reply to topic    NotePage, Inc. Forum Index -> PageGate Support All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2002 phpBB Group
Theme created by Vjacheslav Trushkin