Filter / parsing libre calc

[hanzogaksital]

Hello, Thanks for reading this,

I have a question about libre calc’s filtering functions

What I’m trying to do right now includes,

1. Download a Storage Permission Report as *.csv file
2. filter rows that contain only one " / "
   ex) 1. Myserver/blah ==> show this
   2. Myserver/Nah/oper/blow==> Don’t show this
   3. Myserver/Nigh ==> show this
   4. Myserver/nan/non ==> Don’t show this
   5. Myserver/blah/qwerty ==> Don’t show this

I’ve been looking for this function for quite a while, but it seems my searching capablilities are not that good,

If there is anyone who knows how to make this possible, please let me know

Even a reference can help, so please don’t hesitate.

Thank you in advance

[JohnSUN]

Welcome!
In general, you can calculate the number of specific substrings in a string using the formula

=(LEN(Source string)-LEN(SUBSTITUTE(Source string;Searched substring;"")))/LEN(Searched substring)

that is, in your case something like

=(LEN(A2)-LEN(SUBSTITUTE(A2;"/";"")))/LEN("/")

Because LEN("/")=1 it’s easier to write

=LEN(A2)-LEN(SUBSTITUTE(A2;"/";""))

For your example, the result would be {1|3|1|2|2}. Now just apply the filter by value 1.

[hanzogaksital]

OMG thank you very much, I’ll try it right away and let you know how it went

[hanzogaksital]

It worked like a charm, you’re a life saver, much obliged!!!

have a great day