c*t
2 楼
Microsoft Access Help:
Find or replace a value in a field
【在 s*******n 的大作中提到】
: 有任何idea都可以
:
: 中
Find or replace a value in a field
【在 s*******n 的大作中提到】
: 有任何idea都可以
:
: 中
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
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
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!!
:
: 除其
【在 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!!
:
: 除其
r*y
5 楼
用VBA写一段代码，用SQL取出来，处理了再用SQL写回去。很简单。
【在 s*******n 的大作中提到】
: 有任何idea都可以
:
: 中
【在 s*******n 的大作中提到】
: 有任何idea都可以
:
: 中
s*n
6 楼
Could you help me with the code? I'm not familiar with VBA. Thanks a lot!
除其
【在 r****y 的大作中提到】
: 用VBA写一段代码，用SQL取出来，处理了再用SQL写回去。很简单。
除其
【在 r****y 的大作中提到】
: 用VBA写一段代码，用SQL取出来，处理了再用SQL写回去。很简单。
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!!
:
: 除其
【在 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!!
:
: 除其
相关阅读
scalable database 是啥意思SOS: oracle startup failure!!!!!!!!!!!!![转载] MS SQL Server问题！urgent! Help Help Help with Accessview oracle table[转载] 标 题: 500万资金求项目Trouble shooting: uninstall the SQL server.Question 2: distributed database question?Question on SQL Queryabout how to use accessHow to access SQL Server from Unix?有FREE的DB2 DEMO 版吗?数据库题紧急求助：Transact-SQLcan I defragment win2k drive[转载] jdbc/odbc MS Access file creation questionHelp: 如何在oracle 9i 中添加1 个user?问题又来了，请过来人指点！PL/SQL cursor abstract type usage?about VB ActiveX[转载] Perl calls PL/SQL funtions