From user-return-32440-archive-asf-public=cust-asf.ponee.io@couchdb.apache.org Sat Mar 6 20:45:02 2021 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mxout1-ec2-va.apache.org (mxout1-ec2-va.apache.org [3.227.148.255]) by mx-eu-01.ponee.io (Postfix) with ESMTPS id F135B18065C for ; Sat, 6 Mar 2021 21:45:01 +0100 (CET) Received: from mail.apache.org (mailroute1-lw-us.apache.org [207.244.88.153]) by mxout1-ec2-va.apache.org (ASF Mail Server at mxout1-ec2-va.apache.org) with SMTP id 7BD4B4316C for ; Sat, 6 Mar 2021 20:45:00 +0000 (UTC) Received: (qmail 70443 invoked by uid 500); 6 Mar 2021 20:44:59 -0000 Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@couchdb.apache.org Delivered-To: mailing list user@couchdb.apache.org Received: (qmail 70431 invoked by uid 99); 6 Mar 2021 20:44:59 -0000 Received: from spamproc1-he-de.apache.org (HELO spamproc1-he-de.apache.org) (116.203.196.100) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 06 Mar 2021 20:44:59 +0000 Received: from localhost (localhost [127.0.0.1]) by spamproc1-he-de.apache.org (ASF Mail Server at spamproc1-he-de.apache.org) with ESMTP id 64F771FF39B for ; Sat, 6 Mar 2021 20:44:58 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamproc1-he-de.apache.org X-Spam-Flag: NO X-Spam-Score: 0.92 X-Spam-Level: X-Spam-Status: No, score=0.92 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, HTML_MESSAGE=0.2, SPF_FAIL=0.919, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamproc1-he-de.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=cherrypc.com Received: from mx1-ec2-va.apache.org ([116.203.227.195]) by localhost (spamproc1-he-de.apache.org [116.203.196.100]) (amavisd-new, port 10024) with ESMTP id 6Iyyc4CWqFGS for ; Sat, 6 Mar 2021 20:44:57 +0000 (UTC) Received-SPF: Fail (mailfrom) identity=mailfrom; client-ip=67.205.151.52; helo=box.ezemailserver.com; envelope-from=bill@cherrypc.com; receiver= Received: from box.ezemailserver.com (box.ezemailserver.com [67.205.151.52]) by mx1-ec2-va.apache.org (ASF Mail Server at mx1-ec2-va.apache.org) with ESMTPS id 263F9BC4FF for ; Sat, 6 Mar 2021 20:44:57 +0000 (UTC) Received: from macbill.pk5001z (unknown [67.6.77.89]) (using TLSv1 with cipher ECDHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by box.ezemailserver.com (Postfix) with ESMTPSA id 2F75DE1017 for ; Sat, 6 Mar 2021 14:44:50 -0600 (CST) Authentication-Results: box.ezemailserver.com; dmarc=fail header.from=cherrypc.com X-ASF-DKIM-Sig: v=1; a=rsa-sha256; c=simple/simple; d=cherrypc.com; s=mail; t=1615063490; bh=v+6jc+uvWEKW9INZldbPOaHEpAx9ka0cKMxWooTX6YU=; h=From:Subject:Date:To:From; b=twgRlOpil9Q9ewicRFkgyVYDLcKnOz9HfphWyWpVC+VGvAGScnT/We8muMqcu4cEI Nkw5uwVsHcjy2CVGJVJb4ACGsmlphgS7aaxoaz3lg3WxLRyxuq86CLBWSnyplF74RS t9NnAmI9CNeFqhBvNQT55ZQAw3173qBfepWnmm7f/snSCIzYhLCJjsWwSow09IjWrR AMHC1kmC5poCTv/4j0ffowdxwyX2z1aFCEHHL9YCME3j/BhJHSUdvUjshoJBRmCQlU SSqprgd5WrgDKBa8JY90A26CvJ7e1a/upC9Rdi7TQzKK3/vkmad6JrfCOm5Awc/PG3 z6SkiQ7c7W0pQ== From: Bill Stephenson Content-Type: multipart/alternative; boundary="Apple-Mail=_E12DDD21-9B60-4672-B4C3-24498D29C977" Subject: exporting text to JSON hangs on %27 character Message-Id: Date: Sat, 6 Mar 2021 14:44:44 -0600 To: user@couchdb.apache.org Mime-Version: 1.0 (Mac OS X Mail 9.3 \(3124\)) X-Mailer: Apple Mail (2.3124) --Apple-Mail=_E12DDD21-9B60-4672-B4C3-24498D29C977 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 I=E2=80=99m using Perl to convert old CGI.pm =E2=80=9Csave=E2=80=9D = files to JSON that look like this: c_name=3DJoseph%20Semeister c_address1=3D9445%20Sofa%27s%20Mill%20Rd c_address2=3D c_city=3DRed%20Tree c_state=3DPA c_zip=3D17356 =3D and loading them into a CouchDB (v. 3.1.1) with curl but files with that = " %27 =E2=80=9C string hang with an error: malformed JSON string, neither tag, array, object, number, string or = atom, at character offset 0 (before "(end of string)") I=E2=80=99ve narrowed down the issue to that =E2=80=9C%27=E2=80=9D and I = can remove that like so: $myJSON =3D~ s/'//; But that doesn=E2=80=99t preserve the original text string "9445 = Sofa=E2=80=99s Mill Rd=E2=80=9D. I=E2=80=99m not savvy enough to call this a =E2=80=9Cbug=E2=80=9D but = this doesn=E2=80=99t break on other encoded text like =E2=80=9C%20=E2=80=9D= .=20 Anyone got any suggestions for how I might work around this? -- Kindest Regards, Bill Stephenson --Apple-Mail=_E12DDD21-9B60-4672-B4C3-24498D29C977--