Getting rid of ".jpg" in a field

[drschilling]

Hi,

I've got a bunch of ISBN 13 values in a field like the following:

9780000013712.jpg

I want to remove the ".jpg" so I have just the ISBN 13 value.

Don't know how to do this.

Thanks!

David

[jbante]

Here's one possibility:

Filter ( isbn ; "0123456789" )

If you need to do this as a one-time thing on a local set of data, you can fix your ISBN values with the "Replace Field Contents" command under the "Records" menu. (I'm assuming that your ISBN values are stored in a field in a table.) If you need a more permanent solution going forward, you can set an auto-enter option for your ISBN field with the "Do not replace existing value of field" option unchecked; you may need to do a Replace Field Contents operation after you do this anyway to trigger the calculation for your existing records. Alternately, if it makes sense to keep a record of the original field name, you could make a separate calculation field based on your source ISBN file name field.

[comment]

I want to remove the ".jpg" so I have just the ISBN 13 value.

If there are always exactly 13 characters before the extension, you can use =

Left ( YourField ; 13 )

to retrieve them.

[drschilling]

Thanks very much. I really appreciate it!