Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Course Of The Month
9 days, 23 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Finding the First Number in a field
Posted on 2006-06-08
Is there a formula that could look up the first # in a text field?
Example
I have QFRS755-1-1 in a field. I would need to have the formula return "7"
Example
I have QFRS755-1-1 in a field. I would need to have the formula return "7"
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
2 Comments
Active 7 days ago
have you tried:
left(getasnumber (field);1) ?
I have no fm to test that now...
if it does not work, try:
left ( getasnumber (field) * 1 ; 1 )
normally, the multiplication should clear off the characters and keep only the numbers from data (that was true for v6)
left(getasnumber (field);1) ?
I have no fm to test that now...
if it does not work, try:
left ( getasnumber (field) * 1 ; 1 )
normally, the multiplication should clear off the characters and keep only the numbers from data (that was true for v6)
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?"
An…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move. In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash"
After Shake : http://www.videocopilot.net/presets/after_shake/
All lightning effects with instructions : http://www.mediaf…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month9 days, 23 hours left to enroll
623 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.