Unanswered

What expression would I use to filter based on the beginning part of a cell

(1) Share

Report

Posted on by rmartori

So I have to collect codes from people, they do not want to give me these codes. It is becoming a problem and there are a lot of them.

THe codes should start with a 02 or 01 (sometimes they accidentally leave off the 0 so starting with 2 or 1 in that rare case)

They will either just put N/A, TBD, or give an incorrect code that starts with 800 (I literally have a not saying dont do that as well IN RED!)
So I want to have a bot go through this list checks the code column for anything that doesnt begin 01, 02, 1, or 2 and sends them an email
But I am not sure what expression that would be

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Can you include a screenshot please

Was this reply helpful? Yes No
tfairhurst 3 on at

Like (1)

Report
Copy link

Link copied!

What table/database are you trying to filter? Not sure how to help otherwise.

Was this reply helpful? Yes No
MS-23070606-0 on at

Like (2)

Report
Copy link

Link copied!

Write a function with substring('your text',0,4) to get the first four characters. If this doesn't help then I would need some more information.

Was this reply helpful? Yes No
Sayan 818 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hey can you please share the Workflow as well as attach some screenshots.

Was this reply helpful? Yes No