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

[Rayyl]

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

[binuacs · Accepted solution]

@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 solution]

@Rayyl 

[OllieClarke · Accepted solution]

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

[Rayyl]

Thanks guys!