+ Reply to Thread
Results 1 to 3 of 3

Delete spaces at the end of field contents

  1. Delete spaces at the end of field contents

    Can anyone please tell me how to delete extra spaces and the end of
    text in fields. I have 16,650 records in my database from and old excel
    import. I want to discover a fast and efficient way to delete the
    spaces at the end of multiple values in my database fields.

    Thanks


  2. Re: Delete spaces at the end of field contents

    Make sure you have all records in the found set (Records > Show All
    Records). Click into the field. Go to the records menu > Replace
    Records. Click 'by calculation' and specify that it should be:
    Trim(YourFieldName). The Trim() function will remove all spaces at the
    beginning and end of the field in each record.

    Snake Driver wrote:
    > Can anyone please tell me how to delete extra spaces and the end of text
    > in fields. I have 16,650 records in my database from and old excel
    > import. I want to discover a fast and efficient way to delete the spaces
    > at the end of multiple values in my database fields.


  3. Re: Delete spaces at the end of field contents

    Snake Driver wrote:

    > Can anyone please tell me how to delete extra spaces and the end of
    > text in fields. I have 16,650 records in my database from and old excel
    > import. I want to discover a fast and efficient way to delete the
    > spaces at the end of multiple values in my database fields.


    enter browse mode
    find all records
    go to first record
    loop
    set field (yourField; trim(yourField)
    go to next record, exit after last
    end loop

    I don't know how long that will take. And you may want to backup your
    data first. Good luck.
    --
    http://clk.ch

+ Reply to Thread