Alpha DevCon 2018
Results 1 to 3 of 3

Thread: string manipulation

  1. #1
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    Location
    In the Wolds, Louth, Lincolnshire, UK
    Posts
    4,065

    Default string manipulation

    This is the returned string when using Field Rules.
    The field is a calculated field and returns the following based on the jpg image in the table. The field with the image is an Image Reference Field (10 bytes)

    =filename_decode("\My Folder\my images\myjpg name.jpg"

    If I want to save just the relevant text, say \My Folder\my images\myjpg name.jpg, how should I chop it up efficiently?
    Ted Giles
    Example Consulting - UK
    .

    https://exampleltd.example-software.com/
    See our site for Alpha Support, Conversion and Upgrade.

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: string manipulation

    Code:
    pth = <<%txt%
    #=filename_decode("\My Folder\my images\myjpg name.jpg"
    #%txt%
    ? pth
    = =filename_decode("\My Folder\my images\myjpg name.jpg"
    
    
    ? extract_string(pth,chr(34),chr(34))
    = "\My Folder\my images\myjpg name.jpg"
    There can be only one.

  3. #3
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    Location
    In the Wolds, Louth, Lincolnshire, UK
    Posts
    4,065

    Default Re: string manipulation

    Thank you |Stan, that worked beautifully.
    Ted Giles
    Example Consulting - UK
    .

    https://exampleltd.example-software.com/
    See our site for Alpha Support, Conversion and Upgrade.

Similar Threads

  1. HTTP Manipulation.
    By sezeala in forum Mobile & Browser Applications
    Replies: 5
    Last Post: 02-05-2016, 03:37 AM
  2. string manipulation
    By pulsoft in forum Alpha Five Version 11 - Desktop Applications
    Replies: 15
    Last Post: 01-27-2013, 06:47 AM
  3. PDF Manipulation
    By JohnMcc in forum Application Server Version 8
    Replies: 7
    Last Post: 05-15-2008, 12:00 PM
  4. Field manipulation
    By alev in forum Alpha Five Version 5
    Replies: 6
    Last Post: 03-06-2006, 01:09 PM
  5. Object Manipulation example
    By Melvin Davidson in forum Code Archive
    Replies: 4
    Last Post: 01-14-2004, 05:10 PM

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
  •