Filter cells containing more than X characters

Hello,

I’m exporting to google sheets and I run into an error once I go live.
It says I have exceeded the number of characters in one cell.

Do you know if there is a way to filter the cells that contain more than X characters so I can handle them manually?

Thank you very much,
Joachim

Hi @Joachim_Brindeau :wave:

Try using an “Extract text from column” step and configure your settings to Find all text after... and select Offset from beginning of text...

Set your desired character count as your Offset Length.

You can then use a “Filter rows” step to Keep rows that are not blank. The final dataset below represents a list of rows that have a character count greater than 5.

Let me know if that helps!

1 Like

Thanks a lot! Will try and let you know! :grin: