Have you ever struggled with modifying your CWK document while on the go? Well, DocHub has an excellent solution for that! Access this online editor from any internet-connected device. It enables users to Clean attribute in CWK files quickly and anytime needed.
DocHub will surprise you with what it offers. It has powerful capabilities to make whatever updates you want to your forms. And its interface is so intuitive that the whole process from start to finish will take you only a few clicks.
When you finish adjusting and sharing, you can save your updated CWK document on your device or to the cloud as it is or with an Audit Trail that contains all changes applied. Also, you can save your paperwork in its initial version or transform it into a multi-use template - accomplish any document management task from anywhere with DocHub. Subscribe today!
[Music] hi everyone my name is melissa in this video well take a closer look at a custom function i created for problem of the week number two heres our messy data and the goal is to clean up all the text values in both columns for that task i created a clean text function so lets take a quick look at the m code this function takes one parameter called my text its value should be of type text and then the function returns a text value because not all of my variables listed below will return a text value declaring the return type will result in an error to prevent that error from happening i can comment that out for now if we want to see what the first variable returns all we have to do is refer to it by name after the in clause so im going to copy this to remove variable and im going to paste it in here and press ok lets view the result of that function we have to invoke it so lets add a custom column to this query invoke our function lets select this merged column and press ok