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.---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing listUp 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,MDS2016-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,.To unsubscribe, E-mail to: =div>archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us
|
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.---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing listUp 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,MDS2016-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,.To unsubscribe, E-mail to: =div>archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us
DOWNLOAD WEBDNA NOW!
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...