Hi Folks!
I have an items in my gallery for some reason there is a 4th row. How to remove this?
Hi @philifova
It looks like you potentially have a semi colon at the end of the strings you are trying to split. In this situation the split function will produce a blank row at the bottom of the result column to represent the right hand side of the last delimiter i.e. see below:
To resolve you could use the Left and Len functions to remove the last ";" - see below example:
Hope this helps