如何删除access中空格后面的所有内容

发布于 2024-10-17 04:00:55 字数 169 浏览 5 评论 0原文

我有一个带有值的表->列名字：

Juan
Manuel l.
Richard Wit

我正在尝试执行一个查询，该查询返回

Juan
Manul
Richard

我想在空格后消除的值。

原文

I have a table->column first-name with values:

Juan
Manuel l.
Richard Wit

I'm trying to do a query that return

Juan
Manul
Richard

I want to eliminate after a space.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

朦胧时间 2024-10-24 04:00:55

假设您需要 SQL，请尝试

SELECT MID(name  + " a", 1, INSTR(name + " a", " ")-1) AS FirstName FROM myTable

在 VBA 中它会类似，因为 Mid() 和 InStr() 的工作方式与 Access-SQL 中完全相同

，但是，最好将名字和姓氏存储在单独的字段中，这样您就可以不必在 SQL 中做这种花招。

Assuming you want SQL, try

SELECT MID(name  + " a", 1, INSTR(name + " a", " ")-1) AS FirstName FROM myTable

In VBA it would be similar, since Mid() and InStr() work exactly the same as in Access-SQL

Really, though, it would be better to just store first and last name in separate fields so you don't have to do this sort of finagling in the SQL.

回复收藏 0 原文

ゞ记忆︶ㄣ 2024-10-24 04:00:55

SELECT Left([First-Name], InStr([First-Name] & ' ', ' ') - 1) As CleanFirstName
FROM table

请记住，运行此命令的效率很低，因为您将针对查询中的每条记录执行 VBA 函数。根据您使用它的方式，您可能希望查询返回完整字段并在事后进行处理。

SELECT Left([First-Name], InStr([First-Name] & ' ', ' ') - 1) As CleanFirstName
FROM table

Keep in mind that running this will be inefficient since you will be executing VBA functions against every record in your query. Depending on how you are using this, you may want to have the query return the full field and do the processing after the fact.

回复收藏 0 原文

~没有更多了~