LiveDocs Comments - coldfusion - 6.1 - htmldocs - variabl9.htm

coldfusion/6.1/htmldocs/variabl9.htm

extdw_doc — 2004-07-27T10:04:06

See http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/functi17.htm for a list of CFML string functions. It sounds like the mid function is what
you're looking for.

coldfusion/6.1/htmldocs/variabl9.htm

2004-07-27T07:11:21

Is there an easy way to extract a substring from a string?

coldfusion/6.1/htmldocs/variabl9.htm

jazzathena — 2004-05-25T22:47:47

I have suffered from the same list problem. Use this function to fix lists with null values:

function listFix(list) {
var delim = ",";
var null = "NULL";
var special_char_list = "\,+,*,?,.,[,],^,$,(,),{,},|,-";
var esc_special_char_list = "\\,\+,\*,\?,\.,\[,\],\^,\$,$,$,\{,\},\|,\-";
var i = "";

if(arrayLen(arguments) gt 1) delim = arguments[2];
if(arrayLen(arguments) gt 2) null = arguments[3];

if(findnocase(left(list, 1),delim)) list = null & list;
if(findnocase(right(list,1),delim)) list = list & null;

i = len(delim) - 1;
while(i GTE 1){
delim = mid(delim,1,i) & "_Separator_" & mid(delim,i+1,len(delim) - (i));
i = i - 1;
}

delim = ReplaceList(delim, special_char_list, esc_special_char_list);
delim = Replace(delim, "_Separator_", "|", "ALL");

list = rereplace(list, "(" & delim & ")(" & delim & ")", "\1" & null & "\2", "ALL");
list = rereplace(list, "(" & delim & ")(" & delim & ")", "\1" & null & "\2", "ALL");

return list;
}

coldfusion/6.1/htmldocs/variabl9.htm

jrunrandy — 2004-04-30T13:02:04

FWIW, this is how CF has always worked. I'm not sure why,
although I'm sure JJ had a reason.

For now, you can do a replace, and put a
space in each item. Something like this would work:

Then you can use the list functions as you need to.
With this example you will probably want to loop over the list and trim
each item at the end.

coldfusion/6.1/htmldocs/variabl9.htm

drew_falkman — 2004-04-30T11:33:48

Why does it remove empty list elements. I think this is a flaw. Think about importing delimited files, for example: 1,,,,2,3,4,,,,5

I would not want this represented as 1,2,3,4,5 as that would completely skew my import.

In fact, I have a hard time of thinking how translating lists in this way would be preferred. If these rows are to be ignored, then wouldn't it be best to let the developer approach that programmatically?