如果字段[Px]包含字符串[EM]，则从字段[Px]中删除字符串[EM] [英] If field[Px] contains string[EM], delete the string[EM] from the field[Px]

问题描述

早上好，


我需要协助查找并删除同一表中另一个字段[Px]中字段[EM]中找到的字符串。我已经尝试使用SQL并在没有数据的字段上返回#error，并且字段[EM]中的字符串仍然存在于[Px]中。

Tried& SQL失败：

Good Morning,

I need assistance with finding and deleting a string found in field[EM] from another field[Px] within the same table. I''ve tried in SQL and returned #error on fields with no data and the strings from field[EM] were still present in [Px].
One example of Tried & Failed in SQL:

展开 | 选择 < span class =codeDivider> | Wrap | 行号

推荐答案

我认为它不适合你，因为有您的SQL语句有些问题。

[em]周围有一个错字。

您使用Select语句而不是Update语句。也许你没有尝试更新数据，但没有更新声明，你只是返回结果。


这是一个正确语法的镜头，但它只是一个最好的猜测：

I think it''s not working for you because there are a few things wrong with your SQL Statement.
There''s a typo around [em].
Your using a Select statement instead of an Update Statement. Maybe your not trying to update the data, but without an Update Statement, you are just returning results.

This is a shot at the correct syntax, but it''s just a best guess:

展开 | 选择 | Wrap | 行号

当我运行它们时，查询表达式中的语法错误（缺少运算符）''替换（[来自SCAN的px]，*& [em]&" *"，""。）

When I ran them, "Syntax error (missing operator) in query expression ''Replace([px], "*" & [em] & "*","") from SCAN.

这是一个纯粹的猜测，但尝试

It''s a pure guess, but try

展开 | 选择 | 换行 | 行号

这篇关于如果字段[Px]包含字符串[EM]，则从字段[Px]中删除字符串[EM]的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！