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

This WebDNA talk-list message is from

2016


It keeps the original formatting.
numero = 112706
interpreted = N
texte = 289 --001a11c3277e3463ca052f66c7dc Content-Type: text/plain; charset=UTF-8 Hi Rich, I was about to solve your problem but it's only 8 am here, the comunity is worldwide so sometimes answers can take some litle time ;-) Lawrence 2016-04-01 0:56 GMT+02:00 Rich Kwas : > 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=^rs-avs/listings_new.db]ad_ID=[SKU]&comments=[url][text2][/url][convertchars]%0D[/convertchars][url][text4][/url][/append] > > > My original post about this..... > > ========================= > 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. > > > > > 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=^rs-avs/listings_new.db]ad_ID=[SKU]&ad_text=[url][text2][text4][/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 to the mailing list . To > unsubscribe, E-mail to: archives: > http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us > --001a11c3277e3463ca052f66c7dc Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Rich,
I was about to solve your pro= blem but it's only 8 am here, the comunity is worldwide so sometimes an= swers can take some litle time ;-)
Lawrence

2016-04-01 0:56 GMT+02:00 Rich= Kwas <richkwasniewski@yahoo.com>:
Seems I'm not getting any of the talklist posts t= o either of my 2 emails again....
Happens a lot with my yahoo acc= ount, 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][/url][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 fi= eld. (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 &quo= t;submit" the form, the 13 fields get written into the new database fi= eld just perfectly.

<te= xtarea name=3D"__MERGED_TEXT_COPY" wrap=3D"virtual" row= s=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
[tex= t1]
[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 t= his

[append db=3D^rs-avs/l= istings_new.db]ad_ID=3D[SKU]&ad_text=3D[url][text2][text4][/url][/appen= d]

I do get the 2 fiel= ds written OK with text4 following text 2 BUT I there not even any space be= tween the two fields in the merged one. I can't seem to get a line brea= k / carriage return between [text2]&[text4] like I do in the form sampl= e above.

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

Looking at my old .db I see a "VT&= quot; 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: suppo= rt@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 --001a11c3277e3463ca052f66c7dc-- . 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)
289 --001a11c3277e3463ca052f66c7dc Content-Type: text/plain; charset=UTF-8 Hi Rich, I was about to solve your problem but it's only 8 am here, the comunity is worldwide so sometimes answers can take some litle time ;-) Lawrence 2016-04-01 0:56 GMT+02:00 Rich Kwas : > 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=^rs-avs/listings_new.db]ad_ID=[SKU]&comments=[url][text2][/url][convertchars]%0D[/convertchars][url][text4][/url][/append] > > > My original post about this..... > > ========================= > 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. > > > > > 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=^rs-avs/listings_new.db]ad_ID=[SKU]&ad_text=[url][text2][text4][/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 to the mailing list . To > unsubscribe, E-mail to: archives: > http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us > --001a11c3277e3463ca052f66c7dc Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Rich,
I was about to solve your pro= blem but it's only 8 am here, the comunity is worldwide so sometimes an= swers can take some litle time ;-)
Lawrence

2016-04-01 0:56 GMT+02:00 Rich= Kwas <richkwasniewski@yahoo.com>:
Seems I'm not getting any of the talklist posts t= o either of my 2 emails again....
Happens a lot with my yahoo acc= ount, 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][/url][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 fi= eld. (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 &quo= t;submit" the form, the 13 fields get written into the new database fi= eld just perfectly.

<te= xtarea name=3D"__MERGED_TEXT_COPY" wrap=3D"virtual" row= s=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
[tex= t1]
[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 t= his

[append db=3D^rs-avs/l= istings_new.db]ad_ID=3D[SKU]&ad_text=3D[url][text2][text4][/url][/appen= d]

I do get the 2 fiel= ds written OK with text4 following text 2 BUT I there not even any space be= tween the two fields in the merged one. I can't seem to get a line brea= k / carriage return between [text2]&[text4] like I do in the form sampl= e above.

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

Looking at my old .db I see a "VT&= quot; 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: suppo= rt@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 --001a11c3277e3463ca052f66c7dc-- . "Lawrence Banahan - Author's Image"

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:

bug in [SendMail] (1997) PhotoMill -> PhotoMaster (1997) Up and running ... at last !! (1997) [OT] 'Email this story to a friend' (2003) PIXO support (1997) [OT] Search Engine Tips (2003) Speed Optimization - Mac (1997) Context and commands (1998) [WebDNA] WebDNA FastCGI (2012) Sku numbers (1997) Execute Applescript (1997) .. more on sliding discounts... (1997) Did you hear about this? (1997) Line Feed Character Appended (1998) all records returned. (1997) WebCat2b13MacPlugin - nested [xxx] contexts (1997) Re:Version 2.0 and 1.6 simultaneous (1997) TaxTotal Problem (1997) [WebDNA] Advices for Linux Config (2017) WordBreak Qestion (1998)