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:

Using [redirect] in the middle of a page? (1999) Feature Request (2003) Major bug report on rootbeer (1997) AppleScript question (1997) Template Encryption (1998) Talk Archives down? (2002) Reminder... (2003) Formatting time output (2000) TCPsend with POST? (1999) Help! WebCat2 bug (1997) Re[4]: Problem with new formvariables (2000) ImageMagick on OSX (2003) Reversed words (1997) Document Contains No Data, Blank Pages with b4, b6 mac! (1999) Sorry I didn't pay attention-but ??? (1997) Two submit buttons ? (1997) Serial Number Issue (2000) Forms Search Questions (1997) iis 4.0 (1997) WC 2.0 frames feature (1997)