mid_xl: mid_xl function

In NHSDataDictionaRy: NHS Data Dictionary Toolset for NHS Lookups

Description

This function replicates the MID function in Excel and is utilised for left trimming of character strings.

Usage

mid_xl(text, start_num = 1, num_char = 0)

Arguments

text	The text you want to MID trim
start_num	The start number to start the trim. This needs to be numeric.
num_char	The number of characters your want to trim by. This field needs to be numeric.

Details

This has been included as a convenience function for working with text and string data.

Value

The extracted text between the start_num and the num_char to produce a sub string result.

Examples

mid_xl(text= "This is some example text", start_num = 6, num_char = 10)


mid_xl(text= "This is some example text", start_num = 6, num_char = 10)

NHSDataDictionaRy documentation built on July 9, 2021, 5:08 p.m.