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

This WebDNA talk-list message is from

2016

It keeps the original formatting. numero = 112707
interpreted = N
texte = 290--Apple-Mail=_AF924947-F4EB-448E-ACFE-BD31DBFEBED2Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=us-asciiI THINK that [INPUT][/INPUT] does the same thingKind regardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.au> On 1 Apr 2016, at 09: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 =need.>=20>=20> [append =db=3D^rs-avs/listings_new.db]ad_ID=3D[SKU]&comments=3D[url][text2][/url][c=onvertchars]%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 perfectly.>=20> >=20>=20> But I have thousands of listings where these multiple fields need to =be merged 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 to get a line break / carriage return between [text2]&[text4] =like I do in the form sample above.>=20> Since there really isn't anything between [text2][text4] when I'm =doing the 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 =break/carriage return.> --------------------------------------------------------- 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--Apple-Mail=_AF924947-F4EB-448E-ACFE-BD31DBFEBED2Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=us-asciiI THINK that =[INPUT][/INPUT] does the same thing

Kind regards

Stuart Tremain

IDFK Web Developments

AUSTRALIA

webdna@idfk.com.au

On 1 Apr 2016, at 09:56, Rich Kwas <richkwasniewski@yahoo.com> wrote:

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......

SOLVED

Poked around in my StandardConversions.db and the following =works as I need.

[append =db=3D^rs-avs/listings_new.db]ad_ID=3D[SKU]&comments=3D[url][text2][/ur=l][convertchars]%0D[/convertchars][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 merge 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 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 perfectly.

<textarea name=3D"__MERGED_TEXT_COPY" wrap=3D"virtual" =rows=3D"75" cols=3D"125">
ALL 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]
</textarea>

But I =have thousands of listings where these multiple fields need to be merged =into one new field....

If I =create a new db from the old by merging/appending like this

[append= =db=3D^rs-avs/listings_new.db]ad_ID=3D[SKU]&ad_text=3D[url][text2][text=4][/url][/append]

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 to =get a line break / carriage return between [text2]&[text4] like I do =in the form sample above.

Since =there really isn't anything between [text2][text4] when I'm doing the =append is there a way I can place a line break between these =fields?

Looking at my old =..db I see a "VT" in a black box, that being the line break/carriage =return.
---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us

=---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us--Apple-Mail=_AF924947-F4EB-448E-ACFE-BD31DBFEBED2--. Associated Messages, from the most recent to the oldest:

Re: ***JUNK MAIL*** Re: [WebDNA] merging multiple database fields into a new field (Michael Davis 2016)
Re: [WebDNA] merging multiple database fields into a new field (Rich Kwas 2016)
Re: [WebDNA] merging multiple database fields into a new field (Stuart Tremain 2016)
Re: [WebDNA] merging multiple database fields into a new field (christophe.billiottet@webdna.us 2016)
[WebDNA] merging multiple database fields into a new field (Rich Kwas 2016)

290--Apple-Mail=_AF924947-F4EB-448E-ACFE-BD31DBFEBED2Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=us-asciiI THINK that [input][/INPUT] does the same thingKind regardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.au> On 1 Apr 2016, at 09: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 =need.>=20>=20> [append =db=3D^rs-avs/listings_new.db]ad_ID=3D[SKU]&comments=3D[url][text2][/url][c=onvertchars]%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 perfectly.>=20> >=20>=20> But I have thousands of listings where these multiple fields need to =be merged 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 to get a line break / carriage return between [text2]&[text4] =like I do in the form sample above.>=20> Since there really isn't anything between [text2][text4] when I'm =doing the 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 =break/carriage return.> --------------------------------------------------------- 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--Apple-Mail=_AF924947-F4EB-448E-ACFE-BD31DBFEBED2Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=us-asciiI THINK that =[input][/INPUT] does the same thing