Re: Need help changing one column of data into two

Thanks Bruce, Rod, and Darren for your help. -- Howard On Wednesday, 1 June 2022 at 3:46:06 pm UTC-4 Darren Duncan wrote: > Howard, > > Sorry, I had a typo, I forgot to include capturing parenthesis in my > example. > > I didn't actually take the time to execute what I

Re: Need help changing one column of data into two

Darren, When I run your solution in BBEdit, in the output the numbers that should be in Column 2 are not appearing. Howard On Tuesday, 31 May 2022 at 5:24:37 pm UTC-4 Darren Duncan wrote: > Howard, > > This should be easy to accomplish with search and replace regular >

Re: Need help changing one column of data into two

Correction to *Sample Output*. It should look like this: *Sample Output* *Column 1 Column 2* 9/4/57 9/3/57 9/2/572 On Tuesday, 31 May 2022 at 9:54:59 am UTC-4 Howard wrote: > I have a column in Excel with data like this: > > 9/4/57 > 9/3/57 > 1957-09-02 (2) &

Re: Detect double-digit numbers in string

Yes, it worked. Thank you for your help. On Friday, 13 May 2022 at 1:58:40 pm UTC-4 Kaveh wrote: > Search: (.+?)\((\d\d)\), ([A-Z]) > Replace: \2 \3 > > Press "Extract" > > [image: Screenshot 2022-05-13 at 18.55.59.png] > > > On Fri, 13 May 2022 at 17:41, Ho

Need help changing one column of data into two

How can I do this in BBEdit? Howard -- This is the BBEdit Talk public discussion group. If you have a feature request or need technical support, please email "supp...@barebones.com" rather than posting here. Follow @bbedit on Twitter: <https://twitter.com/bbedit> --- You recei

Detect double-digit numbers in string

Using GREP, how can I detect those strings that contain double-digit numbers? *Sample input* CG(10), W CG(11), W CG(6), W CG(17), L SHO(5), W I have a column with text values such as those shown above. I need to identify those rows that contain a double-digit value between the

Re: Converting decimal value of some numbers using Grep

Patrick, Thanks for your help, Howard On Wednesday, 16 March 2022 at 5:24:21 pm UTC-4 Patrick Woolsey wrote: > On 3/16/22 at 3:10 PM, leadwi...@gmail.com (Howard) wrote: > > >In *Find: ^(\d+?)\.1 *what is the purpose of the question mark? > >I know what *\d+* does. > &g

Re: Converting decimal value of some numbers using Grep

Patrick, In *Find: ^(\d+?)\.1 *what is the purpose of the question mark? I know what *\d+* does. Howard On Wednesday, 16 March 2022 at 1:41:06 pm UTC-4 Patrick Woolsey wrote: > Though you can do this, you'll need to perform two search & replace > passes: one for each value pair

Converting decimal value of some numbers using Grep

` I want to change its ending to `.67`, but keep its whole number the same, so 1.2 would become 1.67. As the column can have hundreds of rows, using Grep is there an easy way to convert the decimal portion of a number that ends with either .1 or .2 while retaining the whole number part? Howard

Re: Using GREP, need help to extract names and numbers from column

Wags, I appreciate what you did. Your solution is helpful. Howard On Thursday, 10 February 2022 at 4:44:59 pm UTC-5 Howard wrote: > Jean, > > Your solution does what I need. > > Thanks, > Howard > > On Thursday, 10 February 2022 at 8:31:38 am UTC-5 wagsw...@gmail.c

Re: Using GREP, need help to extract names and numbers from column

Jean, Your solution does what I need. Thanks, Howard On Thursday, 10 February 2022 at 8:31:38 am UTC-5 wagsw...@gmail.com wrote: > I took the data and tried this: > > ([a-z]\.)([a-z]+)\s+\(([^\)]+)\)(\s*(and){0,1}\s*) > > Replace as > > \1\2\t\3\n > > You stated

Using GREP, need help to extract names and numbers from column

*, but believe that I can figure out how to do that from the answer to #1 above. Thanks, Howard -- This is the BBEdit Talk public discussion group. If you have a feature request or need technical support, please email "supp...@barebones.com" rather than posting here. Follow @bbedit

Need GREP to reorder a list of names

by a space and the comma removed so that the names appear this way: Vladimir Guerrero Jr. Salvador Perez Manny Machado Bo Bichette Paul Goldschmidt Rafael Devers Aaron Judge Freddie Freeman Thanks in advance for any help you can provide, Howard -- This is the BBEdit Talk public discussion

Re: Need Grep help to get first digit (or letter) in each row

Thanks Tom and Christopher. Howard On Sunday, 16 January 2022 at 8:38:24 pm UTC-5 Christopher Waterman wrote: > Hello Howard, > > Find: ^[^0-9A-Z]?([0-9A-Z]).* > > Replace: \1 > > > > — Chris(topher)? > > -- This is the BBEdit Talk public discussion gro

Need Grep help to get first digit (or letter) in each row

commas. Howard *Output* 9, 3, D, 6, 8, 5, 3, 9, 5, 2, 7, 4, 3, D, 8, 7 *Input data:* *9/HD *3D/5 *D1/H97 *69/8HD *87/HD 57983/H *3 *97D/8H *5D/H *2/D3H *7H/8 *4/H *3/D5 *D7/9 *84/H 7DH/9 -- This is the BBEdit Talk public discussion group. If you have a feature request or need technical support

Re: Need way of counting number of occurrences of names

Bruce, That fixed it. Thank you very much for spotting the problem, Howard On Saturday, 11 September 2021 at 1:03:12 pm UTC-4 Bruce Van Allen wrote: > Howard wrote on 2021-09-11 9:29 AM: > > When I run Kerri's method, I am getting these results, which differ from > > hers: >

Re: Need way of counting number of occurrences of names

When I run Kerri's method, I am getting these results, which differ from hers: Peter Fros t -- 25:3 4 -- yes Elle Clau s -- 30:0 5 -- Third line Elle Clau s -- 30:2 5 -- Third lin e -- Fourth line Cary Clar k -- 31:2 1 -- done Anyone know why I am getting the extra spaces, e.g., the one before

Need way of counting number of occurrences of names

-- Third line Elle Claus -- 30:25 -- Third line -- Fourth line Cary Clark -- 31:21 -- done Then, I would like a count of the observations by name: *SAMPLE COUNTED DATA* Peter Frost 1 Elle Claus 2 Cary Clark 1 I am familiar with using Unix command solutions. Thanks, Howard

Re: Need explanation of REGEX code

Thanks Jean for the comprehensive explanation. It is very helpful. On Saturday, 31 July 2021 at 1:14:01 pm UTC-4 jj wrote: > Hi Howard, > > Here is a commented version of your regular expression. > > (?x)(?# Allow whitespa

Re: Need explanation of REGEX code

Thanks. I just tried it for the first time. It is good to know about. Howard On Saturday, 31 July 2021 at 12:52:48 pm UTC-4 TJ Luoma wrote: > > Try pasting it into https://regexr.com > > That's what I usually use to translate regex into English :-) > > > > On Sat, Jul 31,

Need explanation of REGEX code

Can someone explain how the REGEX code below works? *(.)(?![^(]*\))* I know it looks for digits, including two-digit numbers in parentheses, and extracts them and inserts a space after each one, but I do not know how the code starting with *(?* works. Here is sample data for it: 01000

Re: Need to extract all digits from string

Regmatches is a term in R programming. Sorry if it caused confusion. On Tuesday, 27 July 2021 at 5:52:38 pm UTC-4 listmei...@gmail.com wrote: > Hey Howard, > > What exactly do you mean by “regmatches”? > > Find: > > (\d|\[\d+\]) > > Replace: > > \1

Need to extract all digits from string

s not have to be vertical. I am just presenting it that way for readability. 1 2 11 4 5 6 7 10 0 How can I do this using GREP and, if viable, 'regmatches'? Howard -- This is the BBEdit Talk public discussion group. If you have a feature request or need technical support, please e

Re: Extract number within parentheses using GREP

, is there a way to modify the Grep expression so that the results appear with the final two numbers on the same line, as shown below, with a space separating them? 10 16 10 11 Howard On Wednesday, 2 June 2021 at 5:37:42 am UTC-4 listmei...@gmail.com wrote: > On 06/01/2021, at 18:59, Howard wr

Re: Extract number within parentheses using GREP

that into the Pattern Playground and work with that a bit. On Tuesday, 1 June 2021 at 4:59:15 pm UTC-4 listmei...@gmail.com wrote: > On 06/01/2021, at 08:11, Howard wrote: > > I have a set of numbers. Within some of them is at least one number within > parentheses. I need to find all the line

Extract number within parentheses using GREP

I have a set of numbers. Within some of them is at least one number within parentheses. I need to find all the lines containing numbers within parentheses and extract those numbers. I also need to know which line they are extracted from. How can I do that? Howard *Examples* 1001405001 (10

Re: Need help accessing multiple files' content at the same time

" mode > rather than "Icon" or "Columns".) > > > Regards > > Patrick Woolsey > == > Bare Bones Software, Inc. <https://www.barebones.com/> > > > > > On 5/6/21 at 12:06 PM, leadwi...@gmail.com (Howard) wrote: > > >It curren

Re: Need help accessing multiple files' content at the same time

It currently has 22 items, 20 of which are split between two folders. On Thursday, 6 May 2021 at 11:43:24 am UTC-4 Patrick Woolsey wrote: > On 5/6/21 at 11:06 AM, leadwi...@gmail.com (Howard) wrote: > > >Patrick, your way of catenating individual files works well. > >

Re: Need help accessing multiple files' content at the same time

Patrick, your way of catenating individual files works well. I have a folder that contains both folders whose contents I would like to include in the catenation as well as separate individual files. Is there a way to do that in BBEdit? Howard On Sunday, 2 May 2021 at 11:36:26 am UTC-4 Howard

Re: Need help accessing multiple files' content at the same time

'Run Unix Filter' > action. > > Per item 1. you can catenate any selectable set of files into an existing > document via the Edit -> Insert -> File Contents... command > > > > Regards, > > Patrick Woolsey > == > Bare Bones Software, Inc. <https://www.bareb

Need help accessing multiple files' content at the same time

, access all the files in their folder at the same time? If either can be done, I would appreciate directions on doing it. Thanks, Howard -- This is the BBEdit Talk public discussion group. If you have a feature request or need technical support, please email "supp...@barebones.com" r

Need to remove blank lines

I have several hundred lines of data. Each observation occupies two lines; however, in a number of places (not all) a blank line exists between observations. For example, between the first data element, Max Scherzer, and the second one, Justin Verlander, is a blank line. (A sample is below.)

Re: Removing part of a string

Thanks jem, your first solution is what I needed. On Friday, 13 November 2020 at 1:53:33 pm UTC-5 Tim A wrote: > Ah! Hiding in plain sight :>) > Thanks. > > On Friday, November 13, 2020 at 9:37:51 AM UTC-8 Jan Erik Moström wrote: > >> On 13 Nov 2020, at 17:07, Tim A wrote: >> >> > Curio. Both

Removing part of a string

, so for the above line the output would be this: *1956,ML,Don Newcombe,BRO,4.5,27,7,0,3.06,268.0,139* How can I do that? Thanks, Howard -- This is the BBEdit Talk public discussion group. If you have a feature request or need technical support, please email "supp...@barebones.com" r

Re: Counting occurrences of names

are ordered by the number of times they appear, and if two or more names have the same number of occurrences, they are displayed in alphabetical order. Howard On Wednesday, 7 October 2020 at 11:12:30 pm UTC-4 Rod Buchanan wrote: > > -d’ ’ tells cut to use the space character as the column

Re: Counting occurrences of names

Rod, What does the line below do? cut -d' ' -f3-4 Howard On Wednesday, 7 October 2020 at 10:11:31 am UTC-4 Rod Buchanan wrote: > > Click Text -> Run Unix Command… , then run this: > > cut -d' ' -f3-4 | sort | uniq -c > > When I copy/paste your data I get these results:

Searching all the files in a folder

I need to do a multi-file search using Grep of all the files in a folder. I looked in BBEdit Help and could not find how to do that. Thanks, Howard -- This is the BBEdit Talk public discussion group. If you have a feature request or need technical support, please email "supp...@barebone

Re: Counting occurrences of names

fletcher, Thanks for the quick response. I used Pattern: ^.*From (.*?) :.*$ Replace: \1 to create a file, then saved it as a text file, and imported that into R where I use the table function to get the output I needed. Howard On Tuesday, 6 October 2020 at 2:42:38 pm UTC-4 fletc

Re: Counting occurrences of names

Harvey, What you suggested sounds great; however, I have no idea how to write or run a Node JS script. Howard On Tuesday, 6 October 2020 at 2:46:38 pm UTC-4 Harvey Pikelberger wrote: > You would probably be better of trying to tackle this with a spreadsheet > and a couple of calc

Re: Counting occurrences of names

jajls, I just tried your solution. It is very easy to use. Thanks, Howard On Tuesday, 6 October 2020 at 3:44:13 pm UTC-4 jajls wrote: > On 2020 Oct 6, at 14:42, Fletcher Sandbeck wrote: > > > I'd do this in two steps. > > > Simplifying on Fletcher's solution, and stayi

Re: Counting occurrences of names

-c to > replace each duplicated line with a count of how many duplicates there > were, and then pipes it back to a new file in BBEdit which you can save > wherever you want. > > [fletcher] > > > > On Oct 6, 2020, at 11:23 AM, Howard wrote: > > > > I have the followi

Re: Counting occurrences of names

Hi Craig, Thanks for the solution. I plan to try it. Howard On Tuesday, 6 October 2020 at 3:06:28 pm UTC-4 Craig W Johnson wrote: > There may be a better way, but what I would do is open up a search window, > enter your target name in the find field, enter “\1\r” in the replace &

Re: Counting occurrences of names

Bruce Van Allen, Thanks for the PERL solution. I'm new to PERL, but plan to try your solution. It looks quite interesting. Howard On Tuesday, 6 October 2020 at 3:45:51 pm UTC-4 Bruce Van Allen wrote: > Hi Howard, > > Try a Text Filter. > > Here's one in Perl. > >

Counting occurrences of names

I have the following data (shown below). I want to count how many times each of the four names appear (Harvey Haney, Apple Jones, Banana Herb, Sam Blue). Can this be done in BBEdit? If not, I would appreciate suggestions on how it can be done. 10:45:57 From Harvey Haney : Good morning. How is

Removing text from parenthesis on

*Here is an input sample:* Arizona (5) Minnesota (4) Cleveland (2) San Diego (4) Using Grep, I want to remove all the text in each item from the left parenthesis on. How can I do that? -- This is the BBEdit Talk public discussion group. If you have a feature request or need technical

Capture group question

When using the Pattern Playground, in the search pattern's capture group #1 (see below), why is `847-` appearing rather than `717-`? Search pattern: (\d{3}[.-]?){2} Source text: 717-847-8015 Capture Groups: #0: 717-847- #1: 847- -- This is the BBEdit Talk public discussion group. If you have

Saving a search pattern in Pattern Playground

How can I save a search pattern in Pattern Playground? -- This is the BBEdit Talk public discussion group. If you have a feature request or need technical support, please email "supp...@barebones.com" rather than posting here. Follow @bbedit on Twitter: --- You

Re: Cannot replace source text using GREP

Thanks Massimo. On Jan 3, 2020, 10:42 AM -0500, bbedit@googlegroups.com, wrote: > > (\d)(\n) -- This is the BBEdit Talk public discussion group. If you have a feature request or need technical support, please email "supp...@barebones.com" rather than posting to the group. Follow @bbedit on

Re: Cannot replace source text using GREP

Hi Marek. When I ran your expression in BBEdit I got this result: 5 Howard On Jan 3, 2020, 9:40 AM -0500, bbedit@googlegroups.com, wrote: > > ^\d\n -- This is the BBEdit Talk public discussion group. If you have a feature request or need technical support, please email

Re: Use GREP to select all characters up to a character

Massimo, Thanks for the response. When I used ^(.*)(\\) it also selected the backslash. Before: Max Stassi\stassma01 After: Max Stassi\ Howard On Dec 19, 2019, 4:03 PM -0500, bbedit@googlegroups.com, wrote: > > ^(.*)(\\) -- This is the BBEdit Talk public discussion group. If yo

Re: GREP question

ch starts. The rest of the > pattern tells it how far to extend the match, through the next "b". > > After the first match if you do Find Again you'll get the next match starting > from the end of the current selection. > > [fletcher] > > > > On Dec 19, 2

Use GREP to select all characters up to a character

This is the opposite question to one I asked previously. Given rows of data with the format below, *Jose Rondon\rondojo02* how can I configure GREP to select all the characters up to but not including the backslash? Howard -- This is the BBEdit Talk public discussion group. If you have

Re: GREP question

Sam, Why does the pattern .*?b only match aaab and not aab? Isn’t aab the shortest string possible? Howard On Dec 19, 2019, 1:17 PM -0500, bbedit@googlegroups.com, wrote: > > The pattern .*b will match aaabaab, while the pattern .*?b will match aaab. -- This is the BBEdit Talk

GREP question

that the two backslashes seek the backslashes in my text, that the "." seeks "any character except a ‘hard’ line break" after the backslash, and that the "$" continues the search to the line's end. But what does the question mark do? Howard -- This is the BBEdi