如何修改字段中所有记录的格式？ [英] How can I modify the format of all records in a field?

问题描述

我有两个表都有邮政编码字段，但记录以加拿大邮政编码A0A0A0和A0A 0A0的两种不同格式输入。同样，输入电话号码[phone]和（000）000-0000

如何更新其中一个表中的这两个字段，使它们的格式相同？


我在Windows XP专业版上使用Access 97


提前谢谢。

I have two tables that both have a postal code field but the records are entered in two different formats for Canadian Postal code, A0A0A0 and A0A 0A0. Similarly, phone numbers are entered [phone] and [phone]
How can I update these two fields in one of the tables so that they both are in the same format?

I am using access 97 on Windows XP Pro

Thank you in advance.

推荐答案

不幸的是，你没有给出任何字段或表名，所以我必须为你发明一些。

这个SQL代码将使用额外的空格来更新表剥离它们：

Unfortunately, you don''t give any field or table names so I''ll have to invent some for you.
This SQL code will update the table with the extra spaces in to strip them out :

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

我有两个表都有一个邮政编码字段，但记录以加拿大邮政编码A0A0A0和A0A的两种不同格式输入0A0。同样，输入电话号码[phone]和（000）000-0000

如何更新其中一个表中的这两个字段，使它们的格式相同？


我在Windows XP专业版上使用Access 97


提前谢谢。

I have two tables that both have a postal code field but the records are entered in two different formats for Canadian Postal code, A0A0A0 and A0A 0A0. Similarly, phone numbers are entered [phone] and [phone]
How can I update these two fields in one of the tables so that they both are in the same format?

I am using access 97 on Windows XP Pro

Thank you in advance.

以相反的顺序，假设邮政编码包含在名为[Postal]的字段中，并且该字段仅限于6个字母数字字符，则

In reverse order, assuming that the Postal Code is contained in a Field named [Postal], and that Field is restricted to exactly 6 alphanumeric characters, then

展开 | 选择 | Wrap | 行号

不幸的是，你不提供任何字段或表名称所以我将不得不为你创造一些。

这个SQL代码将更新表中的额外空格以将它们剥离出来：

Unfortunately, you don''t give any field or table names so I''ll have to invent some for you.
This SQL code will update the table with the extra spaces in to strip them out :

展开 | 选择 | 换行 | 行号

这篇关于如何修改字段中所有记录的格式？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！