Brian Dunning's FileMaker Custom Functions

cfISRC ( pMode ; pISRC_Code ; pRGB_OnError )

ISRC formatting / validating

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

Tammo Fornalik / Felix Hausberner   Tammo Fornalik / Felix Hausberner
dbyte solutions
http://www.dbyte-solutions.com

Share on Facebook Share on Twitter

  Sample input:
[1] cfISRC("format"; "FRZ039800212"; RGB(255;0;0) )

[2] cfISRC("format"; "2GHH3276654F"; RGB(255;0;0) )

[3] cfISRC("check"; "2GHH3276654F"; RGB(255;0;0) )
  Sample output:
[1] FR-Z03-98-00212
[2] •WRONG INPUT
[3] 1

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

ISO 3901:2001. ISRC example (formatted): FR-Z03-98-00212 .

according to the ISRC specs there is no checksum, so the verification part is an approximation.

pMode = "format": formats given string to readable ISRC or throws an error text if input is not correct.
pMode = "check": tests on correct input only. returns 1 if input is incorrect, 0 if correct (!)

 

Comments

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.