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:

WebCat editing, SiteGuard & SiteEdit (1997) Whats wrong with this???? (2001) WebDNA Solutions ... sorry! (1997) Running _every_ page through WebCat ? (1997) IP address & domain name problem (2003) Customizing WebDelivery.html (1998) WebCatalog memory error. (1998) Database Updates (1997) Initiating NewCart (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) Need help... (1997) I read the manual (2000) Show all from database (2001) Thanks Grant (1997) Emailer Set Up (1997) OT: Backup Strategies (2007) [OT] Browser's search via javascript? (2003) WebCat2: Found Items syntax, etc. (1997) Feature request (1998) File Uploads... (1997)