Advertisement
pfelipm

Campo calculado ordenación alfabética 🇪🇸 Data Studio

Nov 10th, 2021 (edited)
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. REGEXP_REPLACE(
  2. REGEXP_REPLACE(
  3. REGEXP_REPLACE(
  4. REGEXP_REPLACE(
  5. REGEXP_REPLACE(
  6. REGEXP_REPLACE(
  7. REGEXP_REPLACE(
  8. REGEXP_REPLACE(
  9. REGEXP_REPLACE(UPPER(Usuario),"L·L","L"),
  10. "Ç","C"),
  11. "Ñ","N"),
  12. "[ÚÜ]","U"),
  13. "[ÓÒ]","O"),
  14. "[ÍÏ]","I"),
  15. "[ÉÈ]","E"),
  16. "[ÁÀ]","A"),
  17. "LOS |LAS |DEL |DE |EL |LA |Y ", "")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement