场地尽头的空间 [英] Space at the end of the field

问题描述

我使用A2K应用程序。当从源代码下载时，我的数据显示为

，如下所示：

问题ID产品

16957 TickettingApplication;

22620 TicketingApplication;

13021 TicketingServices;

11470 TicketingServices;

16886 TicketingServices;

16990 TicketingServices;

16512 EDTSOrderAdaptercomponent;

22633 TRADINGSERVICES;


我需要没有数据的地方文本和半文件之间的空格

冒号。（半冒号跟随文本）。如何识别文本后面的空格
文本后立即生成半冒号文本？

总结一下，我想要像TicketingApplication这样的数据;而不是

TicketingApplication;


谢谢，

Roy

I use a A2K application.When downloading froma source,my data appears
like this:
Problem Id Product(s)
16957 TickettingApplication;
22620 TicketingApplication;
13021 TicketingServices;
11470 TicketingServices;
16886 TicketingServices ;
16990 TicketingServices ;
16512 EDTSOrderAdaptercomponent ;
22633 TRADINGSERVICES ;

I need the data where there is no space between the text and the semi
colon.(the semi colon follows the text).How to identify the space after
the text and have the semi colon immediately after the text?
To summarize,i want the data like,TicketingApplication; and not as
TicketingApplication ;

Thanks,
Roy

推荐答案

你可以通过在导入

之后在桌面上运行更新查询来实现这一点，如下所示：


UPDATE tblTest SET tblTest.Field1 = Left（[Field1]，Len（[Field1]） - 2）& '';''

WHERE（（（tblTest.Field1）喜欢''*;''））;


" Roy" < PR ******** @ yahoo.com>在消息中写道

news：11 ********************** @ g44g2000cwa.googlegr oups.com ...

You could do this by running an update query on the table after importing
it, something like this:

UPDATE tblTest SET tblTest.Field1 = Left([Field1],Len([Field1])-2) & '';''
WHERE (((tblTest.Field1) Like ''* ;''));

"Roy" <pr********@yahoo.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...

我使用A2K应用程序。当从源代码下载时，我的数据显示如下：
问题ID产品
16957 TickettingApplication;
22620 TicketingApplication;
13021 TicketingServices;
11470 TicketingServices;
16886 TicketingServices;
16990 TicketingServices;
16512 EDTSOrderAdaptercomponent;
22633 TRADINGSERVICES;

我需要在文本和半结肠之间没有空格的数据。（半冒号跟随文本）。如何识别文本之后的空格并在文本后面立即生成半冒号总结一下，我想要像TicketingApplication这样的数据;而不是票务申请;

谢谢，
Roy

I use a A2K application.When downloading froma source,my data appears
like this:
Problem Id Product(s)
16957 TickettingApplication;
22620 TicketingApplication;
13021 TicketingServices;
11470 TicketingServices;
16886 TicketingServices ;
16990 TicketingServices ;
16512 EDTSOrderAdaptercomponent ;
22633 TRADINGSERVICES ;

I need the data where there is no space between the text and the semi
colon.(the semi colon follows the text).How to identify the space after
the text and have the semi colon immediately after the text?
To summarize,i want the data like,TicketingApplication; and not as
TicketingApplication ;

Thanks,
Roy

布鲁斯，

它附带一条消息，说0条记录已更新。意思是

没有确定空间？


非常感谢，


Roy

Bruce,
It comes with a message saying 0 records updated.Meaning it
did not identify the space?

Thanks much,

Roy

您是否在询问如何防止这种情况发生？如果是这样，我们将需要更多有关此数据来源的详细信息。

如果您想知道如何清理数据，可以使用在Visual Basic中使用

replace（）函数并执行类似

replace（strThisData，" ;;"，" ;;"）的操作，可能循环访问数据带

记录集。


希望有帮助

-John


" ;罗伊" < PR ******** @ yahoo.com>在消息中写道

news：11 ********************** @ g44g2000cwa.googlegr oups.com ...

Are you asking how to prevent this situation from happening? If so, we''d
need more details about where this data is coming from.
If you are wanting to know how to clean up the data, you could use the
replace() function in visual basic and do something like
replace(strThisData, " ;" , ";"), perhaps looping through the data with a
recordset.

hope that helps
-John

"Roy" <pr********@yahoo.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...

我使用A2K应用程序。当从源代码下载时，我的数据显示如下：
问题ID产品
16957 TickettingApplication;
22620 TicketingApplication;
13021 TicketingServices;
11470 TicketingServices;
16886 TicketingServices;
16990 TicketingServices;
16512 EDTSOrderAdaptercomponent;
22633 TRADINGSERVICES;

我需要在文本和半结肠之间没有空格的数据。（半冒号跟随文本）。如何识别文本之后的空格并在文本后面立即生成半冒号总结一下，我想要像TicketingApplication这样的数据;而不是票务申请;

谢谢，罗伊

I use a A2K application.When downloading froma source,my data appears
like this:
Problem Id Product(s)
16957 TickettingApplication;
22620 TicketingApplication;
13021 TicketingServices;
11470 TicketingServices;
16886 TicketingServices ;
16990 TicketingServices ;
16512 EDTSOrderAdaptercomponent ;
22633 TRADINGSERVICES ;

I need the data where there is no space between the text and the semi
colon.(the semi colon follows the text).How to identify the space after
the text and have the semi colon immediately after the text?
To summarize,i want the data like,TicketingApplication; and not as
TicketingApplication ;

Thanks,
Roy

这篇关于场地尽头的空间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！