deeejay

Tableau - String Functions

Jul 29th, 2015
522
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. Replace
  2. ===
  3. REPLACE('12-345-67', '-', '')
  4.  
  5. Add leading zeros (left pad)
  6. ===
  7. Right("000000" + Str([EmployeeID]),6)
  8.  
  9. Pretty print hard disk sizes
  10. ===
  11. IF
  12. LEN(STR([Size])) > 9 THEN LEFT(STR([Size]), 1) + "." + MID(STR([Size]), 2, 1) + " TB"
  13. ELSEIF LEN(STR([Size])) > 8 THEN LEFT(STR([Size]), 3) + "." + MID(STR([Size]), 2, 1) + " GB"
  14. ELSEIF LEN(STR([Size])) > 7 THEN LEFT(STR([Size]), 2) + "." + MID(STR([Size]), 2, 1) + " GB"
  15. ELSEIF LEN(STR([Size])) > 6 THEN LEFT(STR([Size]), 1) + "." + MID(STR([Size]), 2, 1) + " GB"
  16. ELSEIF LEN(STR([Size])) > 5 THEN LEFT(STR([Size]), 3) + "." + MID(STR([Size]), 2, 1) + " MB"
  17. ELSEIF LEN(STR([Size])) > 4 THEN LEFT(STR([Size]), 2) + "." + MID(STR([Size]), 2, 1) + " MB"
  18. ELSEIF LEN(STR([Size])) > 3 THEN LEFT(STR([Size]), 1) + "." + MID(STR([Size]), 2, 1) + " MB"
  19. END
Advertisement
Add Comment
Please, Sign In to add comment