How do I count the number of characters in a cell, like the LEN function in excel?

You can use the Custom transform step to count the number of characters in a cell using a plain language prompt. For example: “Calculate the number of characters in column [X]”.

With just a simple prompt, the step will calculate the numbers of characters in each cell of your determined column and add a new column to your dataset, with a title of your choosing, that shows the character length of each cell within a given column.