'\' appearing in string column causes the filtering not to work.

[ben-m-shields]

If \ appears in only a single entry, filtering does not work on that column.

[aclark02-arcus]

Hi @ben-m-shields, can you please be more specific? If a \ exists in your data fed to IDEAFilter? Please share a reproducible example that we can work through. Many thanks.

[ben-m-shields]

Hi, I noticed the error when doing large SQL queries then using IDEAFilter to explore the data. There was one \ in a single column of my dataset which caused the filtering to not work on that column.

Reproducible example below.

library(shiny)
library(IDEAFilter)
library(DT)

df <- data.frame(some_numbers = c(1,2,3,4,5,6,7,8,9),
some_letters = c('a','b','c','d','e','f','g','h','i'),
column_with_backslash = c('j', '\a', 'l', 'm', 'n', 'o', 'p', 'q', 'r'))

ui <- fluidPage(
titlePanel("Backslashes not working with IDEAFilter"),
sidebarLayout(
sidebarPanel(
IDEAFilter_ui("data_filter")),
mainPanel(
DTOutput("df_filtered")
)
)
)

server <- function(input, output, session) {
data_filtered <- IDEAFilter("data_filter", data = df)
output$data_filtered <- renderDT(data_filtered())
}

shinyApp(ui = ui, server = server)