Alpha Video Training
Results 1 to 3 of 3

Thread: Formating Imported Text

  1. #1
    Gary Ryder

    Default Formating Imported Text

    I am a new user to Alpha 5. I have data files I wish to import to Alpha 5. I am having a problem formating the imported text using a mask. Specifically, the phone number field. The imported data is a simple ascii text file (comma delimited). I have set the field mask to format properly for imported telephone numbers (ie: (505) 555-1212 ). The imported phone number in the ascii text file looks like this: 5055551212.

    When I import the file, the phone number is in the same format (5055551212). However, when I manually enter the phone number, the mask works properly.

    Question? How can I import "5055551212" and get "(505) 555-1212" in my telephone filed?

    Thanks, Gary

  2. #2
    Member RJGowan's Avatar
    Real Name
    Robert Gowan
    Join Date
    Apr 2000
    Aylmer, QC

    Default RE: Formating Imported Text

    I believe the masks only apply to inputting new values.

    You would have to update the field containing imported (and "unmasked") telephone numbers using an expression like:
    "("+substr(tel,1,3)+") "+substr(tel,4,3)+"-"+substr(tel,7,4)

    where tel is name of field with telephone number.

    If you've already added records, then you could add a filter

    for substr(tel,1,1)"("

    to ignore those that now have the mask.

    There may be a simpler way as there often is with Alpha

  3. #3
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000

    Default RE: Formating Imported Text


    Gary, most field rules are enforced only when entering or editing data through a form. These are UI level rules. A handful of rules are Engine level and are enforced by Alpha Five whether the changes are coming through a form or through direct manipulation of the table by a script or operation. Check the docs and related threads in this forum for a bit more information on these.

    What this means is that when you write scripts or use operations to directly manipulate your tables your script must perform necessary formatting that would otherwise be done by the UI level field rules.


Similar Threads

  1. Formating object text in a report
    By Gerry Duggan in forum Alpha Five Version 5
    Replies: 4
    Last Post: 09-27-2004, 02:52 AM
    By Rawlings in forum Alpha Five Version 5
    Replies: 0
    Last Post: 09-22-2004, 06:15 AM
  3. RTF for imported text
    By Ron Baker in forum Alpha Five Version 5
    Replies: 3
    Last Post: 09-11-2004, 04:25 PM
  4. Imported Text Problem
    By Lamon Small in forum Alpha Five Version 5
    Replies: 3
    Last Post: 07-11-2004, 04:36 PM
  5. Formating Letters
    By jpayne in forum Alpha Five Version 4
    Replies: 1
    Last Post: 03-28-2002, 09:38 PM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts