我希望将记事本/Sql Server管理工具中的所有字符串转换为驼峰式并删除所有下划线。
例如:
string a = REFERENCE_DATA_ID
String b = ReferenceDataId
我想将字符串a中的下划线去掉,并转换为如字符串b所示的驼峰式大小写。请帮我解决这个问题。
我希望将记事本/Sql Server管理工具中的所有字符串转换为驼峰式并删除所有下划线。
例如:
string a = REFERENCE_DATA_ID
String b = ReferenceDataId
Find: ([a-z]+)[_]?([a-z]?)([a-z]+)[_]?([a-z]?)([a-z]+)[_]?([a-z]?)([a-z]+)\.php
Replace: $1\U$2\L$3\U$4\L$5\U$6\L$7
唯一的问题是需要知道下划线可以出现的最大次数以及字符串的结尾。 在上面的例子中,我将php文件名替换为camelCase,知道下划线不能超过3次,少于3次则没有问题。
假设您的数据已经在表中,它是否必须使用正则表达式?为什么不创建一个标量函数来完成这个任务,并按照以下步骤进行:
CREATE FUNCTION [dbo].[ProperCase]
(
@String VARCHAR(255)
)
RETURNS VARCHAR(255) AS
BEGIN
DECLARE @i INT
DECLARE @Char CHAR(1)
DECLARE @CorChar CHAR(1)
DECLARE @PrevAscii INT
DECLARE @PrevAscii2 INT
DECLARE @Ret VARCHAR(255)
/* Captalisation rules */
-- Capitalise first letter of each word
-- Capitalise next letter after special characters
-- eg joe o'bloggs-bloggs jr -> Joe O'Bloggs-Bloggs Jr
SET @Ret = ''
SET @i = 1
WHILE @i <= LEN(@String)
BEGIN
SET @Char = SUBSTRING(@String, @i, 1)
SET @CorChar = CASE WHEN @i = 1 THEN UPPER(@Char)-- First letter
WHEN @PrevAscii = 32 THEN UPPER(@Char)-- Follows Space
WHEN @PrevAscii = 39 AND @PrevAscii2 = 79 THEN UPPER(@Char)-- Follows O'
WHEN @PrevAscii = 45 THEN UPPER(@Char)-- Follows Dash
WHEN @PrevAscii = 46 THEN UPPER(@Char)-- Follows Fullstop
ELSE LOWER(@Char)
END
SET @Ret = @Ret + @CorChar
SET @i = @i + 1
SET @PrevAscii2 = @PrevAscii
SET @PrevAscii = ASCII(@CorChar)
END
--Now sort out capitalistaion for van, de, den, and der
SET @Ret = CASE WHEN @Ret LIKE 'Van %' THEN 'v' + SUBSTRING(@Ret,2,255) ELSE @Ret END
SET @Ret = CASE WHEN @Ret LIKE 'De %' THEN 'd' + SUBSTRING(@Ret,2,255) ELSE @Ret END
SET @Ret = CASE WHEN @Ret LIKE 'Der %' THEN 'd' + SUBSTRING(@Ret,2,255) ELSE @Ret END
SET @Ret = CASE WHEN @Ret LIKE 'Den %' THEN 'd' + SUBSTRING(@Ret,2,255) ELSE @Ret END
SET @Ret = REPLACE(@Ret,' De ',' de ')
SET @Ret = REPLACE(@Ret,' Der ',' der ')
SET @Ret = REPLACE(@Ret,' Den ',' den ')
RETURN @Ret
END