Needed help with substring functions

So, I have a table of search terms and count like this:

terms count
abcd 1500
ab%20cd 1400
cd%20efg 1300
cde%20fg 1200
cdef%20ghi 1100

I need to extract terms that have a minimum substring length of 3 before there’s a space(%20) , i.e.:

terms count
abcd 1500
cde%20fg 1200
cdef%20ghi 1100

How do I go about to extract this data. Any help is appreciated. Thanks in advance.

submitted by /u/dikshithvishnu
[link] [comments]


Go to Source of this post
Author Of this post: /u/dikshithvishnu
Title Of post: Needed help with substring functions
Author Link: {authorlink}