Re: [R] Matching backslash in a table's column using R language

2020-08-25 Thread Peter Bishop
gt;> >> to: >> >> >> "[\x22\x27\x2c\x3f\x5c\x5c\x60]" >> >> >> This seems to be escaping the backslash in the R script rather than in >> the data - which confuses me. >> >> >> From:

Re: [R] Matching backslash in a table's column using R language

2020-08-25 Thread Jeff Newmiller
x22\x27\x2c\x3f\x5c\x5c\x60]" > > >This seems to be escaping the backslash in the R script rather than in >the data - which confuses me. > > >From: Bert Gunter >Sent: Wednesday, 26 August 2020 4:26 AM >To: Peter Bishop >Cc: r-help@r-

Re: [R] Matching backslash in a table's column using R language

2020-08-25 Thread Peter Bishop
5c\x60]" This seems to be escaping the backslash in the R script rather than in the data - which confuses me. From: Bert Gunter Sent: Wednesday, 26 August 2020 4:26 AM To: Peter Bishop Cc: r-help@r-project.org Subject: Re: [R] Matching backslash in a ta

Re: [R] Matching backslash in a table's column using R language

2020-08-25 Thread Bert Gunter
1. I am far from an expert on such matters 2. It is unclear to me what your input is -- I assume a file. The problem, as you indicate, is that R's parser sees "\B" as an incorrect escape character, so, for example: > cat("\B") Error: '\B' is an unrecognized escape in character string starting ""\B

[R] Matching backslash in a table's column using R language

2020-08-25 Thread Peter Bishop
In SQL, I'm using R as a way to filter data based on: - 20 characters in the range to - excluding , , , , , Given a SQL column containing the data: code A\BCDEFG and the T-SQL script: EXEC [sys].[sp_execute_external_script] @language=N'R',