Re: [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 = 113221
interpreted = N
texte = 809 --Apple-Mail=_EC785DDA-2A9C-4CD9-8F70-A0BD41D6AE78 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Looks like you need to do a bit of extra processing. User grep to find :, and replace it with :00, (it looks like a time that = is truncated) then use grep to change all the , with tabs. Save the file = and then you are ready to go. Kind regards Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@idfk.com.au > On 24 Nov. 2016, at 08:19, dale wrote: >=20 > 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.=20 >=20 > 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.=20 >=20 > I have been working on trying to eliminate the manual steps and doing = it all in WebDNA.=20 >=20 > 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? >=20 > Thanks for any help on getting WebDNA to convert this csv file to tab = delimited for me.=20 >=20 > Here are a few example lines: >=20 > 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, > --------------------------------------------------------- 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 --Apple-Mail=_EC785DDA-2A9C-4CD9-8F70-A0BD41D6AE78 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Looks like you need to do a bit of extra processing.

User grep to find :, and = replace it with :00, (it looks like a time that is truncated) then use = grep to change all the , with tabs. Save the file and then you are ready = to go.


Kind regards

Stuart Tremain
Pharoah Lane Software
AUSTRALIA






On 24 Nov. 2016, at 08:19, dale <dtherio@gmail.com> = wrote:

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,
--------------------------------------------------------- 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

= --------------------------------------------------------- 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 --Apple-Mail=_EC785DDA-2A9C-4CD9-8F70-A0BD41D6AE78-- . 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)
809 --Apple-Mail=_EC785DDA-2A9C-4CD9-8F70-A0BD41D6AE78 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Looks like you need to do a bit of extra processing. User grep to find :, and replace it with :00, (it looks like a time that = is truncated) then use grep to change all the , with tabs. Save the file = and then you are ready to go. Kind regards Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@idfk.com.au > On 24 Nov. 2016, at 08:19, dale wrote: >=20 > 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.=20 >=20 > 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.=20 >=20 > I have been working on trying to eliminate the manual steps and doing = it all in WebDNA.=20 >=20 > 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? >=20 > Thanks for any help on getting WebDNA to convert this csv file to tab = delimited for me.=20 >=20 > Here are a few example lines: >=20 > 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, > --------------------------------------------------------- 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 --Apple-Mail=_EC785DDA-2A9C-4CD9-8F70-A0BD41D6AE78 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Looks like you need to do a bit of extra processing.

User grep to find :, and = replace it with :00, (it looks like a time that is truncated) then use = grep to change all the , with tabs. Save the file and then you are ready = to go.


Kind regards

Stuart Tremain
Pharoah Lane Software
AUSTRALIA






On 24 Nov. 2016, at 08:19, dale <dtherio@gmail.com> = wrote:

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,
--------------------------------------------------------- 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

= --------------------------------------------------------- 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 --Apple-Mail=_EC785DDA-2A9C-4CD9-8F70-A0BD41D6AE78-- . Stuart Tremain

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:

Fax Broadcast (1998) RE: [shownext] support - MacOS (1997) Search returns all, not 20 (1997) Order Date (2003) Country & Ship-to address & other fields ? (1997) WebMerchant 1.6 and SHTML (1997) Can I invoke an ssi plugin from within a webcat page (1997) Date and Comparisons (2002) Webstar / WebCat - Persistent Setting (2003) [ModDate] & [ModTime] ? (1997) Draft Manual, Tutorial, and more (1997) How to implement 'email to a friend' feature? (2002) carriage returns in data (1997) [WebDNA] [OT] Phone solution for multiple companies at same location (2010) is [shell] working? (1999) [OT] Server check please (2006) Auto SKU's (2000) Has anyone built this already? (2003) Cookies? (1997) [Announce] WebCatalog 3.0 Beta Program (1998)