[WebDNA] Processing a CSV file for use as a db file

This WebDNA talk-list message is from

2016


It keeps the original formatting.
numero = 113206
interpreted = N
texte = 794 --001a1137a178319dd70541fe731e Content-Type: text/plain; charset=UTF-8 I get a download from Jaspersoft reports in a somewhat csv file format. I say somewhat as two of the fields end with a colon before the comma. Up until now I have been doing a search and replace with a text editor to replace the :, with a tab then replacing the remaining commas with a tab. Once that is done I upload the file and do the rest of the manipulation with WebDNA. I have been working on trying to eliminate the manual steps and doing it all in WebDNA. So far if I upload the file (I have a .hdr file already on the server), then in a template I simply do a search in the file to open it. WebDNA will adds tabs for the fields in the header file, but only at the end. It does not replace the commas. Is there a certain way thet the file should be opened in order for WebDNA to replace the commas with tabs? Thanks for any help on getting WebDNA to convert this csv file to tab delimited for me. Here are a few example lines: 2016-11-23 14:01:,D1404,00012E4BE094,172.20.242.252,Raney SC,2016-11-23 14:01:,4.0.1.4,MDS 2016-11-23 14:01:,D1196,00012E4BE526,10.140.25.231,N Dallas SC,2016-11-23 14:01:,4.0.1.4, 2016-11-23 14:01:,NE419,0082005345,10.140.23.177,NorthEast ISD,2016-11-23 14:01:,V2.1.04, --001a1137a178319dd70541fe731e Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I get a download from Jaspersoft reports in a somewhat csv= file format. I say somewhat as two of the fields end with a colon before t= he comma.=C2=A0

Up until now I have been doing a search = and replace with a text editor to replace the :, with a tab then replacing = the remaining commas with a tab. Once that is done I upload the file and do= the rest of the manipulation with WebDNA.=C2=A0

I= have been working on trying to eliminate the manual steps and doing it all= in WebDNA.=C2=A0

So far if I upload the file (I h= ave a .hdr file already on the server), then in a template I simply do a se= arch in the file to open it. WebDNA will adds tabs for the fields in the he= ader file, but only at the end. It does not replace the commas. Is there a = certain way thet the file should be opened in order for WebDNA to replace t= he commas with tabs?

Thanks for any help on gettin= g WebDNA to convert this csv file to tab delimited for me.=C2=A0
=
Here are a few example lines:

= 2016-11-23 14:01:,D1404,00012E4BE094,172.20.242.252,Raney SC,2016-11-23 14:= 01:,4.0.1.4,MDS
2016-11-23 14:01:,D1196,00012E4BE526,10.140.25.23= 1,N Dallas SC,2016-11-23 14:01:,4.0.1.4,
2016-11-23 14:01:,NE419,= 0082005345,10.140.23.177,NorthEast ISD,2016-11-23 14:01:,V2.1.04,
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us --001a1137a178319dd70541fe731e-- . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Processing a CSV file for use as a db file (Stuart Tremain 2016)
  2. [WebDNA] Processing a CSV file for use as a db file (dale 2016)
794 --001a1137a178319dd70541fe731e Content-Type: text/plain; charset=UTF-8 I get a download from Jaspersoft reports in a somewhat csv file format. I say somewhat as two of the fields end with a colon before the comma. Up until now I have been doing a search and replace with a text editor to replace the :, with a tab then replacing the remaining commas with a tab. Once that is done I upload the file and do the rest of the manipulation with WebDNA. I have been working on trying to eliminate the manual steps and doing it all in WebDNA. So far if I upload the file (I have a .hdr file already on the server), then in a template I simply do a search in the file to open it. WebDNA will adds tabs for the fields in the header file, but only at the end. It does not replace the commas. Is there a certain way thet the file should be opened in order for WebDNA to replace the commas with tabs? Thanks for any help on getting WebDNA to convert this csv file to tab delimited for me. Here are a few example lines: 2016-11-23 14:01:,D1404,00012E4BE094,172.20.242.252,Raney SC,2016-11-23 14:01:,4.0.1.4,MDS 2016-11-23 14:01:,D1196,00012E4BE526,10.140.25.231,N Dallas SC,2016-11-23 14:01:,4.0.1.4, 2016-11-23 14:01:,NE419,0082005345,10.140.23.177,NorthEast ISD,2016-11-23 14:01:,V2.1.04, --001a1137a178319dd70541fe731e Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I get a download from Jaspersoft reports in a somewhat csv= file format. I say somewhat as two of the fields end with a colon before t= he comma.=C2=A0

Up until now I have been doing a search = and replace with a text editor to replace the :, with a tab then replacing = the remaining commas with a tab. Once that is done I upload the file and do= the rest of the manipulation with WebDNA.=C2=A0

I= have been working on trying to eliminate the manual steps and doing it all= in WebDNA.=C2=A0

So far if I upload the file (I h= ave a .hdr file already on the server), then in a template I simply do a se= arch in the file to open it. WebDNA will adds tabs for the fields in the he= ader file, but only at the end. It does not replace the commas. Is there a = certain way thet the file should be opened in order for WebDNA to replace t= he commas with tabs?

Thanks for any help on gettin= g WebDNA to convert this csv file to tab delimited for me.=C2=A0
=
Here are a few example lines:

= 2016-11-23 14:01:,D1404,00012E4BE094,172.20.242.252,Raney SC,2016-11-23 14:= 01:,4.0.1.4,MDS
2016-11-23 14:01:,D1196,00012E4BE526,10.140.25.23= 1,N Dallas SC,2016-11-23 14:01:,4.0.1.4,
2016-11-23 14:01:,NE419,= 0082005345,10.140.23.177,NorthEast ISD,2016-11-23 14:01:,V2.1.04,
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us --001a1137a178319dd70541fe731e-- . dale

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

shoppingcart reload qty (1997) Serious bug writing to a database ... (2002) Redirect in 4.0 (2000) New Cart No. on same page (2003) Problems with dbcatalog.exe (1997) [WebDNA] TCPConnect w/ user:pass (2009) Nesting format tags (1997) For Grant: Webcatalog 4.0 - When will we be able to beta testit? (2000) Search design (1997) FYI: virus alert (1996) Explorer 3.0/ Access Denied! (1997) More on the email templates (1997) Format all of a sudden doesn't work (1997) My web page only... (2003) UPS went bye bye (2006) Pricelist (1999) One cent added (1998) [WebDNA] V8.6 FCGI (2018) [sendmail] and [formvariables] (1997) Feature req. (2002)