oracle_merge_strings: Merge Two Strings Together Whilst Retaining an Order of Some...

In nhsbsa-data-analytics/nhsbsaR: NHSBSA R package

Merge Two Strings Together Whilst Retaining an Order of Some Kind

Description

This is intended to be used with differing address strings The result is a 'master' address string that contains all parts of each address

Usage

oracle_merge_strings(df, first_col, second_col, merge_col)

Arguments

df	Lazy Oracle table
first_col	First column
second_col	Second column
merge_col	Name to give merged column

Details

Requires nhsbsaR::oracle_unnest_tokens().

Value

original df with additional merged column added

Examples

## Not run: 
#' table_db %>%
  nhsbsaR::oracle_merge_strings(
    first_col = "ADDRESS_ONE",
    second_col = "ADDRESS_TWO",
    merge_col = "ADDRESS_MERGED"
  )
  
## End(Not run)

nhsbsa-data-analytics/nhsbsaR documentation built on Jan. 25, 2025, 8:54 a.m.