I would like to remove the first character from the values of a column within a Bold BI expression. For example, *abc -> abc.

Bold BI's documentation for string expressions mentions a LEFT function to remove characters from the start of a string, but I'm looking to keep everything except for the first character.

I would like to remove the first character from the values of a column within a Bold BI expression. For example, *abc -> abc.

Bold BI's documentation for string expressions mentions a LEFT function to remove characters from the start of a string, but I'm looking to keep everything except for the first character.

• bold-bi

1 Answer 1

You can combine RIGHT() and LEN(), similar to how you would in SQL.

RIGHT([ColumnName], LEN([ColumnName]) -1)

The function RIGHT() takes two arguments, the string you want to modify and the number of characters to keep from the end of the string. LEN() returns the length of the string, so we subtract the number of characters we want to remove, which is 1 in this case.