본문 바로가기

문자열

 (10)
[python][jellyfish] 문자열 유사도 (jaro distance) 두 문자열간 유사도를 알아보는 라이브러리 예제입니다. python 3.x 버전import jellyfish class table_object(object): def __init__(self, table, column_text): self.table = table self.column_text = column_text table_objects = [] table = u"AAAA_57M" column_text = u"PN_YY#C_ORG#C_ERP#C_SHP#Q_PN01#Q_PN02#Q_PN03#Q_PN04#Q_PN05#Q_PN06#Q_PN07#Q_PN08#Q_PN09#Q_PN10#Q_PN11#Q_PN12#Q_PN13#Q_PN14#Q_PN15#Q_PN16#Q_PRD01#Q_ETC01#Q_PRD02#Q_ETC..
[mssql] substring 문자열 자르기 DECLARE @addressCode CHAR(10) = '1147010100' SELECT SUBSTRING(@addressCode, 1,2) AS sidoCode -- 11 , SUBSTRING(@addressCode, 3,3) AS gugunCode -- 470 , SUBSTRING(@addressCode, 6,3) AS dongCode -- 101 , SUBSTRING(@addressCode, 9,2) AS riCode -- 00 demo : http://rextester.com/DHEU53218 mssql 은 시작점이 javascript 나 기타 언어들과 다르게 1부터 시작한다. 링크 : javascript 문자열 자르기
[mssql] SP에서 특정 TEXT 검색 use {{databaseName}} SELECT DISTINCT 'EXEC sp_helptext [' + SCHEMA_NAME(SCHEMA_ID) + '.' + OBJECT_NAME(A.id) + ']' FROM sys.syscomments A INNER JOIN sys.objects B ON A.id = B.object_id WHERE TEXT LIKE '%{{검색어}}%' SELECT OBJECT_NAME(object_id) FROM sys.sql_modules WHERE definition LIKE '%{{검색어}}%' 출처 : http://modellerr.tistory.com/35
[includes] 문자열 포함 여부 확인 var value1 = '100030'; var value2 = '1000/30'; var result1 = value1.includes('/'); var result2 = value2.includes('/'); alert(result1 + ' | ' + result2); jsfiddle demo link
[javascript] substring 문자열 자르기 HTML javascript var addressCode = '1174010300'; var result1 = addressCode.substring(0,2); var result2 = addressCode.substring(2,5); var result3 = addressCode.substring(5,8); document.getElementById("result").innerHTML = result1 + '|' + result2 + '|' + result3; demo link https://jsfiddle.net/yagdmirage/pk3zyduf/2/
[C#]문자열에서 실수부분만 추출 /// /// 문자열에서 실수부분만 추출 /// /// /// public string getRealNumber(string number) { string tempValue = "0"; try { Regex pattern = new Regex(@"[0-9]+(\.|\,)[0-9]+"); Match match = pattern.Match(number); tempValue = match.Value; } catch (Exception ex) { Console.WriteLine(ex.ToString()); } return tempValue; }
[function] 문자열에서 숫자만 뽑아내기 CREATE FUNCTION fn_GetNumeric (@strAlphaNumeric VARCHAR(256)) returns VARCHAR(256) AS BEGIN DECLARE @intAlpha INT SET @intAlpha = Patindex('%[^0-9]%', @strAlphaNumeric) BEGIN WHILE @intAlpha > 0 BEGIN SET @strAlphaNumeric = Stuff(@strAlphaNumeric, @intAlpha, 1, '') SET @intAlpha = Patindex('%[^0-9]%', @strAlphaNumeric) END END RETURN Isnull(@strAlphaNumeric, 0) END 예) SELECT dbo.fn_GetNumeric('1..
[function] 구분자가 있는 문자열 테이블로 만들기 CREATE FUNCTION [dbo].[fn_Split]( @pSource NVARCHAR(MAX), @pSeparator VARCHAR(1))RETURNS @TAB_RETURN TABLE( ItemIndex INT, ItemValue NVARCHAR(1000))ASBEGIN DECLARE @buffer VARCHAR(MAX); DECLARE @item NVARCHAR(MAX); DECLARE @tmp INT; DECLARE @index INT; SET @index = 1; WHILE LEN(@pSource) > 0 BEGIN SET @tmp = CHARINDEX(@pSeparator, @pSource); IF @tmp > 0 BEGIN SET @item = SUBSTRING(@pSource, 1, @..

티스토리툴바