New Response
Cancel
Copy to Archive
Move to Archive
Document Library
Main Topic
Kurt Tomicich
2005/02/15
Procedure
Reference
Subject:
IP Addresses - seperating into octets
Category:
Tips\ Notes\ Programming
Version:
Revision Date:
2005/02/15
Modified:
2005/03/07
Reviewers
Originator
Previous
Current
Future
Kurt Tomicich
Kurt Tomicich/KRT
None
None
When you have an IP address and you want to strip it into seperate octets, use a formula. This example returns the first two octets of the IP Address in field "Source"
vFirst:=
@Left
(Source;
"."
);
vSecond:=
@Middle
(Source;
"."
;
"."
);
vThird:=
@MiddleBack
(Source;
"."
;
"."
);
vFourth:=
@Right
(Source;
"."
);
vGroup:=vFirst + vSecond;
vGroup
Submitted for review on 2/15/2005
Review completed by Kurt Tomicich on 3/7/2005
All Documents
   
By Author
   
By Category
   
By Alternate Name
   
Review Status
   
Help