将空字段导出为.txt [英] Exporting Empty fields into .txt
问题描述
大家好，
我正在尝试将查询结果导出到带逗号分隔的逗号分隔的.txt中。第一列总是空白。目前的格式是
标题：
XXXX {Tab} XXX_XX {Tab} {Tab} {Tab} XX_XXXX_XX {Tab } XXXXX
正文：
{Tab} xxxxxxxxxxxxxxxxxx {Tab} xxxxxxx {Tab} xxxxxxxxx
我正在出口make表查询的结果采用相同的格式，逗号为分隔符。问题出在标题中，第二个和第三个文本列之间有两个分隔符。我无法获得正确的导出空白列的规格。我尝试使用a作为列名，但导出时出现了一个underhyphen，因为名称不是逗号。
Hello all,
I''m trying to export a the results of a query into a comma delimited .txt with the header colum. The fist column is always blank.The current format is
Header:
XXXX {Tab} XXX_XX {Tab} {Tab} {Tab} XX_XXXX_XX {Tab} XXXXX
Body:
{Tab}xxxxxxxxxxxxxxxxxx {Tab}xxxxxxx{Tab}xxxxxxxxx
I''m exporting the results of a make table query in the same format with comma''s as the delimiter. Problem is in the header there is two delimiters between the second and third text column. I cant get the specs right to export a blank column. I''v tried using a , as the column name but the export comes out with an underhyphen as the name not a comma.
推荐答案
尝试使用|作为分隔符
Try using the | as the delimiter
大家好，
我是尝试将查询结果导出为带有标题列的逗号分隔的.txt。第一列总是空白。目前的格式是
标题：
XXXX {Tab} XXX_XX {Tab} {Tab} {Tab} XX_XXXX_XX {Tab } XXXXX
正文：
{Tab} xxxxxxxxxxxxxxxxxx {Tab} xxxxxxx {Tab} xxxxxxxxx
我正在出口make表查询的结果采用相同的格式，逗号为分隔符。问题出在标题中，第二个和第三个文本列之间有两个分隔符。我无法获得正确的导出空白列的规格。我尝试使用a作为列名，但导出时出现的是underhyphen，因为名称不是逗号。
Hello all,
I''m trying to export a the results of a query into a comma delimited .txt with the header colum. The fist column is always blank.The current format is
Header:
XXXX {Tab} XXX_XX {Tab} {Tab} {Tab} XX_XXXX_XX {Tab} XXXXX
Body:
{Tab}xxxxxxxxxxxxxxxxxx {Tab}xxxxxxx{Tab}xxxxxxxxx
I''m exporting the results of a make table query in the same format with comma''s as the delimiter. Problem is in the header there is two delimiters between the second and third text column. I cant get the specs right to export a blank column. I''v tried using a , as the column name but the export comes out with an underhyphen as the name not a comma.
为公用事业公司工作，我们只允许使用逗号和句点测试一次交易。我不知道接收系统是否会接受分隔符的管道。
Working for a utility company and we were only allowed to test transactions once using a comma and a period. I don''t know if the receiving system will accept a pipe for the delimiter.
当您执行导出时，单击高级选项卡。您将看到显示的字段列表，可以操作它们，甚至可以隐藏它们。您也可以将更改保存为规范以备将来使用。
When you do the export click on the advanced tab. You will see a list of the fields displayed and can manipulate them, even hide them. You can also save your changes as a specification for future use.
大家好，
我正在尝试将查询结果导出到带有标题列的逗号分隔的.txt中。第一列总是空白。目前的格式是
标题：
XXXX {Tab} XXX_XX {Tab} {Tab} {Tab} XX_XXXX_XX {Tab } XXXXX
正文：
{Tab} xxxxxxxxxxxxxxxxxx {Tab} xxxxxxx {Tab} xxxxxxxxx
我正在出口make表查询的结果采用相同的格式，逗号为分隔符。问题出在标题中，第二个和第三个文本列之间有两个分隔符。我无法获得正确的导出空白列的规格。我尝试使用a作为列名，但导出时出现的是underhyphen，因为名称不是逗号。
Hello all,
I''m trying to export a the results of a query into a comma delimited .txt with the header colum. The fist column is always blank.The current format is
Header:
XXXX {Tab} XXX_XX {Tab} {Tab} {Tab} XX_XXXX_XX {Tab} XXXXX
Body:
{Tab}xxxxxxxxxxxxxxxxxx {Tab}xxxxxxx{Tab}xxxxxxxxx
I''m exporting the results of a make table query in the same format with comma''s as the delimiter. Problem is in the header there is two delimiters between the second and third text column. I cant get the specs right to export a blank column. I''v tried using a , as the column name but the export comes out with an underhyphen as the name not a comma.
这篇关于将空字段导出为.txt的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
