Unmerge a Strip

This function unmerges an OMOP concept strip created by a 'merge' function using the tidyr extract function. If the input is not a tibble, it will be converted into one with the blanks and "NA" values normalized to `<NA>`. A warning is returned in the console if some concepts fail to unmerge into their respective concept table fields, as determined by all the new column fields having a value of `<NA>` with a non-`<NA>` value in the strip_col instance inputed. Errors will be thrown if the data input already contains columns that will collide with the new columns, the names of which defaults to the names of the original concept table fields: concept_id, concept_name, domain_id, vocabulary_id, concept_class_id, standard_concept, concept_code, invalid_reason. Note that the original concept table fields `valid_start_date` and `valid_end_date` are the only concept table fields are not a requirement in the merge and unmerging process.

unmerge_strip(
  data,
  strip_col,
  suffix = NULL,
  prefix = NULL,
  remove = TRUE,
  r_trimws = TRUE
)

Arguments

data	dataframe
strip_col	column that contains the merged concept strip
remove	remove argument passed to the tidyr extract function. If TRUE, removes strip_col in output.
r_trimws	Due to some of the carriage returns in aggregate transformations and other edits in Excel, r_trimws is an argument that if TRUE, trims right whitespace of the freshly unmerged columns for any trailing carriage returns.

Value

a tibble with all blanks, "NA", and <NA> normalized to NA, with unmerged columns with or without the provided prefix and suffix pasted in postions 1 to 8, followed by the strip column if the remove parameter is FALSE, and the remaining fields present in the input.

See also

tidyeval-compat,mutate_all,vars,reexports,select,filter_all,all_vars extract as_tibble normalize_all_to_na str_remove,str_replace trimws

Other concept format functions: filter_at_all_strip(), filter_at_any_strip(), filter_strip(), get_strip(), label_to_strip(), merge_label(), merge_strip(), unbox_label(), unbox_strip(), unmerge_label()