-
Notifications
You must be signed in to change notification settings - Fork 0
/
FileUtil.cfc
53 lines (47 loc) · 1.37 KB
/
FileUtil.cfc
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
/*
Filename: FileUtil.cfc
Purpose: To Support Flat File specific functions
Author: Joe Lechuga joe.lechuga@gmail.com
Usage:
fileUtilObj = CreateObject("component","FileUtil");
convertedQuery = fileUtilObj.convertToQuery(<Body of File>,<Delimiter>);
*/
component {
/*
Converts a Flatfile to a query
*/
public query function convertToQuery(required String Text, required Delimiter text ) {
var ct = 1;
columnArray = listToArray (Text,Delimiter);
for( fieldName in columnArray ){
form[fieldName] = qry[fieldName][1];
if ct eq 1
{
// ensure that the Delimiter is a comma
columns = replace(i,Delimiter,',','all');
ConvertedQuery = QueryNew("#columns#");
colArray = arrayNew(1);
colArray = listToArray(columns);
}
else if ct gt 1
{
// ensure that the Delimiter is a comma
dataCol = replace(i,'#chr(34)#','','all');
dataArray = arrayNew(1);
dataArray = listToArray(dataCol,Delimiter);
queryAddRow(ConvertedQuery, 1);
}
for (j=1;j lte arrayLen(colArray);j++;)
{
if(ArrayIsDefined(dataArray,j))
{
QuerySetCell(ConvertedQuery, "#colArray[j]#", "#dataArray[j]#" , (ct-1));
} else {
QuerySetCell(ConvertedQuery, "#colArray[j]#", " " , (ct-1));
}
}
ct = ct + 1;
}
return ConvertedQuery;
}
}