yql/essentials/udfs/common/unicode_base/test/cases/BlockRemove.sql


1
2
3
4
5
6
7
8
9
10
11
12

/* syntax version 1 */

pragma UseBlocks;

SELECT 
    value as value,
    Unicode::RemoveAll(value, "фа"u) AS all,
    Unicode::RemoveFirst(value, "а"u) AS first,
    Unicode::RemoveLast(value, "а"u) AS last,
    Unicode::RemoveFirst(value, "фа"u) AS first2,
    Unicode::RemoveLast(value, "фа"u) AS last2
FROM Input;