<div>
oh, Thanks agx, <br />
<br />
how i forgot the GetToken <br />
<br />
i will try and get back asap
</div>


oh, Thanks agx,

how i forgot the GetToken

i will try and get back asap

<div>
but what if i need to remove those values starting from ü~ onwards
</div>


but what if i need to remove those values starting from ü~ onwards

<div>
Split it on the &quot;ü&quot; and grab the first part. &nbsp;But that's what the code above does. &nbsp;The results would be:<br />
<br />
theString = INCISE SPINE 3 COLUMN ADL SEG &nbsp; &nbsp;&lt;=== everything before the ü<br />
theStatus = certified<br />
theDate = 12/12/2012
</div>


Split it on the "ü" and grab the first part.  But that's what the code above does.  The results would be:

theString = INCISE SPINE 3 COLUMN ADL SEG    <=== everything before the ü
theStatus = certified
theDate = 12/12/2012

<div>
<div class="content wysiwyg-content">
I have a following string <br />
<br />
&nbsp;INCISE SPINE 3 COLUMN ADL SEGücertified~12/12/2012<br />
<br />
ücertified - This thing can be like ücertified, ünoncertified, üpending<br />
<br />
so i am trying to remove all characters from right starting from ü <br />
<br />
2. Another way i tried using listfirst, tried using a function inside the query like <br />
<br />
&lt;cfquery name=&quot;GetTitles&quot; DATASOURCE=&quot;#dsn#&quot;&gt;<br />
&nbsp; SELECT ArticleID,Title,{fn ListFirst(mystring,'ü')} as mystring <br />
&nbsp; FROM News<br />
&nbsp; ORDER BY DatePosted<br />
&lt;/cfquery&gt;<br />
<br />
<br />
also, what if i need to separate this string into 3 different variables, 1 - string , 2 - the status [certified,noncertified, date], 3- date
</div>
</div>


I have a following string 

 INCISE SPINE 3 COLUMN ADL SEGücertified~12/12/2012

ücertified - This thing can be like ücertified, ünoncertified, üpending

so i am trying to remove all characters from right starting from ü 

2. Another way i tried using listfirst, tried using a function inside the query like 

<cfquery name="GetTitles" DATASOURCE="#dsn#">
  SELECT ArticleID,Title,{fn ListFirst(mystring,'ü')} as mystring 
  FROM News
  ORDER BY DatePosted
</cfquery>


also, what if i need to separate this string into 3 different variables, 1 - string , 2 - the status [certified,noncertified, date], 3- date

string breakup options

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.