Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Location
    Austin, TX
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Data format (2002)

    I would like to get help in changing the format for an input field.

    The data is currently entered/stored as '0000000"HU";

    I need to be able to input/store the data as 0000000"HU"; 0000000"AU"; or 0000000"SU";

    Thanks for your help

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Data format (2002)

    Are you saying you actually have double quotes embedded in the field value? If so, don't do that. Double quotes are commonly used as delimiters and embedded double quotes can play hob with imports and exports of data between formats. Leading zeroes like that can only be strings anyhow, not numbers, so the whole thing has to be stored as a string. Why don't you explain what you're using them for so we can be more helpful.
    Charlotte

Posting Permissions

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