Data Cleanup 1

[Albert3162]

Hi there,

I have data in Column "NAME" like:Timor D. Horbon.
How can I upload this in three dif column(FirstName, LastName, Mid)

thanks.

 

[webmigit]

Try...

<cfloop list="#valuelist(QUERY.COLUMN)#" index="vlq">
  <cfif listlen(vlq," ") eq 3>
    <cfset vlfn=listfirst(vlq," ")>
    <cfset vlmn=listgetat(vlq,2," ")>
    <cfif right(vlmn,1) is ".">
      <cfset vlmn=left(vlmn,len(vlmn)-1)>
    </cfif>
    <cfset vlln=listlast(vlq," ")>
  <cfelse>
    <cfset vlfn=listfirst(vlq," ")>
    <cfset vlmn="">
    <cfset vlln=listlast(vlq," ")>
  </cfif>
  ...run your db insert here... vlfn = first, vlmn = middle, vlln = last... It also checks to make sure that there is a middle name... if there's no middle name, then the middle is set to ""...
</cfloop>

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.