建议在数据库中处理

oracle参考

-----------------------

with aa as

 (select 'AsdfsCddfd' as kk  from dual

  union all

  select 'aa哈哈FsdfsCddfd' as kk  from dual)

SELECT REGEXP_REPLACE(kk, '[^A-Z]', '') AS uppercase_letters FROM aa;

在BI中不好处理，直接在sql的数据源中处理，在BI数据源中加上这一列吧，比如在oracel中类似这样

  with your_table  as(

SELECT 'A11s4t7DE64srtoi' AS your_column

FROM dual )

select LISTAGG(t.uppercase_letter,'') WITHIN GROUP (ORDER BY uppercase_letter) as 拼接列  from (

SELECT REGEXP_SUBSTR(your_column, '[A-Z]', 1, LEVEL) AS uppercase_letter

FROM your_table

CONNECT BY REGEXP_SUBSTR(your_column, '[A-Z]', 1, LEVEL) IS NOT NULL

  AND PRIOR your_column = your_column

  AND PRIOR SYS_GUID() IS NOT NULL) t

如果数据源都是类似于First Class这样的格式，可以先用拆分行列将First Class拆分成2列，分别为列1、列2，然后用CONCATENATE(LEFT(列1 ,1),LEFT(列2,1)......)拼接即可