Wednesday, March 24, 2021

OIC - Use of Translate function

Requirements: To remove the aposthrope (') from a string.

Format:

translate($variable_name,"'",'')

We can also replace one special char to another one using translate function.

No comments:

Post a Comment

Featured Post

Microsoft Excel - Excel Data Validation

 Working... Excel Data Validation 1. Understanding the Need for Excel Data Validation Data Validation in Excel helps control the type of d...