Redian新闻
>
急问: 问一个SQL的问题 在线等!
avatar
急问: 问一个SQL的问题 在线等!# Database - 数据库
s*n
1
有任何idea都可以

avatar
c*t
2
Microsoft Access Help:
Find or replace a value in a field

【在 s*******n 的大作中提到】
: 有任何idea都可以
:
: 中

avatar
s*n
3
Thank you! But it's not that simple. The data in this column has all kinds of
format like ABC 0, DEF 1, GH 123, IJKL123.... I think there should be some
kind of IIF statement to judge if I met a space or numerical symbol to remove
from the data. But I don't know how to write this SQL. HELP!!

除其

【在 c**t 的大作中提到】
: Microsoft Access Help:
: Find or replace a value in a field

avatar
c*t
4
You may use DBI + perl to do; or you need create function.

【在 s*******n 的大作中提到】
: Thank you! But it's not that simple. The data in this column has all kinds of
: format like ABC 0, DEF 1, GH 123, IJKL123.... I think there should be some
: kind of IIF statement to judge if I met a space or numerical symbol to remove
: from the data. But I don't know how to write this SQL. HELP!!
:
: 除其

avatar
r*y
5
用VBA写一段代码,用SQL取出来,处理了再用SQL写回去。很简单。

【在 s*******n 的大作中提到】
: 有任何idea都可以
:
: 中

avatar
s*n
6
Could you help me with the code? I'm not familiar with VBA. Thanks a lot!

除其

【在 r****y 的大作中提到】
: 用VBA写一段代码,用SQL取出来,处理了再用SQL写回去。很简单。
avatar
q*a
7
这个用excel做简单些吧。我想

【在 s*******n 的大作中提到】
: Thank you! But it's not that simple. The data in this column has all kinds of
: format like ABC 0, DEF 1, GH 123, IJKL123.... I think there should be some
: kind of IIF statement to judge if I met a space or numerical symbol to remove
: from the data. But I don't know how to write this SQL. HELP!!
:
: 除其

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。