从导出的文本文件中删除空白记录 [英] Eliminate Blank Records from Exported Text file
问题描述
美好的一天。我使用Ms Access 2003将数据从表导出到TEXTFILE。
这是我的实际输出：
EMP003 Matt Dwayne
EMP001 Josh Harnett
EMP005 Peter Parker
EMP006 Flakes Graham
EMP007 Kate Winslett
EMP009 Brittany Murphy
EMP010 Sophia Bush
EMP002 Jake Connor
EMP003 Bruce Wayne
EMP004 Mac Donalds
这是我的Desired输出：
EMP003 Matt Dwayne
EMP001 Josh Harnett
EMP005 Peter Parker
EMP006 Flakes Graham
EMP007 Kate Winslett
EMP009 Brittany Murphy
EMP010 Sophia Bush
EMP002 Jake Connor
EMP003 Bruce Wayne
EMP004 Mac Donalds
如何消除文本文件之间的空格。
谢谢!!!
Good day. I use Ms Access 2003 to export data from table to TEXTFILE.
this is my Actual output:
EMP003 Matt Dwayne
EMP001 Josh Harnett
EMP005 Peter Parker
EMP006 Flakes Graham
EMP007 Kate Winslett
EMP009 Brittany Murphy
EMP010 Sophia Bush
EMP002 Jake Connor
EMP003 Bruce Wayne
EMP004 Mac Donalds
And this is my Desired output:
EMP003 Matt Dwayne
EMP001 Josh Harnett
EMP005 Peter Parker
EMP006 Flakes Graham
EMP007 Kate Winslett
EMP009 Brittany Murphy
EMP010 Sophia Bush
EMP002 Jake Connor
EMP003 Bruce Wayne
EMP004 Mac Donalds
How do I eliminate the blank spaces between in textfile.
Thank you!!!
推荐答案
那里。
您应该提供更多信息：
- 如何执行导出？
- 相关数据集元数据。以下是如何发布表MetaData的示例：
表名= tblStudent
Hi, there.
You should provide more information:
- How do you perform export?
- Relevant dataset(s) metadata. Here is an example of how to post table MetaData :
Table Name=tblStudent
不是直接导出表，而是创建一个过滤掉空行的Query。导出此查询而不是表。
Instead of exporting the table directly, create a Query which filters out empty lines. Export this query instead of the table.
不要直接导出表，而是创建一个筛选出空行的Query。导出此查询而不是表。
Instead of exporting the table directly, create a Query which filters out empty lines. Export this query instead of the table.
我通过使用发送报告到文件来生成输出命令按钮向导。我使用按钮导出报告。
如何创建空行查询。可以详细说明。
谢谢
Hi,
I generate output thru using the Send report to a file using the Command button wizard. I am using a button to export a report.
How do I create a query that empty lines. Can elaborate on this.
Thanks
这篇关于从导出的文本文件中删除空白记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
