Currently, I have a string column with both US and Korean data. I cannot find a way to sort this table correctly in a microflow. My goal is to have display ascendingly in US first then ascendingly in Korean. I tried ORDER BY in OQL and List Operation in Microflow but the data were mixed between two languages in both cases. Please help.
asked
Han Nguyen
1 answers
1
Hey
Is there any flag available to know if the string is in Korean or English language?
If not, you can detect language using regular expressions and create two list variables for english and Korean followed by sorting both lists separately.