texte = 286 ------=_Part_680437_161304824.1459463691162 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit 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_680437_161304824.1459463691162 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
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 th= is, showing multiple text fields in a new text area, and then when I "submi= t" the form, the 13 fields get written into the new database field just per= fectly.
<= br>
<t= extarea name=3D"__MERGED_TEXT_COPY" wrap=3D"virtual" rows=3D"75" cols=3D"12= 5">
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 thousan= ds of listings where these multiple fields need to be merged into one new f= ield....
= 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][text4][/url][/appe= nd]
<= br>
I do = get the 2 fields written OK with text4 following text 2 BUT I there not eve= n 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 doi= ng the append is there a way I can place a line break between these fields?=
Looking at m= y old .db I see a "VT" in a black box, that being the line break/carriage r= eturn.
--------------------------------------------------------- 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_680437_161304824.1459463691162-- .
Associated Messages, from the most recent to the oldest:
286 ------=_Part_680437_161304824.1459463691162 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit 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_680437_161304824.1459463691162 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable