Skip to main content
AlexCraig
AlexCraig
Inspiring
February 13, 2024
Answered

Need Help with Replace Boolean Syntax

  • February 13, 2024
  • 2 replies
  • 749 views

OK.  One last item to cure with respect to applicant searches.

In CF 4.51 the collection for applicants was based on a huge folder containing .txt files.

In CF 2023 the colleciton is based on a huge folder containg: .doc, .docx, .pdf & .txt files.

 

The code that worked against the .txt file collection was.

****************************

values (#getCurrentSearchID.theSearchID#, #Replace( replace( URL, "/", "" ), ".txt", "" )#)

****************************

Basically, it stripped off the .txt part of the file name & the "/" that solr inserts into the value of URL> so that we are left with the file # to use in further processing.

I have tried the following against the folder with the 4 extensions mentioned above.

***************************

values (#getCurrentSearchID.theSearchID#, #Replace( replace( URL, "/", "" ), (".doc" or ".docx" or ".txt") ", "" )#)

***************************

CF is not happy with my (".doc" or ".docx" or ".txt") construct.  Would very much appreciate any suggestions.   Would like to avoid CFIF/CFELSE searching each URL returned to see which extension is involved before continuing to process the data, if that is even possible.

 

    This topic has been closed for replies.
    Correct answer sdsinc_pmascari

    Simple as pie:

    ReplaceNoCase(ReplaceNoCase(ReplaceNoCase(ReplaceNoCase( replace( URL, "/", "" ), ".doc", "" ), ".docx", "" ), ".txt", "" ), ".pdf", "" )

    2 replies

    BKBK
    Community Expert
    BKBKCommunity Expert
    Community Expert
    April 3, 2024

    A suggestion:

    <!--- Use \ to escape ".". The regular-expression match is from left to right, so place docx before doc --->
<cfset resultingString = REReplaceNoCase(theURL, "/|\.docx|\.doc|\.txt|\.pdf", "","all")>
    S
    sdsinc_pmascari
    Legend
    February 13, 2024

    Is this what you're looking for?  Replacing all those extensions in one line?

    Replace(Replace(Replace( replace( URL, "/", "" ), ".doc", "" ), ".docx", "" ), ".txt", "" )
    AlexCraig
    AlexCraigAuthor
    Inspiring
    February 13, 2024

    Hmm ...

    So what this will do is search for all of them and only delete the one that actually exists AND NOT produce an error for those extensions that are not in the URL.  I"ll need to add one more for the .pdf files as well.  Does this look right to you?

    Replace(Replace(Replace(Replace( replace( URL, "/", "" ), ".doc", "" ), ".docx", "" ), ".txt", "" ), ".pdf", "" )

    Alex Craig, General Manager&quot;Avid Saltwater Fly Fisherman&quot;
    S
    sdsinc_pmascari
    Legend
    February 13, 2024

    That's correct.  If there is no 'docx' to replace, it just moves on to .txt, then .pdf.  No errors.

     

    Might not be the most elegant line of code ever, but gets the job done.

     

    Alternatively, I guess you could use listEach():

    <cfset theString = replace( URL, "/", "" )>

<cfset alist = ".doc,.docx,.txt,.pdf">

<cfset listEach(alist,function(idx){
    theString = replace(theString,idx,'');
})>
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices