I have some fields that contain ranges, like 14555.00-17356.00 or 685.00-1234.00. There are also many single values, like 876.00 or 32359.00.
To top it off, they're in a varchar field..
I'm getting an oracle error, I think on the - marks.
How can I create a calculated field that will only read up to the - mark, or ignore everything afterwards?
Further, are these types of range fields of any particular use in Tableau?
Thanks so much!
Assuming it's ending up as a string in Tableau as well, you could find the position of the "-" using find() to parse the start and end values.
for the left value