Extract from String

Forum|Forum|18 years ago
July 31, 2007
4 replies
737 views

I have strings that are file names...like index.cfm......test.pdf....messagepost.cfm

I need to extract only what is to the left of the dot.

Like for index.cfm...I need to extract index

for test.pdf..I need to extract test

for messagepost.cfm .. I need to extract messagepost

I've tried variations of right ,left, mid..to no avail..

Any help.

This topic has been closed for replies.

Correct answer cf_dev2

<cfset yourString = "mesagepost.cfm">
<cfset index = find(".", reverse(yourString))>
<cfset fileName = left(yourString, len(yourString)-index)>
<cfoutput>fileName=#fileName#</cfoutput>

C

cf_dev2

Inspiring

I tend to use the reverse()/find() approach for file names because it handles odd cases like multiple file extensions: myFile .xls.txt. But if you don't have to handle special cases, then use list functions with a "." as the delimiter.

C

cf_dev2Correct answer

Inspiring

<cfset yourString = "mesagepost.cfm">
<cfset index = find(".", reverse(yourString))>
<cfset fileName = left(yourString, len(yourString)-index)>
<cfoutput>fileName=#fileName#</cfoutput>

Fernis

Inspiring

I find this the most logical way for me. It handles multiple file extensions as well, removing only the last one.

<cfset yourString = "messagepost.cfm">
<cfset fileName = listDeleteAt(yourString,listLen(yourString,"."),".")>
<cfoutput>#fileName#</cfoutput>

-Fernis