Teradata 字符串操作(第二个空格) [英] Teradata String Manipulation (Second Space)

问题描述

我很难解决这个看似简单的任务:

I'm having great difficulty solving this seemingly easy task:

目的:创建一个消除中间 Initial 的查询

Purpose: Create a query that eliminates the middle Initial

示例

Name
Smith, John A
Jane, Mary S

我想要这样的输出:

Name
Smith, John
Jane, Mary

有关如何使用 Teradata SQL 执行此操作的任何提示

Any tips on how to do this with Teradata SQL

我相信我解决了这个问题，尽管方法很糟糕:

I believe I solved the issue, albeit in a very poor way:

SELECT SUBSTR('SMITH, JOHN A', 0, (POSITION(' ' IN 'SMITH, JOHN A') + (POSITION(' ' IN SUBSTR('SMITH, JOHN A',(POSITION(' ' IN 'SMITH, JOHN A'))+ 1,50)))))

推荐答案

select a,
substr(a,1,index(a,' '))|| substr(trim(substr(a,index(a,' '))),1,index(trim(substr(a,index(a,' '))),' ')),
substr(trim(substr(a,index(a,' '))),index(trim(substr(a,index(a,' '))),' ')) last_name
from a

这篇关于Teradata 字符串操作(第二个空格)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！