I am sorry, but I haven't got more time for you now. It's already evening here and I have to go to band prctice. If I can find the time this weekend I will write some code for you. It's easter holidays here and we are leaving on vacation, so I don't know if I will be able to do it. I will be back on the list in a week.
Pascal Peters
Certified ColdFusion MX Advanced Developer
Macromedia Certified Instructor
LR Technologies
Av. E. De Mot, 19
1000 BRUSSELS, BELGIUM
Tel: +32 2 639 68 70
Fax: +32 2 639 68 99
Email: [EMAIL PROTECTED]
Web: www.lrt.be
> -----Original Message-----
> From: cf coder [mailto:[EMAIL PROTECTED]
> Sent: vrijdag 2 april 2004 17:03
> To: CF-Talk
> Subject: Re: how to get rid of the new line character
>
> Pascal, just when I was beginning to think why you've not
> replied, you post a reply. Thanks man.
>
> But this is not quite what I'm after.
>
> I'll tell you what I've done. I exported data from a mdb file
> to a txt file. All data in the mdb file is in one column and
> looks like this
> Column1
> -------
> 1000,
> sgfsdf,
> sfsdf,
> sfdsf,
> [EMAIL PROTECTED]
>
> 1001,
> test,
> new,
> blah
> [EMAIL PROTECTED]
>
> etc etc.
>
> Now, I want the data in the table to be arranged like this:
> Column1 Column2 Column3 Column4
>
> 1000 sgfsdf sfsdf sfdsf
> 1001 test new blah
>
> I thought if I export it to a text file and apply some logic
> and rearrange the data as shown above then when I import it
> back to a new table, it will be stored in this fashion.
>
> Its not impossible to do is it?! Can you please show me how
> to do this. I am going mad.
>
>
>
>
>
> > <cfscript>
>
> > text = "";
> > crlf = chr(13) & chr(10);
> > delim = "[EMAIL PROTECTED]";
> > start = 1;
> > cont = true;
> > fOutput = Replace(fOutput,crlf,chr(10),"ALL");
> > while(cont){
> > end = Find(delim,fOutput,start);
> > if(NOT end){
> > end = Len(fOutput);
> > cont = false;
> > }
> > line = Mid(fOutput,start,end-start);
> > start = end + Len(delim);
> > if(Len(Trim(line))){
> > text = text & REReplace(line,"[#chr(9)#
> ]*#chr(10)#",",","ALL") &
> > crlf;
> > }
> > }
> > </cfscript>
> > <cffile action=""
>
> > file="employerNew.txt"
>
> > output="#text#"
>
> > addnewline="No">
> >
> > Depending on what you want to do, you may need to get rid of some
> > leading and/or trailing commas in the lines.
> >
> > Btw, in cf a list delimiter is only one character. So if you set
> > delimiters="[EMAIL PROTECTED]", you will have a new element when ~ , @ OR � is
> > found.
> >
> > Pascal
> >
> > > -----Original Message-----
> > > From: cf coder [mailto:[EMAIL PROTECTED]
> > > Sent: vrijdag 2 april 2004 16:35
> > > To: CF-Talk
> > > Subject: how to get rid of the new line character
> > >
> > > hi guys I'm hoping someone can help me. I'm reading a text file
> > > <cffile
> > > action=""> > > > file="employer.txt"
> > > variable="fOutput">
> > >
> > > Looping through the text file, I've set the list delimter to be
> > > "[EMAIL PROTECTED]".
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
