How to replace each corresponding value #17720
natarajank11
started this conversation in
General
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I have two lists, say for an example:
FirstList("①","②","③","④","⑤","Ⅵ","Ⅶ","Ⅷ","Ⅸ","Ⅹ","㍉","㌔","㌢","㍍","㌘","㌧","㌃","㌶","㍑","㍗","㌍","㌦","㌣","㌫","㍊","㌻","㎜","㎝","㎞","㎎","㎏","㏄","㎡")
SecondList("(1)","(2)","(3)","(4)","(5)","VI","VII","VIII","IX","X","ミリ","キロ","センチ","メートル","グラム","トン","アール","ヘクタール","リットル","ワット","カロリー","ドル","セント","パーセント","ミリバール","ページ","mm","cm","km","mg","kg","cc","m2")
search for an character in the firstList, find an index. Find the character in the secondList using an index.
I want to match if the incoming text value is
⑤㍉㎡
, then output should be(5)ミリm2
.Likewise, i have more than 100 characters to match and get the result.
How to achieve this in trino?
Beta Was this translation helpful? Give feedback.
All reactions