Re: [WebDNA] Convert Carriage Return From DB to Plain Text File

This WebDNA talk-list message is from

2019


It keeps the original formatting.
numero = 114802
interpreted = N
texte = 2428 --Apple-Mail=_328DF0B8-D7FA-4C42-A25B-5AEA8C96E5B8 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Hi Terry Have a look at [INPUT] http://webdna.us/page.dna?numero=3D182 = Kind regards Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@plsoftware.com.au > On 24 Sep 2019, at 10:29, Terry Nair wrote: >=20 > Going bonkers trying to figure this out using [convertchars]. > =20 > As an example, we have a textarea with the following; > =20 > 1st Line > 2nd Line > =20 > It gets [url] when submitting to a DB and getting it back to display = either within a textarea box or just as a text in HTML format to display = in browser is no issue with the correct tags. We will get =E2=80=A6=E2=80=A6= > =20 > 1st Line > 2nd Line > =20 > The same DB data when pushed to a plain text file (Writefile or = Sendmail message body) does not do the carriage thingy at all. > =20 > =20 > As an example (1) =E2=80=A6. > =20 > [unurl][DB_data][/unurl] gives this result =E2=80=A6. > =20 > 1st Line 2nd Line > =20 > =E2=80=A6.everything on one line. > =20 > =20 > As an example (2) =E2=80=A6. > =20 > [convertchars][unurl][DB_data][/unurl][/convertchars] gives this = result =E2=80=A6. > =20 > 1st Line
2nd Line > =20 > =E2=80=A6.everything on one line with br tag where a carriage return = is supposed to be. > =20 > =20 > I think I need a custom conversion DB to get things right. Seen it = mentioned in archive Talklist that folks created called EmailMime.db, = etc. =E2=80=A6but cannot find it to test it out. > =20 > Anyone out there can help me out on this issue would be most = appreciated. Again, no issue DB/HTML or Textarea interchange. Just DB = output to plain text file =E2=80=A6how do I get the Db data to convert = stored carriage return correctly. > =20 > Many thanks folks > Terry Nair > =20 > =20 > =20 > =20 > =20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list = talk@webdna.us To unsubscribe, E-mail to: = talk-leave@webdna.us archives: = http://www.webdna.us/page.dna?numero=3D55 = Bug Reporting: = support@webdna.us --Apple-Mail=_328DF0B8-D7FA-4C42-A25B-5AEA8C96E5B8 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Hi = Terry

Have a look at = [INPUT]



Kind regards

Stuart Tremain
Pharoah Lane Software
AUSTRALIA







On 24 Sep 2019, at 10:29, Terry Nair <terrynair@prism4u.com> wrote:

Going bonkers trying to figure this out = using [convertchars].
 
As an example, we = have a textarea with the following;
 
1st Line
2nd Line
 
It gets [url] when = submitting to a DB and getting it back to display either within a = textarea box or just as a text in HTML format to display in browser is = no issue with the correct tags. We will get =E2=80=A6=E2=80=A6
 
1st Line
2nd Line
 
The same DB data when = pushed to a plain text file (Writefile or Sendmail message body) does = not do the carriage thingy at all.
 
 
As an example (1) =E2=80=A6.=
 
[unurl][DB_data][/unurl] = gives this result =E2=80=A6.
 
1st Line= 2nd Line
 
=E2=80=A6.everything on = one line.
 
 
As an example (2) = =E2=80=A6.
 
[convertchars][unurl][DB_data][/unurl][/convertchars] gives = this result =E2=80=A6.
 
1st Line<br>2nd Line
 
=E2=80=A6.everything on = one line with br tag where a carriage return is supposed to be.
 
 
I think I need a = custom conversion DB to get things right. Seen it mentioned in archive = Talklist that folks created called EmailMime.db, etc. =E2=80=A6but = cannot find it to test it out.
 
Anyone out there can = help me out on this issue would be most appreciated. Again, no issue = DB/HTML or Textarea interchange. Just DB output to plain text file = =E2=80=A6how do I get the Db data to convert stored carriage return = correctly.
 
Many thanks folks
Terry Nair
 
 
 
 
 
--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list talk@webdna.us To = unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us

= --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --Apple-Mail=_328DF0B8-D7FA-4C42-A25B-5AEA8C96E5B8-- . Associated Messages, from the most recent to the oldest:

    
  1. RE: [WebDNA] Convert Carriage Return From DB to Plain Text File ("Terry Nair" 2019)
  2. Re: [WebDNA] Convert Carriage Return From DB to Plain Text File (Stuart Tremain 2019)
  3. [WebDNA] Convert Carriage Return From DB to Plain Text File ("Terry Nair" 2019)
2428 --Apple-Mail=_328DF0B8-D7FA-4C42-A25B-5AEA8C96E5B8 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Hi Terry Have a look at [input] http://webdna.us/page.dna?numero=3D182 = Kind regards Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@plsoftware.com.au > On 24 Sep 2019, at 10:29, Terry Nair wrote: >=20 > Going bonkers trying to figure this out using [convertchars]. > =20 > As an example, we have a textarea with the following; > =20 > 1st Line > 2nd Line > =20 > It gets [url] when submitting to a DB and getting it back to display = either within a textarea box or just as a text in HTML format to display = in browser is no issue with the correct tags. We will get =E2=80=A6=E2=80=A6= > =20 > 1st Line > 2nd Line > =20 > The same DB data when pushed to a plain text file (Writefile or = Sendmail message body) does not do the carriage thingy at all. > =20 > =20 > As an example (1) =E2=80=A6. > =20 > [unurl][DB_data][/unurl] gives this result =E2=80=A6. > =20 > 1st Line 2nd Line > =20 > =E2=80=A6.everything on one line. > =20 > =20 > As an example (2) =E2=80=A6. > =20 > [convertchars][unurl][DB_data][/unurl][/convertchars] gives this = result =E2=80=A6. > =20 > 1st Line
2nd Line > =20 > =E2=80=A6.everything on one line with br tag where a carriage return = is supposed to be. > =20 > =20 > I think I need a custom conversion DB to get things right. Seen it = mentioned in archive Talklist that folks created called EmailMime.db, = etc. =E2=80=A6but cannot find it to test it out. > =20 > Anyone out there can help me out on this issue would be most = appreciated. Again, no issue DB/HTML or Textarea interchange. Just DB = output to plain text file =E2=80=A6how do I get the Db data to convert = stored carriage return correctly. > =20 > Many thanks folks > Terry Nair > =20 > =20 > =20 > =20 > =20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list = talk@webdna.us To unsubscribe, E-mail to: = talk-leave@webdna.us archives: = http://www.webdna.us/page.dna?numero=3D55 = Bug Reporting: = support@webdna.us --Apple-Mail=_328DF0B8-D7FA-4C42-A25B-5AEA8C96E5B8 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Hi = Terry

Have a look at = [input]



Kind regards

Stuart Tremain
Pharoah Lane Software
AUSTRALIA







On 24 Sep 2019, at 10:29, Terry Nair <terrynair@prism4u.com> wrote:

Going bonkers trying to figure this out = using [convertchars].
 
As an example, we = have a textarea with the following;
 
1st Line
2nd Line
 
It gets [url] when = submitting to a DB and getting it back to display either within a = textarea box or just as a text in HTML format to display in browser is = no issue with the correct tags. We will get =E2=80=A6=E2=80=A6
 
1st Line
2nd Line
 
The same DB data when = pushed to a plain text file (Writefile or Sendmail message body) does = not do the carriage thingy at all.
 
 
As an example (1) =E2=80=A6.=
 
[unurl][DB_data][/unurl] = gives this result =E2=80=A6.
 
1st Line= 2nd Line
 
=E2=80=A6.everything on = one line.
 
 
As an example (2) = =E2=80=A6.
 
[convertchars][unurl][DB_data][/unurl][/convertchars] gives = this result =E2=80=A6.
 
1st Line<br>2nd Line
 
=E2=80=A6.everything on = one line with br tag where a carriage return is supposed to be.
 
 
I think I need a = custom conversion DB to get things right. Seen it mentioned in archive = Talklist that folks created called EmailMime.db, etc. =E2=80=A6but = cannot find it to test it out.
 
Anyone out there can = help me out on this issue would be most appreciated. Again, no issue = DB/HTML or Textarea interchange. Just DB output to plain text file = =E2=80=A6how do I get the Db data to convert stored carriage return = correctly.
 
Many thanks folks
Terry Nair
 
 
 
 
 
--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list talk@webdna.us To = unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us

= --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --Apple-Mail=_328DF0B8-D7FA-4C42-A25B-5AEA8C96E5B8-- . 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:

WebCatalog/WebMerchant bug? (1999) Okay, I give up... (1999) RE: Discounting prices across a site (1997) [OT] HTML TAB CODE (2002) 2nd WebCatalog2 Feature Request (1996) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) Web Developer Product Awards (1997) Where's Cart Created ? (1997) [delete] problem (1997) memory conflict with 3.0.8 (2001) searching twice on same field (1998) To Err or Not Custom Error (1999) FW: Shipping calculations (1997) OT: javascript for dynamic pulldowns? (1998) Hyperboard/bulletin board available (1998) Error & Problem (1997) WebCatalog for Postcards ? (1997) The beginning (1997) using showpage and showcart commands (1996) WCS Newbie question (1997)