Remove rows with a specific Number at the beginning and fixed size

Question

Hello everyone, a short and probably simple question for you. How can I remove certain rows in a column that start with a certain number and have a fixed size (see attachment, for example the number "5" with a size of 8 digits, so that basically only the "58913" remains). Thanks in advance!

Best regards

Frage Alteryx2.png

binu_acs · Accepted Answer

@Rayyl use the Functions StartsWith() and Length()

in the filter tool set the condition like below

StartsWith(toString([Invoice Number])),'5')
AND
Length(toString([Invoice Number) <= 8)

.

MilindG · Accepted Answer

@Rayyl

OllieClarke · Accepted Answer

Hi @Rayyl I think what you want is the following custom filter:

NOT (Startswith(tostring([Invoice Number]),'5')
AND 
Length(ToString([Invoice Number]))=8)

This will remove any 8 character Invoice Numbers which start with a 5

Hope that helps,

Ollie