texte = 287 ------=_Part_699231_538408982.1459465017039 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit 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. ------=_Part_699231_538408982.1459465017039 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Seems I'm not getting any of the talklist posts to either of my 2 emails a= gain....
Happens a lo= t with my yahoo account, just occurred now as well with gmail.....
Can't answer myquestion witho= ut 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.d= b]ad_ID=3D[SKU]&comments=3D[url][text2][/url][convertchars]%0D[/convert= chars][url][text4][/url][/append]
My original pos= t 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 i= nto 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 li= ke 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 jus= t perfectly.
<textarea name=3D"__MERGED_T= EXT_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]
[t= ext7]
[text8]
[text9][text10]
[text11]
[text12]
[t= ext13]
</textarea&= gt;
But I have thousands of listings where these multip= le 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][tex= t2][text4][/url][/append]
I do get the 2 fields written OK with text4 f= ollowing text 2 BUT I there not even any space between the two fields in th= e merged one. I can't seem to get a line break / carriage return between [t= ext2]&[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 fie= lds?
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 ------=_Part_699231_538408982.1459465017039-- .
Associated Messages, from the most recent to the oldest:
287 ------=_Part_699231_538408982.1459465017039 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit 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. ------=_Part_699231_538408982.1459465017039 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Seems I'm not getting any of the talklist posts to either of my 2 emails a= gain....
Happens a lo= t with my yahoo account, just occurred now as well with gmail.....
Can't answer myquestion witho= ut created a new post......