Re: [WebDNA] merging multiple database fields into a new field

This WebDNA talk-list message is from

2016


It keeps the original formatting.
numero = 112708
interpreted = N
texte = 291 ------=_Part_916127_472351089.1459503935103 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable But I can't reply if I go to that spot on the webpage, I can just read the = posts... The original post I made and all the "answers just showed up in my yahoo em= ail. Weird [input][input] wasn't helping.. I was combining multiple records into one, = needing a line break after each one. Placing=C2=A0[convertchars]%0D[/convertchars] inbetween the field names gav= e me a line break like I wanted. It gets frustrating trying to search the talklist archives......=C2=A0The o= ld ones, the "abyss" are easier to search than the newer posts over at Mail= ing list archive =20 | =20 | | =20 Mailing list archive | | | =20 I'm always pretty sure sure whatever I'm trying to deal with has an answer = or an angle to look at regarding it, just seems difficult at times to find.= =C2=A0 =20 On Friday, April 1, 2016 12:55 AM, "christophe.billiottet@webdna.us" wrote: =20 Have a look at www.webdna.us, menu "community": you will see your posts an= d replies, if any. - chris > On Apr 1, 2016, at 01:56, Rich Kwas wrote: >=20 > Seems I'm not getting any of the talklist posts to either of my 2 emails = again.... > Happens a lot with my yahoo account, just occurred now as well with gmail= ...... > Can't answer myquestion without created a new post...... >=20 >=20 >=20 > SOLVED >=20 > Poked around in my StandardConversions.db and the following works as I ne= ed. >=20 >=20 > [append db=3D^rs-avs/listings_new.db]ad_ID=3D[SKU]&comments=3D[url][text2= ][/url][convertchars]%0D[/convertchars][url][text4][/url][/append] >=20 >=20 > My original post about this..... >=20 > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D > I need to merge multiple text fields into one large text field. (making a= new db for a site re-design) >=20 > I can do it very easily via a form one by one with input fields like this= , showing multiple text fields in a new text area, and then when I "submit"= the form, the 13 fields get written into the new database field just perfe= ctly. >=20 > >=20 >=20 > But I have thousands of listings where these multiple fields need to be m= erged into one new field.... >=20 > If I create a new db from the old by merging/appending like this >=20 > [append db=3D^rs-avs/listings_new.db]ad_ID=3D[SKU]&ad_text=3D[url][text2]= [text4][/url][/append] >=20 > I do get the 2 fields written OK with text4 following text 2 BUT I there = not even any space between the two fields in the merged one. I can't seem t= o get a line break / carriage return between [text2]&[text4] like I do in t= he form sample above. >=20 > Since there really isn't anything between [text2][text4] when I'm doing t= he append is there a way I can place a line break between these fields? >=20 > Looking at my old .db I see a "VT" in a black box, that being the line br= eak/carriage return. > --------------------------------------------------------- This message is= sent to you because you are subscribed to the mailing list . To unsubscrib= e, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Repor= ting: support@webdna.us --------------------------------------------------------- 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 ------=_Part_916127_472351089.1459503935103 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
But I can't reply if I go to that spot on the = webpage, I can just read the posts...

The original post I made and all the "answers just sho= wed up in my yahoo email. Weird

[input][input] wasn't helping.. I was combining multiple records i= nto one, needing a line break after each one.

Placing [convertchars]%0D[/convertcha= rs] inbetween the field names gave me a line break like I wanted.

It gets frustrating t= rying to search the talklist archives...... 
The old ones, the "abyss" are easi= er to search than the newer posts over at Mailing list archive



I'm always pretty sure sure whatever I'm trying to deal with has an an= swer or an angle to look at regarding it, just seems difficult at times to = find. 

<= br>


On Friday, April 1, 2016 12:55 AM, "christophe.b= illiottet@webdna.us" <christophe.billiottet@webdna.us> wrote:


Have a look at www.webdn= a.us, menu "community": you will see your posts and replies, if any.

- chris


> On = Apr 1, 2016, at 01:56, Rich Kwas <richkwas= niewski@yahoo.com> wrote:
>
= > Seems I'm not getting any of the talklist posts to either of my 2 emai= ls again....
> Happens a lot with my yahoo account, ju= st occurred now as well with gmail.....
> Can't answer= myquestion without created a new post......
>
>
>
> SOLVED
>
> Poked around in my StandardConv= ersions.db and the following works as I need.
>
>
> [append db=3D^rs-avs/listings_new= ..db]ad_ID=3D[SKU]&comments=3D[url][text2][/url][convertchars]%0D[/conve= rtchars][url][text4][/url][/append]
>
>
> My original post about this.....
>
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> I need to me= rge multiple text fields into one large text field. (making a new db for a = site re-design)
>
> I can do it = very easily via a form one by one with input fields like this, showing mult= iple text fields in a new text area, and then when I "submit" the form, the= 13 fields get written into the new database field just perfectly.
>
> <textarea name=3D"__MERGED_TEXT_C= OPY" wrap=3D"virtual" rows=3D"75" cols=3D"125">
> A= LL OF THE COPY IN THIS AD:
> =3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D
> [text1]
> [text2]
> [text3]
> [text4]
> [text5]
> [text6]
> [text7= ]
> [text8]
> [text9]
> [text10]
> [text11]
>= [text12]
> [text13]
> </texta= rea>
>
>
&= gt; But I have thousands of listings where these multiple fields need to be= merged into one new field....
>
&g= t; If I create a new db from the old by merging/appending like this
>
> [append db=3D^rs-avs/listings_new.d= b]ad_ID=3D[SKU]&ad_text=3D[url][text2][text4][/url][/append]
>
> I do get the 2 fields written OK wit= h text4 following text 2 BUT I there not even any space between the two fie= lds in the merged one. I can't seem to get a line break / carriage return b= etween [text2]&[text4] like I do in the form sample above.
>
> Since there really isn't anything betwee= n [text2][text4] when I'm doing the append is there a way I can place a lin= e break between these fields?
>
>= ; Looking at my old .db I see a "VT" in a black box, that being the line br= eak/carriage return.

> -------------------------= -------------------------------- This message is sent to you because you ar= e subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us

-------= --------------------------------------------------
This m= essage is sent to you because you are subscribed to
the m= ailing list <talk@webdna.us>.
To unsubs= cribe, E-mail to: <talk-leave@webdna.us>
archives: http://mail.webdna.us/list/talk@webdna.= us
Bug Reporting: support@webdna.us=

--------------------------------------------------------- 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 ------=_Part_916127_472351089.1459503935103-- . Associated Messages, from the most recent to the oldest:

    
  1. Re: ***JUNK MAIL*** Re: [WebDNA] merging multiple database fields into a new field (Michael Davis 2016)
  2. Re: [WebDNA] merging multiple database fields into a new field (Rich Kwas 2016)
  3. Re: [WebDNA] merging multiple database fields into a new field (Stuart Tremain 2016)
  4. Re: [WebDNA] merging multiple database fields into a new field (christophe.billiottet@webdna.us 2016)
  5. [WebDNA] merging multiple database fields into a new field (Rich Kwas 2016)
291 ------=_Part_916127_472351089.1459503935103 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable But I can't reply if I go to that spot on the webpage, I can just read the = posts... The original post I made and all the "answers just showed up in my yahoo em= ail. Weird [input][input] wasn't helping.. I was combining multiple records into one, = needing a line break after each one. Placing=C2=A0[convertchars]%0D[/convertchars] inbetween the field names gav= e me a line break like I wanted. It gets frustrating trying to search the talklist archives......=C2=A0The o= ld ones, the "abyss" are easier to search than the newer posts over at Mail= ing list archive =20 | =20 | | =20 Mailing list archive | | | =20 I'm always pretty sure sure whatever I'm trying to deal with has an answer = or an angle to look at regarding it, just seems difficult at times to find.= =C2=A0 =20 On Friday, April 1, 2016 12:55 AM, "christophe.billiottet@webdna.us" wrote: =20 Have a look at www.webdna.us, menu "community": you will see your posts an= d replies, if any. - chris > On Apr 1, 2016, at 01:56, Rich Kwas wrote: >=20 > Seems I'm not getting any of the talklist posts to either of my 2 emails = again.... > Happens a lot with my yahoo account, just occurred now as well with gmail= ...... > Can't answer myquestion without created a new post...... >=20 >=20 >=20 > SOLVED >=20 > Poked around in my StandardConversions.db and the following works as I ne= ed. >=20 >=20 > [append db=3D^rs-avs/listings_new.db]ad_ID=3D[SKU]&comments=3D[url][text2= ][/url][convertchars]%0D[/convertchars][url][text4][/url][/append] >=20 >=20 > My original post about this..... >=20 > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D > I need to merge multiple text fields into one large text field. (making a= new db for a site re-design) >=20 > I can do it very easily via a form one by one with input fields like this= , showing multiple text fields in a new text area, and then when I "submit"= the form, the 13 fields get written into the new database field just perfe= ctly. >=20 > >=20 >=20 > But I have thousands of listings where these multiple fields need to be m= erged into one new field.... >=20 > If I create a new db from the old by merging/appending like this >=20 > [append db=3D^rs-avs/listings_new.db]ad_ID=3D[SKU]&ad_text=3D[url][text2]= [text4][/url][/append] >=20 > I do get the 2 fields written OK with text4 following text 2 BUT I there = not even any space between the two fields in the merged one. I can't seem t= o get a line break / carriage return between [text2]&[text4] like I do in t= he form sample above. >=20 > Since there really isn't anything between [text2][text4] when I'm doing t= he append is there a way I can place a line break between these fields? >=20 > Looking at my old .db I see a "VT" in a black box, that being the line br= eak/carriage return. > --------------------------------------------------------- This message is= sent to you because you are subscribed to the mailing list . To unsubscrib= e, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Repor= ting: support@webdna.us --------------------------------------------------------- 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 ------=_Part_916127_472351089.1459503935103 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
But I can't reply if I go to that spot on the = webpage, I can just read the posts...

The original post I made and all the "answers just sho= wed up in my yahoo email. Weird

[input][input] wasn't helping.. I was combining multiple records i= nto one, needing a line break after each one.

Placing [convertchars]%0D[/convertcha= rs] inbetween the field names gave me a line break like I wanted.

It gets frustrating t= rying to search the talklist archives...... 
The old ones, the "abyss" are easi= er to search than the newer posts over at Mailing list archive



I'm always pretty sure sure whatever I'm trying to deal with has an an= swer or an angle to look at regarding it, just seems difficult at times to = find. 

<= br>


On Friday, April 1, 2016 12:55 AM, "christophe.b= illiottet@webdna.us" <christophe.billiottet@webdna.us> wrote:


Have a look at www.webdn= a.us, menu "community": you will see your posts and replies, if any.

- chris


> On = Apr 1, 2016, at 01:56, Rich Kwas <richkwas= niewski@yahoo.com> wrote:
>
= > Seems I'm not getting any of the talklist posts to either of my 2 emai= ls again....
> Happens a lot with my yahoo account, ju= st occurred now as well with gmail.....
> Can't answer= myquestion without created a new post......
>
>
>
> SOLVED
>
> Poked around in my StandardConv= ersions.db and the following works as I need.
>
>
> [append db=3D^rs-avs/listings_new= ..db]ad_ID=3D[SKU]&comments=3D[url][text2][/url][convertchars]%0D[/conve= rtchars][url][text4][/url][/append]
>
>
> My original post about this.....
>
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> I need to me= rge multiple text fields into one large text field. (making a new db for a = site re-design)
>
> I can do it = very easily via a form one by one with input fields like this, showing mult= iple text fields in a new text area, and then when I "submit" the form, the= 13 fields get written into the new database field just perfectly.
>
> <textarea name=3D"__MERGED_TEXT_C= OPY" wrap=3D"virtual" rows=3D"75" cols=3D"125">
> A= LL OF THE COPY IN THIS AD:
> =3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D
> [text1]
> [text2]
> [text3]
> [text4]
> [text5]
> [text6]
> [text7= ]
> [text8]
> [text9]
> [text10]
> [text11]
>= [text12]
> [text13]
> </texta= rea>
>
>
&= gt; But I have thousands of listings where these multiple fields need to be= merged into one new field....
>
&g= t; If I create a new db from the old by merging/appending like this
>
> [append db=3D^rs-avs/listings_new.d= b]ad_ID=3D[SKU]&ad_text=3D[url][text2][text4][/url][/append]
>
> I do get the 2 fields written OK wit= h text4 following text 2 BUT I there not even any space between the two fie= lds in the merged one. I can't seem to get a line break / carriage return b= etween [text2]&[text4] like I do in the form sample above.
>
> Since there really isn't anything betwee= n [text2][text4] when I'm doing the append is there a way I can place a lin= e break between these fields?
>
>= ; Looking at my old .db I see a "VT" in a black box, that being the line br= eak/carriage return.

> -------------------------= -------------------------------- This message is sent to you because you ar= e subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us

-------= --------------------------------------------------
This m= essage is sent to you because you are subscribed to
the m= ailing list <talk@webdna.us>.
To unsubs= cribe, E-mail to: <talk-leave@webdna.us>
archives: http://mail.webdna.us/list/talk@webdna.= us
Bug Reporting: support@webdna.us=

--------------------------------------------------------- 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 ------=_Part_916127_472351089.1459503935103-- . Rich Kwas

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:

Press Release hit the NewsWire!!! (1997) database size? (1997) ShowNext Command (1997) PCS Emailer's role ? (1997) restarting service remotely on NT (1997) Checkboxes (1997) [SHOWIF] (1997) Fwd: more ! testing (1997) Format date.... (2003) WebCat editing, SiteGuard & SiteEdit (1997) F2 to F3 rocky transition (1997) WebCat2b13MacPlugIn - More limits on [include] (1997) Part Html part WebDNA (1997) [WriteFile] problems (1997) Converting Quotes in Javascript (2001) tpl and Explorer (1998) read and write you own cookies with webcat (1997) text size limitation (1997) Emailer setup (1997) [url] with frames (2003)