如何消除地址栏中的空白空间 [英] How to eliminate empty space in address column

问题描述

嗨


我的数据库有问题。



它是VB 6中的桌面应用程序，数据库是MSSQL 2014



我们的客户在地址栏输入数据如下

Hi
I have problem in my database.

It is desktop application in VB 6,Database is MSSQL 2014

Our client entered data in address column like below

NO.15, JALAN WELMAN, 
JALAN STORE 
TINGAKT TIGA
RAWANG,

但我需要单线如

But I need in single line like

NO.15, JALAN WELMAN,JALAN STORE,TINGAKT TIGA,RAWANG,

表中超过50000个数据。不能一个接一个。



请给我建议



Maideen



我尝试过：

More then 50000 data in table. Cannot do one by one.

Pls advice me

Maideen

What I have tried:

UPDATE [dbo].[MVendorMaster] SET [ADDRESS]= 	
LTRIM(RTRIM(REPLACE(REPLACE(REPLACE([address],CHAR(32),'()'),')(',''),'()',CHAR(32)))) 

推荐答案

您应该尝试执行以下操作

You should try doing the following

UPDATE MVendorMaster SET ADDRESS = REPLACE(REPLACE(REPLACE([ADDRESS], CHAR(13), ''), CHAR(10), ''), CHAR(9), '')

我相信CHAR值对应于以下

CHAR（9）是标签

CHAR（13）是回车

CHAR（10）是换行符

I believe the CHAR values correspond to the following
CHAR(9) is tab
CHAR(13) is carriage return
CHAR(10) is a line feed

这篇关于如何消除地址栏中的空白空间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！