I ran into what appears to be a bug when using the Slice function. When I import data, in this case scores, it comes in the following format: W/L #-#. For example:
I am attempting to parse this data into three columns (a win/loss column, a points for column (the first number), and a points against column (the second number). When I attempt to use Slice for the win loss column, I tried the following formula:
The idea is that this will show either “L” or “W”. But, if the first number is a single digit, it shows the entire result. In the above example, that means the Win/Loss Column would look like this:
Since this is a suggestion box and is tangentially related, the Split function in Coda does not allow multiple inputs like Sheets, which makes parsing out a number from scores more complex.
Love Coda - just want to put this on someone’s radar.