Field Data Manager Expression Editor

fdmexpressioneditor

TUTORIAL:

TelcoMgr's NPA-NXX-LINE fields were originally stored as a alpha-numerical string. For example the actual number, which was shown on the TelcoMgr "user window" as 800-###-####, was stored in the file as 8006752415. Therefore, since the window controlled the format or look of the number displayed this method restrict the number from appearing in any other format. However, with the "window" formatting removed, virtually any format arrange can be applied to the NPA-NXX-LINE field or the Canonical Formatted Subscriber Number [CFSN] field. To apply a format to the 8006752415 to the ###-###-#### format follow the steps below.

1.	In the Field Data Manager Browse Table select the NPA-NXX-LINE field;

2.	Click on the Express [...] button to the right of the Expression Column, the Assign Expression Editor window opens;

3.	In the Fuctions and Vars (for Variable) Column select the Format( Expression, Picture) option by double-clicking the word Format;

4.	Format( Expression , Picture ) with appear in the Assign expression field;

5.	Inside the Assign expression field highlight the word Expression so it appears like this >> Format( Expression , Picture );

6.	With the word Expression still highlighted double-click the Header Column NPA-NXX-LINE and your Assign expression field should look like this >> Format( CLIP( CIR:LINE ) , Picture );

7.	Next, highlight the word Picture so it appears like this >> Format( CLIP( CIR:LINE ) , Picture );

8.	Replace the highlighted word Picture; with exactly @p###-###-####p so your complete Formatted Expression looks like the line below:

9.	Format( CLIP( CIR:LINE ) , @p### ###-####p) ;(The semicolon is not included)

10.	Tab or click outside the Assign expression field and if you have correctly entered the information you should see the blue OK to the right of the field.

Help url: http://www.telcomgr.com?field_data_manager_expression_.htm