Counting sub-strings: Using Subset
-
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
-
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/
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!
Categories
- All Discussions2,595
- General680
- Blog126
- Support1,177
- Ideas527
- Demos11
- Power tips72
- 3.0 preview2
Tagged
To send files privately to Visokio email support@visokio.com the files together with a brief description of the problem.