Inserting a variable to a text string

Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.

  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. Similar Questions and Discussions

    1. inserting # in a string
      I'm trying to insert a string that contains a # into an access database. But I get an error: Your expression might be missing an ending "#" (it...
    2. String to Variable
      Need some help with the following: I want to use global Variable in a if statement . The name of the variable is 'made' from some text and the...
    3. Inserting Text
      Does anyone know if it is possible to insert text in Adobe Acrobat Professional 6.0. I've just purchased this product and thought this was something...
    4. How to replace a variable string within /* variable_string */ with x for each character in string?
      How to replace a variable string within /* variable_string */ with x for each character in string? The string may span on multiple lines. for...
    5. Parsing string and inserting characters into it.
      b = "08305212" b = left(b, 4) & "." & right(b, len(b)-4) "Bill" <billzimmerman@gospellight.com> wrote in message...
  3. #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

  4. #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

  5. #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

  6. #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

Posting Permissions

  • You may not post new threads
  • You may 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