Spotfire Ideas Portal
I would like to see the PAD (and/or LPAD/RPAD) function added to Spotfire. This is a common string function in many other DBMSs and tools.
Example use case:
I had a data source with one column containing SEQUENCE (i.e. integer 1-15) and another column called JOB NAME. I wanted to concatenate those two fields together to get something like: "1) Step One", "10) Step Ten". However, this doesn't sort correctly, so what I really want is "01) Step One." This could be easily accomplished with a PAD/LPAD function. But since it doesn't exist, I have to do a longer function combining IF and LENGTH.