Visokio website     Downloads     Video tutorials     KnowledgeBase  
Counting sub-strings: Using Subset - Visokio Forums
Counting sub-strings: Using Subset
  • aa1708 November 17, 2016 7:17AM
    Hi there, I have a table with PhoneNum attribute in it. In the PhoneNum field, I have numbers starting with 0845, 0843, 0871 and so on. How can I count the total numbers starting with 0845, 0843 and so on?
    Attachments
    Omniscope_Forum.JPG 14K
  • 2 Comments
  •     paola November 17, 2016 8:41AM
    You could use a formula to 'cut off' the first 4 characters, then do aggregation on this field
    LEFT([Tel],4)

    More Omniscope formulas can be found here
    https://omniscope.me/FunctionsWEB.iok/
  • aa1708 November 17, 2016 11:15AM
    Thanks Paola, works perfectly
This discussion has been closed.
← All Discussions

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership