How to get list element number that contains 'csv'

[Keendev]

Hi Guys,

Need help on this.

I have a list. And inside my list is "one.doc,two,three,four.csv,five.csv "
ex : filelist = one.doc,two,three,four.csv,five.csv


How do I get element number that contains ".csv"?
For this example I should get element 4 and 5.
Is there a better CF function for this?

Basically I need to get the files that are .csv for validation.

What i did was i put it on a loop,but running loop may get problem specially if there are hundreds of files.

 <CFSET numLoop = #Listlen(aList)#>

<cfoutput>numLoop :#numLoop#</cfoutput> <br>

<cfoutput>
<cfloop  index="i" from="1" to="#numLoop#">

element:  #ListContains(filelist, ".csv")#
	
</cfloop>
</cfoutput>

Dont know if this is the correct approach, need some advice.

Thanks in advance.

 

[cfSearching]

How is the list generated and what are you ultimately doing with the results? I am just wondering if you really need the index numbers or just the values?

What version of CF are you using?



----------------------------------

http://cfsearching.blogspot.com/

 

[Keendev]

Hi,

im getting the files from a certain directory and putting it on a list

<cfdirectory directory="#path#" name="newFolderDir" sort="name ASC, size DESC">

 <cfloop query="newFolderDir" >
		 <CFSET File_list = ListAppend(File_list, #Name#)>
 </cfloop>

But I need also to get the files that is .csv files only.

 

[Keendev]

Hi again =)

Im using Cf 6.1 MX.
And need index numbers and the values?

thanks

 

[cfSearching]

Well, unless you really need the list you could just use a QoQ to find all records with a .csv extension. Just remember a QoQ LIKE is case sensitive

http://livedocs.adobe.com/coldfusion/6.1/htmldocs/using_26.htm

----------------------------------

http://cfsearching.blogspot.com/

 

[cfSearching]

i.e. Use a QoQ on your newFolderDir query. Not tested, but something along these lines

<cfquery name="findCSV" dbtype="query">
SELECT Name
FROM newFolderDir
WHERE LOWER(Name) LIKE '%.csv'
</cfquery>

Or if you only need the .csv files to begin with, use a filter with cfdirectory.

http://livedocs.adobe.com/coldfusion/6.1/htmldocs/tags-a20.htm

----------------------------------

http://cfsearching.blogspot.com/