Need Help finding a char from a flat file

Forum|Forum|17 years ago
August 13, 2008
3 replies
738 views

My CFSCRIPT need to find a character from a flat file.
The flat file look something like this:
20;193236;1;KUMAR;RETESTDEFECT215;;STRETE;;;SPRINGFIED;MA;01111;;;Contract_20080715-2_10093_88
20;193236;1;DIANE;SMITH;;STRETE;;;SPRINGFIED;MA;01111;;;Contract_20080715-2_10093_88
20;193236;1;ROBERT;REYES15;;STRETE;;;SPRINGFIED;MA;01111;;;Contract_20080715-2_10093_88
etc...

I need to determine whether number "20" in the file exist. How can I do this? can anyone help?

<cfscript>
IsRecordExist=Search("fileContent", 20) ?????
</cfscript>

<cfoutput>
#IsRecordexist#
</cfoutput>

Getting started

This topic has been closed for replies.

A

A***

Inspiring

The substring is the first parameter in the find() syntax. I have used sstrg as a general search item below:

<cfsavecontent variable="fileContents">
20;193236;1;KUMAR;RETESTDEFECT215;;STRETE;;;SPRINGFIED;MA;01111;;;Contract_20080715-2_10093_8820;193236;1;DIANE;SMITH;;STRETE;;;SPRINGFIED;MA;01111;;;Contract_20080715-2_10093_8820;193236;1;ROBERT;REYES15;;STRETE;;;SPRINGFIED;MA;01111;;;Contract_20080715-2_10093_88
</cfsavecontent>


<cfset sstrg = 20 />


<cfscript>
IsRecordExist= Find(sstrg, LTrim(fileContents));
</cfscript>


<cfoutput>
<cfif IsRecordExist EQ 0>
<strong>#sstrg#</strong> does not exist in the file.
<cfelse>
The first occurrence of <strong>#sstrg#</strong> is at position #IsRecordExist# in the file.
</cfif>
</cfoutput>

A

aleckenAuthor

Known Participant

First I like to say thank you for the responses. I tried the suggestion and it is working but not as expected especially on case where the content also have char 20 somewhere lese for example in case like this:
<cfsavecontent variable="filecontents">
20;193236;1;KUMAR;REYES;;STR;;;SPRINGFIED;MA;01111;;;Contract_20080715-2_10093_2-88.pdf
</cfsavecontent

The char 20 is not only found in the begining of the string but may also exist in the middle of the string:Contract_ 20080715-2_10093_2-88.pdf and may be somewhere else.
I only need to detect the first char from my feed to make sure if this record exist.

D

Daverms

Inspiring

Also, if would you like to have the number of occurences of the string "20" in your file, you may try this UDF,

http://cflib.org/udf/FindOccurrences

N

Newsgroup_User

Inspiring

Won't any of the string functions find(), reFind(), listFind() or
listContains() do what you want done?

A

aleckenAuthor

Known Participant

I tried this but I got 0 result:

<cfsavecontent variable="fileContents">
20;193236;1;KUMAR;RETESTDEFECT215;;STRETE;;;SPRINGFIED;MA;01111;;;Contract_20080715-2_10093_88
20;193236;1;DIANE;SMITH;;STRETE;;;SPRINGFIED;MA;01111;;;Contract_20080715-2_10093_88
20;193236;1;ROBERT;REYES15;;STRETE;;;SPRINGFIED;MA;01111;;;Contract_20080715-2_10093_88
</cfsavecontent>

<cfscript>
IsRecordExist= Find("fileContents", 20);
</cfscript>

<cfoutput>
#IsRecordExist#
</cfoutput>

RESULT: 0

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded