IPToSortableText ( IPaddress )

Returns a sortable textual representation of an IPaddress.

Average rating: 4.2 (33 votes) Log in to vote

Theo Ros - Show more from this author

Sample input:

IPToSortableText ( Get ( SystemIPAddress ) )

Sample output:

something like "192.168.000.001"

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*-------------------------------------------------------
Returns a sortable textual representation of an IPaddress.
To text-sort IP addresses, you will have to reformat the triplets.
Here it is done by adding leading zeros to them.
This will result in textvalues that will sort correctly, for instance
in a portal-sort solution.

Syntax: IPToSortableText ( IPaddress )
Return type: Text

IPToSortableText ( Get ( SystemIPAddress ) ) 
returns ip like "192.168.000.001"

Theo Ros
----------------------------------------------------------*/

Let ( ip = Substitute ( TrimAll ( IPaddress ; True ; 3 ) ; "." ; "¶" ) ;
  Right ( "000" & GetAsNumber ( LeftValues ( ip ; 1 ) ) ; 3 ) & "." &
  Right ( "000" & GetAsNumber ( MiddleValues ( ip ; 2 ; 1 ) ) ; 3 ) & "." &
  Right ( "000" & GetAsNumber ( MiddleValues ( ip ; 3 ; 1 ) ) ; 3 ) & "." &
  Right ( "000" & GetAsNumber ( MiddleValues ( ip ; 4 ; 1 ) ) ; 3 )
)

Returns a sortable textual representation of an IPaddress.
To text-sort IP addresses, you will have to reformat the triplets. Here it is done by adding leading zeros to them.
This will result in textvalues that will sort correctly, for instance in a portal-sort solution.

Syntax: IPToSortableText ( IPaddress )
Return type: Text

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

IPToSortableText ( IPaddress )

Comments

Support this website.

Support this website.