Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# coldfusion read plain text file

Posted on 2013-05-28
Medium Priority
546 Views
Last Modified: 2013-05-28
Here is my situation. Windows 2008, Coldfusion 10. Trying to create some type of basic document management system.

My Xerox 7500 series multi-function machine can scan docs to a network share. The scanned pdf as well as a .XST job log file is saved. The XST file is plain text and contains some info about the job I would like to read. Can coldfusion read this text file??

There is a line MetaDataValue = "123456"

Any ideas? I've read about cffile and maybe using cfloop, just not sure if these are good to use, or what is easiest or best. Thanks for nay help!
0
Question by:cb_it
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• Learn & ask questions
• 5
• 4
9 Comments

LVL 52

Expert Comment

ID: 39202415
Sure you can read it if it's a text file.  What's the typical file size? As long as it's not a huge file, looping through it is fine. You just need the right delimiter and pattern.

> There is a line MetaDataValue = "123456"

Is it always in that format ie MetaDataValue = "(something different here)"  ?  Do any other lines start with "MetaDataValue  = "? If it's just the one, you could do:

<cfset fileContent = FileRead("c:\path\to\yourFile.xst")>

<cfset lineToFind = "">
<cfloop list="#fileContent#" index="line" delimiters="#chr(10)##chr(13)#">
<cfset firstCol = getToken(trim(line), 1, "=")>
<cfif trim(firstCol) eq "MetaDataValue">
<cfset lineToFind = line>
</cfif>
</cfloop>

<cfoutput>
lineToFind = #lineToFind#
</cfoutput>
0

Author Comment

ID: 39202439
Just that 1 line is called MetaDataValue. The number it contains is a number the user is forced to type in before they can scan. For example they would have to input 987654 into the machine for the loan number they are about to scan. Hope that makes sense.

The xst file is small maybe 3-4KB. Here is part of it. There will be many xst files, can CF loop through ALL of these files, and then read the MetaDataValue??

[description xrx_dscrpt_metadata]
1{
* string MetaDataPrompt = "LOAN_NUMBER";
* string MetaDataFieldName = "LOAN_NUMBER";
* boolean MetaDataRequiredEntry = TRUE;
* string MetaDataType = "string";
string MetaDataValue = "123456";
boolean MetaDataValidationRequired = FALSE;
enum_metadatamaskingrequired MetaDataMaskingRequired = NONE;
}
end

I will try your code and report back. Thanks.
0

Author Comment

ID: 39202462
The file is NOT a csv file, I think, so not sure if you are trying to break apart or trim some columns with your code??

I ran your code and just got lineToFind =

Nothing else.
0

LVL 52

Expert Comment

ID: 39202557
It doesn't have to be CSV. You can use cfloop with any delimiter, like a new line in my example. But it won't work anyway, because the line doesn't start with "MetaDataValue" it starts with "string MetaDataValue".

If all the files are that small, I'd recommend a regex instead.  I'm not very good at those. This works with the example above, but I'd suggest getting an opinion from a real regex guru instead :)

<cfset theValue  = "">
<cfset match = reMatchNoCase('MetaDataValue\s+=\s+"([^"]+)"', fileContent)>
<cfif arrayLen(match)>
<cfset theValue = getToken(match[1], 2, '"')>
</cfif>
<cfoutput>#theValue#</cfoutput>

0

LVL 52

Expert Comment

ID: 39202585
> can CF loop through ALL of these files, and then read the MetaDataValue??

You'd need something like DirectoryList to get the files you want to process. Then loop through the query and run the code above for each file.

<cfset fileArray = DirectoryList("c:\yourDirectory", false, "path", "*.xst ")>
<cfloop array="#fileArray#" index="filePath">
<cfset fileContent = FileRead(filePath)>
... code to parse content ....
</cfloop>

If possible this should be done each time you scan, rather than after the fact ie processing a whole directory of files. If that is not possible, try and do it in small batches, because anything that iterates thousands of times takes a while.
0

Author Comment

ID: 39202607
That works! Incredible, just a fe wlines of code. Here is my test code so far. I'm pulling 2 pieces of info out of the XST file and it's working. This is just reading the 1 xst file called cffile1.xst. How can this read all of the xst files in that one directory??

<cfset fileContent = FileRead("F:\SCANS\cffile1.xst")>

<cfset theValue1  = "">
<cfset match = reMatchNoCase('MetaDataValue\s+=\s+"([^"]+)"', fileContent)>
<cfif arrayLen(match)>
<cfset theValue1 = getToken(match[1], 2, '"')>
</cfif>

<cfset theValue2  = "">
<cfset match = reMatchNoCase('DocumentObjectName\s+=\s+"([^"]+)"', fileContent)>
<cfif arrayLen(match)>
<cfset theValue2 = getToken(match[1], 2, '"')>
</cfif>

<cfoutput>#theValue1# #theValue2#</cfoutput>
0

LVL 52

Accepted Solution

_agx_ earned 2000 total points
ID: 39202637
Just do a directory listing. It'll return an array of files. Then loop through the array, and put your code inside the loop.  Not sure if you saw this, but see here

<cfset fileArray = DirectoryList("F:\SCANS", false, "path", "*.xst ")>
<cfloop array="#fileArray#" index="filePath">
<cfset fileContent = FileRead(filePath)>

<cfset theValue1  = "">
<cfset match = reMatchNoCase('MetaDataValue\s+=\s+"([^"]+)"', fileContent)>
.... etc...

</cfloop>

Though I'm pretty sure one of the regex guys could come up with something way cooler than my lame expression ;-)
0

Author Comment

ID: 39202691
Woops, sorry, reading too fast and didnt see all of your post above. That array worked like a champ, thanks. Started using CF back in the 90's and have been out of the web game for quite some time.
0

LVL 52

Expert Comment

ID: 39202785
Welcome back. You'll pick it back up in no time.  It's amazing how much its grown. If you want a laugh, take a look at the function list for CF4.5 vs CF9 some time. Boy what a difference!
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article  is about submitting  form through  ColdFusion.Ajax.submitForm to the action page and send a response back in JSON format which later can be decoded using ColdFusion.JSON.decode. By this way you can avoid the usual page refresh for subm…
CFGRID Custom Functionality Series -  Part 1 Hi Guys, I was once asked how it is possible to to add a hyperlink in the cfgrid and open the window to show the data. Now this is quite simple, I have to use the EXT JS library for this and I achiev…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
###### Suggested Courses
Course of the Month5 days, 17 hours left to enroll

#### 688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.