Professional Web Applications Themes

Inserting a variable to a text string - Coldfusion - Advanced Techniques

Hello, I am working on a product catalog for our companies website and have run into a hiccup. I need a way to insert a text variable into the middle of a retrieved text string. Example: Part Number retrieved: 225x226FGV I need a finish code retrieved from the same database to be inserted into the viewed part number thus: 226x226AFGV I hope this is enough information to help.. Thanks, Scott...

  1. #1

    Default Inserting a variable to a text string

    Hello, I am working on a product catalog for our companies website and have
    run into a hiccup. I need a way to insert a text variable into the middle of a
    retrieved text string. Example: Part Number retrieved: 225x226FGV I need a
    finish code retrieved from the same database to be inserted into the viewed
    part number thus: 226x226AFGV I hope this is enough information to help..
    Thanks, Scott

    ScottP Guest

  2. #2

    Default Re: Inserting a variable to a text string

    Depends on the part number construction. I take it you have shorter and longer
    part numbers. Is the alpha code on the end always three characters long? If
    so, then <cfset dsppartnum =
    mid(partnum,1,len(partnum)-3)&amp;finishcode&amp;mid(partnum,len(partnum)-2,3)>
    HTH,

    philh Guest

  3. #3

    Default Re: Inserting a variable to a text string

    Thanks for getting back to me so quickly. The alpha at the end is sometimes 0, 2, or 3 characters depending on the part number.
    ScottP Guest

  4. #4

    Default Re: Inserting a variable to a text string

    Is it always a divide between the numeric and alpha portions? You could probably write a regular expression or an evaluation loop to find the break, or, in the case of 0 chars, the end of the string.
    philh Guest

  5. #5

    Default Re: Inserting a variable to a text string

    Great. Thanks for the quick help. I will try this and let you know..
    ScottP Guest

Similar Threads

  1. inserting # in a string
    By qs01 in forum Coldfusion - Getting Started
    Replies: 3
    Last Post: June 16th, 02:28 AM
  2. String to Variable
    By Mischa Kalle in forum Coldfusion Database Access
    Replies: 4
    Last Post: February 18th, 04:21 PM
  3. Inserting Text
    By penny_hall@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 3
    Last Post: May 13th, 06:22 PM
  4. Replies: 4
    Last Post: September 12th, 04:19 PM
  5. Parsing string and inserting characters into it.
    By Aaron Bertrand - MVP in forum ASP
    Replies: 2
    Last Post: July 10th, 10:28 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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139