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:

Max Record length restated as maybe bug (1997) Search returns all, not 20 (1997) carriage returns in data (1997) Cart Numbers (1997) help testing quicktime delivery (1997) Multi Colonns (1998) send mail problem? (1997) Ok here is a question? (1997) Day of the week (2006) Encypt Question - Making New Users.db (1999) WebCat b15 Mac plug-in (1997) [WebDNA] for a rainy day.. if ever/when the hood is up again on the [function]/[return] code (2011) emailer and bad addresses (1997) WebCat editing, SiteGuard & SiteEdit (1997) alternatives for WebDNA (2004) Moment of Thanks (1997) Ok here is a question? (1997) Mac vs. Unix Line Endings (2002) notification solutions (1997) Webcatalog, Webstar and Crasharama (1999)