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:

A better WebCat whois (was [OT] Domain Name Scam) (2000) Location of Browser Info.txt file (1997) NT error logs (1997) Two prices in shoppingcart? (1997) A few questions. . . (1997) form data submission gets truncated (1997) Test, please ignore (2004) Menu to select product variations (1997) WebCat2 - [include] tags (1997) Combining Searches (1998) Authorize.net setup (2002) Text data with spaces in them... (1997) not interpreting Q (2001) taxRate is fine but taxTotal isn't (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) find with exceptions (1997) auto adding SKUs w/DB helper (1998) Re1000001: Setting up shop (1997) Another New Site (1998) Emailer problem with WC 2.1, NT, WebSite 2.1 (1998)