How to get the 1st value before delimiter in sql server

y1aodyip 于 2023-04-19 发布在 SQL Server

关注(0)|答案(4)|浏览(130)

In one of the column i am getting 2 values with a delimiter between it How to extract both the values

I have some thing like this Column TRN02 is 115679-5757

I need to take values before delimiter and after delimter into 2 separate columns again.

Can some one help me on this

sql-server

来源：https://stackoverflow.com/questions/19547031/how-to-get-the-1st-value-before-delimiter-in-sql-server

4条答案

按热度按时间

igetnqfo1#

You can use SUBSTRING to do this:

SELECT 
    SUBSTRING(TRN02, 0, CHARINDEX('-', TRN02)) AS [First],
    SUBSTRING(TRN02, CHARINDEX('-', TRN02)  + 1, LEN(TRN02)) AS [Second]
FROM TABLE

赞(0）回复(0）举报 2023-04-19

q1qsirdb2#

Just another way USING LEFT and RIGHT -

SELECT LEFT(TRN02, CHARINDEX('-', TRN02) - 1) [before_delim],
       RIGHT(TRN02, LEN(TRN02) - CHARINDEX('-', TRN02)) [after_delim]
FROM your_table

赞(0）回复(0）举报 2023-04-19

ukxgm1gy3#

SELECT LEFT(details, CHARINDEX ('-', TRN02 ) - 1),
       SUBSTRING(details, CHARINDEX ('-', TRN02 ) + 1, 100) 
  FROM Your_table

赞(0）回复(0）举报 2023-04-19

pxy2qtax4#

update df set df.column=s.[value] FROM table df 
cross APPLY string_split(REPLACE(column, 'split_parameter', '@') ,'@') s  
where column like '%split_parameter%'  and s.[value] not like '=%'

赞(0）回复(0）举报 2023-04-19

我来回答

How to get the 1st value before delimiter in sql server

4条答案

相关问题

热门标签

最新问答