Find a keyword in columns or values, in all the datasets of the database.
Usage
edc_find_value(keyword, ignore_case = TRUE, data = get_datasets())
edc_find_column(keyword, ignore_case = TRUE, data = edc_lookup())Examples
db = edc_example()
#> Warning: Option "edc_lookup" has been overwritten.
load_database(db)
edc_find_value("respi")
#> Warning: Could not find 8/8 datasets from the lookup, did you forget to call
#> `load_database()` on your import?
#> ℹ "long_pure", "data1", "long_mixed", "data2", "data3", "enrol", "short", and
#> "ae"
#> Error in mutate(., column_label = unlist(data_labels[column]) %0% NA): ℹ In argument: `column_label = unlist(data_labels[column]) %0% NA`.
#> Caused by error:
#> ! object 'column' not found
edc_find_value(2010)
#> Warning: Could not find 8/8 datasets from the lookup, did you forget to call
#> `load_database()` on your import?
#> ℹ "long_pure", "data1", "long_mixed", "data2", "data3", "enrol", "short", and
#> "ae"
#> Error in mutate(., column_label = unlist(data_labels[column]) %0% NA): ℹ In argument: `column_label = unlist(data_labels[column]) %0% NA`.
#> Caused by error:
#> ! object 'column' not found
edc_find_column("ad")
#> # A tibble: 1 × 4
#> dataset crfname names labels
#> <chr> <chr> <chr> <chr>
#> 1 ae Adverse events aegr AE grade
edc_find_column("date")
#> # A tibble: 11 × 4
#> dataset crfname names labels
#> <chr> <chr> <chr> <chr>
#> 1 data1 data1 date1 Date at visit 1
#> 2 data1 data1 date2 Date at visit 2
#> 3 data1 data1 date3 Date at visit 3
#> 4 data2 data2 date4 Date at visit 4
#> 5 data2 data2 date5 Date at visit 5
#> 6 data2 data2 date6 Date at visit 6
#> 7 data3 data3 date7 Date at visit 7
#> 8 data3 data3 date8 Date at visit 8
#> 9 data3 data3 date9 Date at visit 9
#> 10 data3 data3 date10 Date at visit 10
#> 11 enrol enrol enrol_date Date of enrolment
#with regex
edc_find_column("\\d")
#> # A tibble: 16 × 4
#> dataset crfname names labels
#> <chr> <chr> <chr> <chr>
#> 1 long_pure long data val1a val1a
#> 2 long_pure long data val2a val2a
#> 3 data1 data1 date1 Date at visit 1
#> 4 data1 data1 date2 Date at visit 2
#> 5 data1 data1 date3 Date at visit 3
#> 6 long_mixed both short and long data long1 long1
#> 7 long_mixed both short and long data long2 long2
#> 8 data2 data2 date4 Date at visit 4
#> 9 data2 data2 date5 Date at visit 5
#> 10 data2 data2 date6 Date at visit 6
#> 11 data3 data3 date7 Date at visit 7
#> 12 data3 data3 date8 Date at visit 8
#> 13 data3 data3 date9 Date at visit 9
#> 14 data3 data3 date10 Date at visit 10
#> 15 short short data val1 val1
#> 16 short short data val2 val2
edc_find_column("\\(") #you need to escape special characters
#> # A tibble: 1 × 4
#> dataset crfname names labels
#> <chr> <chr> <chr> <chr>
#> 1 enrol enrol age Age (years)