Text function

Text function is used to trim spaces before and after the string, remove comma from the text, remove arguments from the text, calculate length of the text, convert text to lowercase, and convert text to uppercase.

Operation : TRIM

Select SET command from the action dropdown and provide a variable name in Element key where output will be stored, edit parameter section and click on Form, select functions from the dropdown and select TEXT function. Choose trim operation from the drop down and provide the data in the form.

After completing the step, it will look as below:

Operation : REMOVECOMMA

Select SET command from the action dropdown and provide a variable name in Element key where output will be stored, edit parameter section and click on Form, select functions from the dropdown and select TEXT function. Choose removecomma operation from the drop down and provide the data in the form.

After completing the step, it will look as below:

Operation : REMOVE

Select SET command from the action dropdown and provide a variable name in Element key where output will be stored, edit parameter section and click on Form, select functions from the dropdown and select TEXT function. Choose remove operation from the drop down and provide data and text to be removed in remove argument field in the form.

After completing the step, it will look as below:

Operation : LENGTH

Select SET command from the action dropdown and provide a variable name in Element key where output will be stored, edit parameter section and click on Form, select functions from the dropdown and select TEXT function. Choose length operation from the drop down and provide the data in the form.

After completing the step, it will look as below:

Operation : TOLOWERCASE

Select SET command from the action dropdown and provide a variable name in Element key where output will be stored, edit parameter section and click on Form, select functions from the dropdown and select TEXT function. Choose tolowercase operation from the drop down and provide the data in the form.

After completing the step, it will look as below:

Operation : TOUPPERCASE

Select SET command from the action dropdown and provide a variable name in Element key where output will be stored, edit parameter section and click on Form, select functions from the dropdown and select TEXT function. Choose touppercase operation from the drop down and provide the data in the form.

After completing the step, it will look as below: