Question

How to convert text to lowercase and remove spaces in one step

I frequently need to take text and make it lowercase, and remove spaces.

I was wondering if it was possible to do this in 1 formatter task instead of 2.

I thought a spreadsheet style formula would work, but it seems LOWER is not supported.

Is there anyway to do this in 1 step instead of 2?

Getting this:

The app returned "Unknown Function: LOWER".

even though LOWER is a common spreadsheet style formula.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

+6

A code or AI step can do it in one.

Zapier's my jam

I know this just seems like the kind of thing you should be able to do with a spreadsheet style formula.

+6

This is what’s available.

Zapier's my jam

Got it thank you. It seems like they could use some more text transformation functions, what they have is mostly number based.

+14

@gwinig

FYI: Formatter steps count as 0 Tasks in Zap Runs.

⚡ Troy Tessalone - AutomationAce.com | Platinum Authorized Zapier Solution Partner | #1 Zapier Community Contributor

I am aware just think it would be a nice addition to have more text functions in formulas so you can do a multiple things in 1 if you want.

+14

@gwinig

Feedback and feature requests can be submitted via a ticket to Zapier Support to be logged for future consideration: https://zapier.com/app/get-help

⚡ Troy Tessalone - AutomationAce.com | Platinum Authorized Zapier Solution Partner | #1 Zapier Community Contributor

Sign up