Re: [WebDNA] How to tidy up data extract ?
This WebDNA talk-list message is from 2013
It keeps the original formatting.
numero = 110419
interpreted = N
texte = This did it:) [TABLE name=3DNewData&fields=3DTHISROW] = +------------+--------------------------+----------------------+----------= ------------+ | StockNo | StockCode | QtyAvailable | = QtyOnHand | = +------------+--------------------------+----------------------+----------= ------------+ | 85 | GE.4619500 | 4.00 | 4.00 = | = +------------+--------------------------+----------------------+----------= ------------+ [/TABLE] [SEARCH table=3DNewData&neTHISROWdatarq=3D[BLANK]&rank=3Doff] [TABLE = name=3DFormattedData&fields=3DStockNo,StockCode,QtyAvailable,QtyOnHand] [FOUNDITEMS][SHOWIF [URL][THISROW][/URL]~[URL]|[/URL]][LISTWORDS = words=3D[THISROW]&delimiters=3D|][getchars = start=3D1&end=3D&trim=3Dboth][WORD][/getchars] [/LISTWORDS] [/SHOWIF][/FOUNDITEMS] [/TABLE] [/SEARCH] [SEARCH table=3DFormattedData&neSTOCKNOdatarq=3DStockNo] [FOUNDITEMS][StockNo] [StockCode] [QtyAvailable] = [QtyOnHand]
[/FOUNDITEMS] [/SEARCH] I have a whole heap of data coming in from MS SQL database that I need = to write to WebDNA db so I needed to wrangle the data so that I could = manage it into a db. Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 08/06/2013, at 3:31 PM, John Butler
= wrote: > If you mean what Dan suggests, then I assume the chars will line up as = intended if the font used for display is one of the mono-spaced type. = (however you say that). >=20 > And then why not just shove the string into the db field, as always, = and the line-feed char gets converted to what they always do (is it = vertical tab?, I forget), and on output you just translate that char = back into line-feed. >=20 > Maybe I am off.. but this might help, as a start. >=20 > -G >=20 >=20 > On 2013-06-08, at 1:14 AM, Dan Strong wrote: >=20 >> Do you mean literally as it is shown there: plus signs, dashes, pipes = and all? Also, what kind of database? WebDNA flat-file? >>=20 >> -Dan Strong >> New World Creative LLC >> http://www.NewWorldCreative.com >>=20 >> On 6/7/2013 6:38 PM, Stuart Tremain wrote: >>> Does anyone have any tips of tidying this up so I can put it into a = database ? >>>=20 >>> = +------------+--------------------------+----------------------+----------= ------------+ >>> | StockNo | StockCode | QtyAvailable | = QtyOnHand | >>> = +------------+--------------------------+----------------------+----------= ------------+ >>> | 85 | GE.4619500 | 4.00 | = 4.00 | >>> = +------------+--------------------------+----------------------+----------= ------------+ >>>=20 >>>=20 >>>=20 >>>=20 >>>=20 >>> Regards >>>=20 >>> Stuart Tremain >>> IDFK Web Developments >>> AUSTRALIA >>> webdna@idfk.com.au >>>=20 >>>=20 >>>=20 >>>=20 >>> --------------------------------------------------------- >>> 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 >>=20 >> --------------------------------------------------------- >> 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 >=20 > --------------------------------------------------------- > 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
Associated Messages, from the most recent to the oldest:
This did it:) [TABLE name=3DNewData&fields=3DTHISROW] = +------------+--------------------------+----------------------+----------= ------------+ | StockNo | StockCode | QtyAvailable | = QtyOnHand | = +------------+--------------------------+----------------------+----------= ------------+ | 85 | GE.4619500 | 4.00 | 4.00 = | = +------------+--------------------------+----------------------+----------= ------------+ [/TABLE] [SEARCH table=3DNewData&neTHISROWdatarq=3D[BLANK]&rank=3Doff] [TABLE = name=3DFormattedData&fields=3DStockNo,StockCode,QtyAvailable,QtyOnHand] [founditems][SHOWIF [url][THISROW][/URL]~[url]|[/URL]][LISTWORDS = words=3D[THISROW]&delimiters=3D|][getchars = start=3D1&end=3D&trim=3Dboth][WORD][/getchars] [/LISTWORDS] [/SHOWIF][/FOUNDITEMS] [/TABLE] [/SEARCH] [SEARCH table=3DFormattedData&neSTOCKNOdatarq=3DStockNo] [founditems][StockNo] [StockCode] [QtyAvailable] = [QtyOnHand]
[/FOUNDITEMS] [/SEARCH] I have a whole heap of data coming in from MS SQL database that I need = to write to WebDNA db so I needed to wrangle the data so that I could = manage it into a db. Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 08/06/2013, at 3:31 PM, John Butler = wrote: > If you mean what Dan suggests, then I assume the chars will line up as = intended if the font used for display is one of the mono-spaced type. = (however you say that). >=20 > And then why not just shove the string into the db field, as always, = and the line-feed char gets converted to what they always do (is it = vertical tab?, I forget), and on output you just translate that char = back into line-feed. >=20 > Maybe I am off.. but this might help, as a start. >=20 > -G >=20 >=20 > On 2013-06-08, at 1:14 AM, Dan Strong wrote: >=20 >> Do you mean literally as it is shown there: plus signs, dashes, pipes = and all? Also, what kind of database? WebDNA flat-file? >>=20 >> -Dan Strong >> New World Creative LLC >> http://www.NewWorldCreative.com >>=20 >> On 6/7/2013 6:38 PM, Stuart Tremain wrote: >>> Does anyone have any tips of tidying this up so I can put it into a = database ? >>>=20 >>> = +------------+--------------------------+----------------------+----------= ------------+ >>> | StockNo | StockCode | QtyAvailable | = QtyOnHand | >>> = +------------+--------------------------+----------------------+----------= ------------+ >>> | 85 | GE.4619500 | 4.00 | = 4.00 | >>> = +------------+--------------------------+----------------------+----------= ------------+ >>>=20 >>>=20 >>>=20 >>>=20 >>>=20 >>> Regards >>>=20 >>> Stuart Tremain >>> IDFK Web Developments >>> AUSTRALIA >>> webdna@idfk.com.au >>>=20 >>>=20 >>>=20 >>>=20 >>> --------------------------------------------------------- >>> 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 >>=20 >> --------------------------------------------------------- >> 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 >=20 > --------------------------------------------------------- > 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
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:
Memory Error message (1998)
WebDNA 6 (2004)
emailer (1997)
W* 4.2 / WebCat (TPro) 3.0.5b / OS 8.5.1 / BW G3 (2000)
Search problems! (1999)
Spreadsheet App pref. [OT] (2001)
WebCat2 beta 11 - new prefs ... (1997)
What is WebDNA (1997)
Help name our technology! I found it (1997)
Webcatalog error, Plug-in for Webstar (1996)
Webten + Webcat running smooth (1998)
Some Questions (1997)
WebCatalog can't find database (1997)
emailer stuck (1997)
WebCatalog Hosting (1996)
Error Lob.db records error message not name (1997)
WebCatalog2 Feature Feedback (1996)
Error, 101 a DNS problem ? (1997)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
syntax question, not in online refernce (1997)