Alpha Video Training
Results 1 to 6 of 6

Thread: Append .jpg to data of an entire column

  1. #1
    Member
    Real Name
    Mike Warner
    Join Date
    Feb 2009
    Posts
    11

    Default Append .jpg to data of an entire column

    I've imported an excel file. There is no image field but fortunately the images have the same name as item number. I've copied the column but can't figure out how to append '.jpg' to all the item numbers in the duplicated column. I'd do it by hand but it's 11,000 entries.

  2. #2
    Guest
    Real Name
    Mark Pearson
    Join Date
    May 2009
    Location
    Townsville, Queensland, Australia
    Posts
    223

    Default Re: Append .jpg to data of an entire column

    Open the table in default browse, select records, update records. then select the field and use an expression like fieldname + ".jpg" Select update and it will update the record field with the data

    fieldname = the field with the item number

  3. #3
    Member
    Real Name
    Mike Warner
    Join Date
    Feb 2009
    Posts
    11

    Default Re: Append .jpg to data of an entire column

    Quote Originally Posted by Mark Pearson View Post
    Open the table in default browse, select records, update records. then select the field and use an expression like fieldname + ".jpg" Select update and it will update the record field with the data

    fieldname = the field with the item number
    Must be doing something wrong.

    I am using Alpha 5 V 9
    Don't have "update records" I do have "update selected records"
    Update records pull up the drop down menu, select the column, the fieldname is the same name? fieldname + ".jpg"
    Select update and it SAYS it has updated but nothing changed.

  4. #4
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,310

    Default Re: Append .jpg to data of an entire column

    After making a couple of good backups, try designing and running a saved "Update" operation.

    Code:
    trim(fieldname) + ".jpg"

  5. #5
    Guest
    Real Name
    Mark Pearson
    Join Date
    May 2009
    Location
    Townsville, Queensland, Australia
    Posts
    223

    Default Re: Append .jpg to data of an entire column

    You could also check the field item number. If it is numeric or not large enough the update will not happen. The expression builder should validate that when you put in the formula.

    Field name may need to be str(fieldname) + ".jpg" to make it all characters
    Last edited by Mark Pearson; 10-29-2009 at 05:21 PM.

  6. #6
    Member
    Real Name
    Mike Warner
    Join Date
    Feb 2009
    Posts
    11

    Default Re: Append .jpg to data of an entire column

    Quote Originally Posted by Tom Cone Jr View Post
    After making a couple of good backups, try designing and running a saved "Update" operation.

    Code:
    trim(fieldname) + ".jpg"
    That did the trick! Thanks!

    Mike

Similar Threads

  1. Append Records with Related Data
    By Lare2 in forum Alpha Five Version 8
    Replies: 5
    Last Post: 04-04-2008, 11:48 AM
  2. Restrict Data Entry entire database
    By MikeC in forum Alpha Five Version 5
    Replies: 3
    Last Post: 09-24-2007, 05:29 PM
  3. Append Data from Another Alpha Database
    By forskare in forum Alpha Five Version 7
    Replies: 4
    Last Post: 09-06-2006, 12:44 AM
  4. Append data
    By Schulzie in forum Alpha Five Version 4
    Replies: 6
    Last Post: 08-25-2003, 08:09 AM
  5. Can't append copy of data
    By Ted Giles in forum Alpha Five Version 4
    Replies: 11
    Last Post: 08-30-2000, 11:23 AM

Bookmarks

Posting Permissions

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