From user-return-32442-archive-asf-public=cust-asf.ponee.io@couchdb.apache.org Sat Mar 6 22:11:27 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-he-de.apache.org (mxout1-he-de.apache.org [95.216.194.37]) by mx-eu-01.ponee.io (Postfix) with ESMTPS id F355118065C for ; Sat, 6 Mar 2021 23:11:26 +0100 (CET) Received: from mail.apache.org (mailroute1-lw-us.apache.org [207.244.88.153]) by mxout1-he-de.apache.org (ASF Mail Server at mxout1-he-de.apache.org) with SMTP id E3943644B4 for ; Sat, 6 Mar 2021 22:11:22 +0000 (UTC) Received: (qmail 25258 invoked by uid 500); 6 Mar 2021 22:11:17 -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 25246 invoked by uid 99); 6 Mar 2021 22:11:17 -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 22:11:17 +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 9E7141FF39B for ; Sat, 6 Mar 2021 22:11:15 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamproc1-he-de.apache.org X-Spam-Flag: NO X-Spam-Score: -0.001 X-Spam-Level: X-Spam-Status: No, score=-0.001 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, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamproc1-he-de.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.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 HTSVieTsy3oI for ; Sat, 6 Mar 2021 22:11:15 +0000 (UTC) Received-SPF: Pass (mailfrom) identity=mailfrom; client-ip=209.85.167.51; helo=mail-lf1-f51.google.com; envelope-from=martin.broerse@gmail.com; receiver= Received: from mail-lf1-f51.google.com (mail-lf1-f51.google.com [209.85.167.51]) by mx1-ec2-va.apache.org (ASF Mail Server at mx1-ec2-va.apache.org) with ESMTPS id 8E14EBD064 for ; Sat, 6 Mar 2021 22:11:14 +0000 (UTC) Received: by mail-lf1-f51.google.com with SMTP id f1so12813135lfu.3 for ; Sat, 06 Mar 2021 14:11:14 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=gNTwN6GBZhFTmn4czpibzZQCn7wA2aQnDKG0akl00Po=; b=SYan3Y3tHEv+wxNgm85A8ZlG0SBUSeT3u/iSNZNGpQYfqQL/JKelEgflBrWLW89XvD +2q9Dpq7ccjNIkGd9nzJ+HXedSR7ezsZ12UWaDT7jt2R+7uScO3pfpDPqDs3qmHU08op 6ACHUANHYtZZaTYgcvjjsi+SfnZkb/4vT9dOGLTmAO2mkGZa7dfPaeoUbou5/odLjQpw WNHK490y3JkXdNYqfnA2sIJYXHNs996KyD5aSOHsTwd20hy1s39LGEppAtwst57leKPn hA45YvyXVDHO6pdFPLxc+sTsr/QoSCOe+yYjW0pekd+d4zRM3N2ysVD6NlQFiKTUsvoU Q2uQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=gNTwN6GBZhFTmn4czpibzZQCn7wA2aQnDKG0akl00Po=; b=O/CMotj/4piQwbRef9HHdOoQCELLk8GX5fKyL1WJjt9z8ByTKsvaUrGbswHz2FzYB+ WD4wx0YSqL9yx/0c2Xsn6RXuWlaSu0IyYjiGB2kxe8Eh97g/w5J2tcy2VjyB0UMm2Cye cTnZx2Eec8XO0EOZCwl4/Eirn2LmeORl9Nejto173mEx3IHnAHJUDG5wAKSkmpP85LRM jK0FqJldBrKjrRiVnlN5ztKefoUd78ZsCglJ0WBhlGiO7WdfVkrv5fMGszLlSQlxv+f+ OAfV3W45bNb8DMyTvjL/UaxrM6I/M98LlTuU6zeeZn3aqwpUAl/7W3hEK9zwS//oXY7F ubhQ== X-Gm-Message-State: AOAM5315vruSG1HBgkc4ooV28mmKalnYNfcnj9LTBwI7Di8punBsviOb lDsJomDv12Ct6AEmgzDiFzK4vK454CynAr4fhGKjuHD/1x36bA== X-Google-Smtp-Source: ABdhPJwoDIOGiMUYBlTMJTjG4ZCp2SuFDgToUgf1SpJZ1zbEDms4cs7TjZpSmYxLSByt82DJltOJF5mUUnU7YoolRO0= X-Received: by 2002:a19:c755:: with SMTP id x82mr10085944lff.149.1615068666746; Sat, 06 Mar 2021 14:11:06 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Martin Broerse Date: Sat, 6 Mar 2021 23:10:56 +0100 Message-ID: Subject: Re: exporting text to JSON hangs on %27 character To: user@couchdb.apache.org Content-Type: multipart/alternative; boundary="0000000000002b592a05bce57a22" --0000000000002b592a05bce57a22 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Bill, In JSON the single quote is no problem. See https://my.cloudstation.com/bloggr/post_2_FA2873BC-66FA-5689-9D26-117DF25A6= AC6 - Martin On Sat, 6 Mar 2021 at 21:45, Bill Stephenson wrote: > 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 thi= s doesn=E2=80=99t break on other > encoded text like =E2=80=9C%20=E2=80=9D. > > Anyone got any suggestions for how I might work around this? > > -- > > Kindest Regards, > > Bill Stephenson > > > > > > --0000000000002b592a05bce57a22--