Re: Grep help for musicxml

2022-12-06 Thread 'Marcel Lamers' via BBEdit Talk
Thx JJ, that works great! On Monday, 5 December 2022 at 21:45:30 UTC+1 jj wrote: > Hi Marcel, > > You could try this. > > Find: > > > > (?s)())+)()\n((?:.(?!) > > Replace: > > > \n\n\2\n\n\n\1\3 > > HTH > > Jean Jourdain > On Monday, December 5, 2022 at 8:27:49 PM UTC+1 Marcel Lamers w

Re: Grep help for musicxml

2022-12-05 Thread jj
Hi Marcel, You could try this. Find: (?s)())+)()\n((?:.(?!) Replace: \n\n\2\n\n\n\1\3 HTH Jean Jourdain On Monday, December 5, 2022 at 8:27:49 PM UTC+1 Marcel Lamers wrote: > It gets much simpler if I add e.g. a ! before every first. > I can then search for > ()([^!]+)()([^!]+)()

Re: Grep help for musicxml

2022-12-05 Thread 'Marcel Lamers' via BBEdit Talk
It gets much simpler if I add e.g. a ! before every first. I can then search for ()([^!]+)()([^!]+)() On Monday, 5 December 2022 at 17:13:42 UTC+1 Marcel Lamers wrote: > Hi, > > I have a musicxml file that is not properly imported into my music > notation app and I have to change the syntax to

Grep help for musicxml

2022-12-05 Thread 'Marcel Lamers' via BBEdit Talk
Hi, I have a musicxml file that is not properly imported into my music notation app and I have to change the syntax to do a better import. I gave it a go with grep but can't seem to get the proper pattern to make the change. In short, I want to remove the dynamics tags plus content from a note

Re: Grep help - removing text within a tag

2022-10-10 Thread a k
Thanks so much! This did the trick. I've been familiarizing myself with multi-file search and am very excited to now have such a powerful tool to use for these repetitive tasks. Hoping to learn more about grep as well as Text Factory On Monday, October 10, 2022 at 4:46:33 PM UTC-5 fletc...@cumu

Re: Grep help - removing text within a tag

2022-10-10 Thread a k
Sorry for being unclear - I want to remove the text so output would be blank On Monday, October 10, 2022 at 4:45:42 PM UTC-5 Kaveh wrote: > Can you put the output you expect for this string? > > On Mon, 10 Oct 2022 at 22:25, a k wrote: > >> Hey all, >> >> I'm looking to use grep to remove text

Re: Grep help - removing text within a tag

2022-10-10 Thread Fletcher Sandbeck
The find pattern would be "" with "Grep" checked. You can use the Multi-File Search... dialog to run this against a folder containing your .txt files to see how many matches there are. When I'm doing multi-file work like this I'll usually start out doing a Find All in the multi-file dialog and

Re: Grep help - removing text within a tag

2022-10-10 Thread Kaveh
Can you put the output you expect for this string? On Mon, 10 Oct 2022 at 22:25, a k wrote: > Hey all, > > I'm looking to use grep to remove text contained within a tag (including > the tag itself). More specifically - I need to find and remove a bunch of > iframe tags from multiple .txt files.

Grep help - removing text within a tag

2022-10-10 Thread a k
Hey all, I'm looking to use grep to remove text contained within a tag (including the tag itself). More specifically - I need to find and remove a bunch of iframe tags from multiple .txt files. Here's an example tag: *https://website.com/1.0/ifr?zid=123456&cb=${CACHEBUSTER}&abc_imp=${AUC_ID}

Re: Need a little GREP help

2022-10-04 Thread Kaveh
Hi Michael Glad it worked. It's actually very easy once you get the knack. I have been meaning to do some video tutorials so thanks for the prompt. Feel free to remind me again. No problem if you want to email privately. Regards Kaveh On Tue, 4 Oct 2022 at 13:51, Michael Heth wrote: > > > > On

Re: Need a little GREP help

2022-10-04 Thread Michael Heth
> On Oct 4, 2022, at 5:37 AM, Kaveh wrote: > > Search: > (.+) > Replace: > \1 Thanks much, worked like a champ. I’ll have to try and wade through the docs on GREP again and see if it catches this time. Or, Or, The folks at BB could do a 5 minute YT video showing various examples of commo

Re: Need a little GREP help

2022-10-04 Thread eu...@gmx.de
Search Pattern: ^.*$ Replace Pattern: \0 Will do the job! > Am 04.10.2022 um 06:18 schrieb Michael Heth : > > Say Folks, > > Have been trying to get my head around GREP for many years and never quite > get it. > > I've asked for help before and folks were able to give me the cryptic code

Re: Need a little GREP help

2022-10-04 Thread Kaveh
Search: (.+) Replace: \1 On Tue, 4 Oct 2022 at 13:28, Michael Heth wrote: > Say Folks, > > Have been trying to get my head around GREP for many years and never quite > get it. > > I've asked for help before and folks were able to give me the cryptic code > to get my little task in the done colum

Need a little GREP help

2022-10-04 Thread Michael Heth
Say Folks, Have been trying to get my head around GREP for many years and never quite get it. I've asked for help before and folks were able to give me the cryptic code to get my little task in the done column. So, I have a list with over 450 lines like these 1995 DUCATI M600 Monster 1995 DUC

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

2022-01-17 Thread Howard
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 group. If you have a feature request or need

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

2022-01-16 Thread Tom Robinson
^[^a-z0-9]*(.).*$ ^ at beginning of line [^a-z0-9] look for anything which isn’t a-z 0-9 * 0 or more times (.) any single character (i.e. a-z 0-9), and ‘capture’ it for replacement pattern ★ any characters $ end of line Replace with \1 Cheers > On 2022-01-17, at 12:16, Howard wrote: > > Us

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

2022-01-16 Thread Howard
Using the *input data* below and using Grep, I need either the first digit or letter extracted from each row (just one per row), so the *output* looks like what is shown below. Though the output is displayed here in horizontal format, I need the actual output in vertical format without any comm

Re: A little grep help

2019-02-13 Thread @lbutlr
On 13 Feb 2019, at 00:43, Christopher Stone wrote: > That has to be a typo on your friend's part. There's no sense in adding a > capture for an optional literal 'm' – it adds nothing and can mangle words > ending in 'm'. Yep, none of the input I was testing had words ending in m, evidently. Th

Re: A little grep help

2019-02-12 Thread Christopher Stone
On 02/12/2019, at 06:38, @lbutlr mailto:krem...@kreme.com>> wrote: > I asked someone how to remove all spaces in an string more efficiently and he > responded with > > search: (m?)\s+ > replace: (nul) > > which sure does work. > > But WHY? On 02/12/2019, at 16:26, @lbutlr mailto:krem...@krem

Re: A little grep help

2019-02-12 Thread ThePorgie
Seems like an odd search string. The (m?) would be to capture a patten for an optional m before your space. If you're just wanting to get the spaces I don't know why you would include this when the \s would get them all with a replacement of null and selecting the replace all option. Including t

Re: A little grep help

2019-02-12 Thread Sam Hathaway
It's NOT doing the same thing is (?m). Apply your pattern to this sample: Yum yum I munch this text. I get: YuyuImunchthistext. On February 12, 2019 5:38:05 PM "@lbutlr" wrote: On 12 Feb 2019, at 15:29, Sam Hathaway wrote: How exactly are you applying this pattern? Is this in BBEdit’s find

Re: A little grep help

2019-02-12 Thread @lbutlr
On 12 Feb 2019, at 15:37, @lbutlr wrote: > replace all with (nun) Thanks for the helpful autocorrect! (nul) -- 'What can I do? I'm only human,' he said aloud. Someone said, Not all of you. —Pyramids -- This is the BBEdit Talk public discussion group. If you have a feature request or need te

Re: A little grep help

2019-02-12 Thread @lbutlr
On 12 Feb 2019, at 15:29, Sam Hathaway wrote: > How exactly are you applying this pattern? Is this in BBEdit’s find window? I > can’t replicate what you’re seeing. (For me it replaces one span of spaces at > a time, including any m that precedes it.) Never mind, in BBEdit I am of course, doing

Re: A little grep help

2019-02-12 Thread Sam Hathaway
How exactly are you applying this pattern? Is this in BBEdit’s find window? I can’t replicate what you’re seeing. (For me it replaces one span of spaces at a time, including any `m` that precedes it.) -sam On 12 Feb 2019, at 17:26, @lbutlr wrote: On 12 Feb 2019, at 06:53, Rich Siegel wrote:

Re: A little grep help

2019-02-12 Thread @lbutlr
On 12 Feb 2019, at 06:53, Rich Siegel wrote: > 'm guessing it was "(?m)\s+" Tha would make SLIGHTLY more sense, but it is definitely (m?)\s+ (I’ve checked it a dozen times) what I don’t get is that in the sample --- You received this message because you are su

Re: A little grep help

2019-02-12 Thread Néstor E. Aguilera
Notice that \s includes line feeds/carriage returns/form feeds, so perhaps it is not what you want. For just spaces and tabs you may try [^ \t]+ (user manual, p. 187). Nestor === > On 12 Feb 2019, at 10:42, Sam Hathaway wrote: > > This would seem t

Re: A little grep help

2019-02-12 Thread Rich Siegel
On 2/12/19 at 7:38 AM, krem...@kreme.com (@lbutlr) wrote: search: (m?)\s+ I'm guessing it was "(?m)\s+", and attached is a screenshot from the user manual. R. -- Rich Siegel Bare Bones Software, Inc. Someday

Re: A little grep help

2019-02-12 Thread Sam Hathaway
This would seem to remove any `m` character that is followed by one or more spaces, so I don’t think it _quite_ does what you asked for. Not sure why it would be faster either. -sam On 12 Feb 2019, at 7:38, @lbutlr wrote: I asked someone how to remove all spaces in an string more efficiently

A little grep help

2019-02-12 Thread @lbutlr
I asked someone how to remove all spaces in an string more efficiently and he responded with search: (m?)\s+ replace: (nul) which sure does work. But WHY? That is, I know what this does, but I don't understand the syntax -- Major Strasser has been shot. Round up the usual suspects. -- Thi

Re: GREP help: dig into the report of the cash register

2018-12-14 Thread m.osti
Hi Chris, thank you for the support ;) > I can write another script that will parse these into variables that can be inserted into your web page. This is over my skill Chris :( but for your information, I have to put other data in 3 consecutive web pages. I set up 2 macros with Keyboad Maestr

Re: GREP help: dig into the report of the cash register

2018-12-14 Thread m.osti
Hi, I tried this also and seems to me the result is the same as the previous one: perfect. I use the multi search function of bbedit: it scans all the folders containing the files (one per day) and in 4 seconds extracts all the data. awesome! Ah, there was only a receipt with an amount of 1000,

Re: GREP help: dig into the report of the cash register

2018-12-07 Thread ThePorgie
Ok, I think I've narrowed down the greedy over-run to only look between matching register numbers...So basically this should work regardless of varying number of item lines in your receipt. Search: t_fiscale (\d{4})(\d{2})(\d{2}) (\d+) (\d+)$(?s).*?TOTALE EURO +([0-9,]+).*?C\.F\. +([\w]+).*?N\.

Re: GREP help: dig into the report of the cash register

2018-12-07 Thread Christopher Stone
On 12/06/2018, at 13:44, Christopher Stone mailto:listmeis...@suddenlink.net>> wrote: > Here's an updated script that produces cleaner output. > From here I would probably turn the output into tab-delimited single lines. Hey Marco, The newest incarnation of the script (appended) produces output

Re: GREP help: dig into the report of the cash register

2018-12-07 Thread m.osti
Well ThePorgie, not sure to have understood your note but... now it's perfect. thank you Il giorno giovedì 6 dicembre 2018 19:33:55 UTC+1, ThePorgie ha scritto: > > Right you are. I didn't notice that when I last tested. Try this: > t_fiscale (\d{4})(\d{2})(\d{2}) (\d+) (\d+)$(?:.*\n){1,8}?TOTALE

Re: GREP help: dig into the report of the cash register

2018-12-06 Thread Christopher Stone
On 12/06/2018, at 11:30, m.osti mailto:mk0...@gmail.com>> wrote: > of course, this way the result is even cleaner and easier then to use Hey Marco, Here's an updated script that produces cleaner output. >From here I would probably turn the output into tab-delimited single lines. Because from

Re: GREP help: dig into the report of the cash register

2018-12-06 Thread ThePorgie
Right you are. I didn't notice that when I last tested. Try this: t_fiscale (\d{4})(\d{2})(\d{2}) (\d+) (\d+)$(?:.*\n){1,8}?TOTALE EURO +([0-9,]+)(?:.*\n){1,3}?C\.F\. +([\w]+) and replace: \5\n\3/\2/\1\n\6\n\7\n\n Note: I'm not sure how many items you can have listed on your receipt which cause

Re: GREP help: dig into the report of the cash register

2018-12-06 Thread m.osti
with this option there is an error: it get sales #4 (sale without CF = unnecessary) but it ignore sale #5 (with CF = necessary) of course, this way the result is even cleaner and easier then to use Il giorno mercoledì 5 dicembre 2018 18:25:36 UTC+1, ThePorgie ha scritto: > > > oops...you might ne

Re: GREP help: dig into the report of the cash register

2018-12-06 Thread m.osti
thank you for your concern. this GREP search is quite good: it get also the sale(s) without CF that are unnecessary but I can just ignore them at a fast glance. Il giorno mercoledì 5 dicembre 2018 18:20:28 UTC+1, ThePorgie ha scritto: > > I see you've got a script, but I like a puzzle... seems t

Re: GREP help: dig into the report of the cash register

2018-12-05 Thread ThePorgie
oops...you might need the replace info \5\n\1/\2/\3\n\6\n\7 On Wednesday, December 5, 2018 at 12:20:28 PM UTC-5, ThePorgie wrote: > > I see you've got a script, but I like a puzzle... seems to work like this. > > t_fiscale (\d{4})(\d{2})(\d{2}) (\d+) (\d+)$(?s).+?TOTALE EURO > +([0-9,]+).+?C\.F

Re: GREP help: dig into the report of the cash register

2018-12-05 Thread ThePorgie
I see you've got a script, but I like a puzzle... seems to work like this. t_fiscale (\d{4})(\d{2})(\d{2}) (\d+) (\d+)$(?s).+?TOTALE EURO +([0-9,]+).+?C\.F\. +([\w,]+) I used this with the extract option On Tuesday, December 4, 2018 at 8:14:34 AM UTC-5, m.osti wrote: > > Hello, every day when

Re: GREP help: dig into the report of the cash register

2018-12-05 Thread @lbutlr
On Tue Dec 04 2018 03:19:02 m.osti said: > > Now I copy them by hand and then I use a macro that I created in > KeyboardMaestro. Since there is a lot of data that I don't need, to speed up > I tried to extract only the necessary values through a GREP search, but I > failed, failed, failed

Re: GREP help: dig into the report of the cash register

2018-12-05 Thread m.osti
Il giorno martedì 4 dicembre 2018 21:41:43 UTC+1, David Wagner ha scritto: > > You state what you need is in red, but you do not show any date in red. > Please clarify... > Sorry Wags, it's cause I'm on google groups via web browser, and it allows HTML view. Below the picture. ty -m [image: S

Re: GREP help: dig into the report of the cash register

2018-12-05 Thread m.osti
Il giorno martedì 4 dicembre 2018 23:12:49 UTC+1, Christopher Stone ha scritto: > > On 12/04/2018, at 04:19, m.osti > wrote: > > Hello, every day when I have to close up my shop I get this report from > the cash register. I have the obligation to transmit some sales data > through a web page,

Re: GREP help: dig into the report of the cash register

2018-12-04 Thread Christopher Stone
On 12/04/2018, at 04:19, m.osti mailto:mk0...@gmail.com>> wrote: > Hello, every day when I have to close up my shop I get this report from the > cash register. I have the obligation to transmit some sales data through a > web page, and I have to insert one receipt at a time, sigh. > Only sales t

Re: GREP help: dig into the report of the cash register

2018-12-04 Thread David G Wagner
You state what you need is in red, but you do not show any date in red. Please clarify... thank you... Wags ;) WagsWorld Hebrews 4:15 Ph(primary) : 408-914-1341 Ph(secondary): 408-761-7391 On Dec 4, 2018, 05:14 -0800, m.osti , wrote: > Hello, every day when I have to close up my shop I get this

GREP help: dig into the report of the cash register

2018-12-04 Thread m.osti
Hello, every day when I have to close up my shop I get this report from the cash register. I have the obligation to transmit some sales data through a web page, and I have to insert one receipt at a time, sigh. Only sales that have the "C.F." are valid. In this case I need it in the order: the da

Re: Another Newbie GREP help request...

2018-05-19 Thread Christopher Stone
On 05/14/2018, at 22:15, Matthew London mailto:mlon...@gmail.com>> wrote: > PS.Grateful if someone can recommend a "GREP for non-programmers" written in > plain(er) English so I don't have to bother you very helpful people here. Hey Matthew, It takes a while to get good enough with regular expr

Re: Another Newbie GREP help request...

2018-05-18 Thread Matthew London
I think I see my problem. I was using "Process Lines Containing" which appears to extract the entire line, not matter what I search for. I used Search with the Extract function, and it works now! Thank you On Friday, May 18, 2018 at 1:47:33 AM UTC-7, Rick Gordon wrote: > > Change the .* in

Re: Another Newbie GREP help request...

2018-05-18 Thread Rick Gordon
te in an email entitled "Re: Another Newbie GREP help request...": I managed to figure out that the following would give me everything that had "from" followed by a capital letter, with a period followed by a space at the end: from [A-Z][a-zA-Z].*[\. ] But that also gives me

Re: Another Newbie GREP help request...

2018-05-17 Thread Matthew London
Thank you all for helping with such a simple request. However, I realize now that I didn't even word my request accurately. I understand that for BBEdit, a "line" is everything up until the next "line break" What I need is to search for SENTENCES, not LINES. I managed to figure out that the foll

Re: Another Newbie GREP help request...

2018-05-15 Thread Patrick Woolsey
Please try this: from [A-Z][a-zA-Z]+ with both the "Case sensitive" and "Grep" options enabled. In summary, "from " will match these literal characters, while the first _character class_ [A-Z] will match a single capital letter, and the second _character class_ [a-zA-Z] modified by + will ma

Re: Another Newbie GREP help request...

2018-05-15 Thread Kerri Hicks
A slight modification to Holger's answer above -- from [A-Z] works. Be sure to tick the "Case sensitive" box at the top of the dialog. [image: Screen Shot 2018-05-15 at 8.52.20 AM.png] --Kerri ​ On Tue, May 15, 2018 at 8:33 AM 'Holger Bartel' via BBEdit Talk < bbedit@googlegroups.com> wrote:

Re: Another Newbie GREP help request...

2018-05-15 Thread 'Holger Bartel' via BBEdit Talk
Hi, if I’m not mistaken you could use either from [A-Z]+ Or from [[:upper:]]+ Not on a computer right now, so this is untested, but hopefully is correct and helps ;) As for books, maybe one of the O’Reilly pocket references, but I’m not sure about the plainer english… Best, Holger > O

Another Newbie GREP help request...

2018-05-15 Thread Matthew London
Hi, Struggling to get my head around GREP... I need to use Process Lines Containing function in BBEdit to find all lines that contain the word "from" followed by a space, followed by any word that begins with a capital letter ie: He is from California but not He is from his mother PS.Grat

Re: grep help coordinates

2018-03-05 Thread Marek Stepanek
On 05.03.18 22:49, Steve Wilson wrote: > Need help trying to figure out how to do a grep search and replace in BBEdit > of a couple of coordinates into KML. > Unfortunately the order of the lat/long needs to be flipped. > Here is what it looks like: > > (32.839098817184, -97.303764761793) > > A

Re: grep help coordinates

2018-03-05 Thread Steve Wilson
Thanks! -- This is the BBEdit Talk public discussion group. If you have a feature request or would like to report a problem, please email "supp...@barebones.com" rather than posting to the group. Follow @bbedit on Twitter: --- You received this message because yo

Re: grep help coordinates

2018-03-05 Thread Fletcher Sandbeck
Something like this should do it. The unescaped parentheses define groups which are referred to by \1 and \2 in the replacement pattern. The escaped parentheses match the actual parentheses around the coordinates. Find: \(([0-9.-]+), ([0-9.-]+)\) Replace: \2,\1 Hope this helps, [fletcher] >

grep help coordinates

2018-03-05 Thread Steve Wilson
Need help trying to figure out how to do a grep search and replace in BBEdit of a couple of coordinates into KML. Unfortunately the order of the lat/long needs to be flipped. Here is what it looks like: (32.839098817184, -97.303764761793) And I need it to look like this: -97.303764761793,32.83

Re: Grep help

2017-10-12 Thread Lee Hinde
Thanks. The sed example turned out to be recursive. Page 189 on the current beta manual. On Wed, Oct 11, 2017 at 1:15 PM, @lbutlr wrote: > On Oct 6, 2017, at 4:05 PM, Lee Hinde wrote: > > > > > > I want to change all occurrences of a semi-colon within a url to > something else, like &. > > > >

Re: Grep help

2017-10-11 Thread @lbutlr
On Oct 6, 2017, at 4:05 PM, Lee Hinde wrote: > > > I want to change all occurrences of a semi-colon within a url to something > else, like &. > > I started with this search string: > > (href=\".*);(.*\"[ ,>]) > > and this replacement string: > > \1\&\2 One issue is that what you are replac

Re: Grep help

2017-10-09 Thread Lee Hinde
thanks. On Sun, Oct 8, 2017 at 9:24 AM, Roland Küffner wrote: > Although this is the BBEdit forum, I would recommend good 'ol "sed" from > the command line for this job. Something like this should work: > > sed '/new.html > > to do it on all files in the working directory: > find . -name '*.txt'

Re: Grep help

2017-10-08 Thread Roland Küffner
Although this is the BBEdit forum, I would recommend good 'ol "sed" from the command line for this job. Something like this should work: sed '/new.html to do it on all files in the working directory: find . -name '*.txt' -exec sed -i '' '/ wrote: > I've taken over a project and have many many ht

Grep help

2017-10-06 Thread Lee Hinde
I've taken over a project and have many many html files with strings like this: I want to change all occurrences of a semi-colon within a url to something else, like &. I started with this search string: (href=\".*);(.*\"[ ,>]) and this replacement string: \1\&\2 The problem is it is only r

Re: BBEdit Find and replace using grep help

2017-03-28 Thread Nikao
Thank you! On Tuesday, March 28, 2017 at 3:49:58 PM UTC-5, Tom Robinson wrote: > > That’s an easy one :] > > Search for this: > > ^.+$ > > ^ says look for '’ at beginning of line > . look for any character > + …one or more times > $ says look for '’ at end of line > > Cheers > > > > On

Re: BBEdit Find and replace using grep help

2017-03-28 Thread Tom Robinson
That’s an easy one :] Search for this: ^.+$ ^ says look for '’ at beginning of line . look for any character + …one or more times $ says look for '’ at end of line Cheers > On 2017-03-29, at 08:55, Nikao wrote: > > I am very new to Grep and was wondering if some one could help with this

BBEdit Find and replace using grep help

2017-03-28 Thread Nikao
I am very new to Grep and was wondering if some one could help with this. I want to replace the whole line of code that starts with: and ends with In the middle the content will not be the same in every document. That is why I want to be able to find a line that starts and ends like that an

Re: Grep help

2014-05-13 Thread jgill
Thank you Neil, that is just what I needed. -- This is the BBEdit Talk public discussion group. If you have a feature request or would like to report a problem, please email "supp...@barebones.com" rather than posting to the group. Follow @bbedit on Twitter: ---

Re: Grep help

2014-05-13 Thread Neil Faiman
On May 13, 2014, at 4:51 AM, jgill wrote: > > I want to search for all the text within a ... > which is across multiple lines. > > .*? doesn't work because . does not include line returns > > Is there a way in BBEdit to force . to include returns or is there some other > way of doing this

Grep help

2014-05-13 Thread jgill
Probably a very basic question but it has me stumped. I want to search for all the text within a ... which is across multiple lines. .*? doesn't work because . does not include line returns Is there a way in BBEdit to force . to include returns or is there some other way of doing this? T

Re: Grep help

2014-02-18 Thread Alan Truly
No offense meant Ronald. You obviously have a strong understanding of grep. There are just so many issues involved with CSV parsing that it is hard to catch all of the cases. > Note that Christopher's grep does not account for enclosed double quotes > at > all. It happens to work on your sa

Re: Grep help

2014-02-18 Thread Ronald J Kimball
On Mon, Feb 17, 2014 at 09:32:24PM -0800, Alan Truly wrote: > Another case to be wary of is if you have double quotes in your text. They > are encoded in the CSV as 2 double quotes. > > So for example: > > name story > George He said, "Hello!" > Jeff

Re: Grep help

2014-02-18 Thread Ted Burger
Ronald and others, Thanks for the solutions. I have folks uploading CSV files to a web server that I then have to parse the columns and rows on the server and populate a database. When I asked for help here I also went back to the client and they agreed to do a find/replace to remove the commas

Re: Grep help

2014-02-18 Thread Alan Truly
Another case to be wary of is if you have double quotes in your text. They are encoded in the CSV as 2 double quotes. So for example: name story George He said, "Hello!" JeffI agree with George Would be encoded as: "name","story" "George","He sa

Re: Grep help

2014-02-17 Thread Ronald J Kimball
On Mon, Feb 17, 2014 at 07:44:29PM -0500, Ted Burger wrote: > Folks, > > Thanks in advance, but I am struggling with putting together a grep search. > > I have Excel created .csv files that I have to parse. > Excel has a "feature" where it incodes commas in a field by enclosing that > field wit

Re: Grep help

2014-02-17 Thread Christopher Stone
On Feb 17, 2014, at 18:44, Ted Burger wrote: > I have Excel created .csv files that I have to parse. > > Excel has a "feature" where it incodes commas in a field by enclosing that > field with quotes. > > This means that you might have rows that look like: > a,b,",c",d,e

Grep help

2014-02-17 Thread Ted Burger
Folks, Thanks in advance, but I am struggling with putting together a grep search. I have Excel created .csv files that I have to parse. Excel has a "feature" where it incodes commas in a field by enclosing that field with quotes. This means that you might have rows that look like: a,b,

Re: Grep help?

2013-02-22 Thread Rod Buchanan
On Feb 21, 2013, at 9:22 PM, Oliver Taylor wrote: > On Feb 21, 2013, at 3:58 AM, Kendall Conrad wrote: > >> I had to switch the \n to \r before that would work. > > \n and \r are interchangeable in 10.5+ Sure, now that I finally got myself trained to type '\r'. :) -- Rod Buchanan -- -- Yo

Re: Grep help?

2013-02-21 Thread Oliver Taylor
On Feb 21, 2013, at 3:58 AM, Kendall Conrad wrote: > I had to switch the \n to \r before that would work. \n and \r are interchangeable in 10.5+ -- -- You received this message because you are subscribed to the "BBEdit Talk" discussion group on Google Groups. To post to this group, send emai

Re: Grep help?

2013-02-21 Thread Sumtingwong
Here is what I came up with, also going to need a couple of passes. On the first run: Find: \.jpg\n(.*?\_bk\_?.+) Replace with: \.jpg,\1 On the second run: Find: \.jpg\n(.*?\_bk\_.+) Replace with the same as the first one: \.jpg,\1 Hope this works! Cheers, Spencer -- -- You recei

Re: Grep help?

2013-02-21 Thread Kendall Conrad
I had to switch the \n to \r before that would work. Nice approach to it. -Kendall On Thursday, February 21, 2013 12:49:46 AM UTC-5, Oliver Taylor wrote: > > On Feb 20, 2013, at 5:47 PM, Lorin Rivers > > wrote: > > Oh Mighty Ones, > > I have a big list that looks something like this: > speedo_

Re: Grep help?

2013-02-20 Thread Oliver Taylor
On Feb 20, 2013, at 5:47 PM, Lorin Rivers wrote: > Oh Mighty Ones, > > I have a big list that looks something like this: > speedo_705494_001.jpg > speedo_7051210_418.jpg > speedo_7051210_418_bk.jpg > speedo_7051200_041.jpg > speedo_7051200_041_bk.jpg > speedo_7051200_041_bk_a.jpg > speedo_705091

Re: Grep help?

2013-02-20 Thread Kendall Conrad
I couldn't see a way to get a 100% solution with just one grep run, but this works for items that have two, but not when there's three. If you run the same regex replace all multiple times it will accommodate more than two. Find: ((\w+_\d+_\d+).*\.jpg)(\r(\2(.*\.jpg))) Replace with: \1,\4 -Ken

Grep help?

2013-02-20 Thread Lorin Rivers
Oh Mighty Ones, I have a big list that looks something like this: speedo_705494_001.jpg speedo_7051210_418.jpg speedo_7051210_418_bk.jpg speedo_7051200_041.jpg speedo_7051200_041_bk.jpg speedo_7051200_041_bk_a.jpg speedo_7050911_173.jpg speedo_7050911_173_bk.jpg speedo_7050804_001.jpg speedo_70508

Re: grep help

2012-08-07 Thread Steven
Thanks. I sort of knew it was something ridiculous that was causing the problem. Now I shall hang my head in shame, I kiss your feet in gratitude and I am going to get all those records updated. I was seriously thinking of doing it the hard way. Data base migrations from Oracle or MySQL to

Re: grep help

2012-08-07 Thread mmje
You have a missing space after the first comma: >>, '\d\d\d\d-\d\d-\d\d \d\d:\d\d:\d\d',<< instead of ,'\d\d\d\d-\d\d-\d\d \d\d:\d\d:\d\d',< Le 7 août 2012 à 06:43, Steven a écrit : > A sample line is INSERT INTO books (title, topic_id, description, > date_aquired,

Re: grep help

2012-08-07 Thread Steven
A sample line is INSERT INTO books (title, topic_id, description, date_aquired, book_id, pages, w_index, w_bibliography, pub_date, subtitle, w_illustration, w_maps) VALUES('Humans', 14, 'Then end of the world, maybe, maybe not', '2009-01-01 10:52:39', 1, NULL, 0, 0, NULL, NULL, 0, 0); and I wan

Re: grep help

2012-08-06 Thread Bruce Van Allen
On 8/4/12 at 9:20 PM, katesglad...@gmail.com (Steven) wrote: I am trying to remove a date string from an SQL file. From an SQL database file? Are you searching for text directly in that type of file? Which SQL database management system are you using? ?? - Bruce _bruce__van_allen__sa

Re: grep help

2012-08-06 Thread John Delacour
At 21:20 -0700 4/8/12, Steven wrote: I am trying to remove a date string from an SQL file. I have ,'\d\d\d\d\-\d\d\-\d\d \d\d:\d\d:\d\d', as the string I wish to replace with , It does not like that. I assume I have to \- because - is a character grep uses The search pattern on the nex

Re: grep help

2012-08-06 Thread Maarten Sneep
Hi, On 6 aug. 2012, at 15:45, Steven wrote: > As maarten guessed, I am trying to remove 560 instances of a date from an SQL > file. So I am looking for a way to grab everything from one comma to the > other and including the quotes, all the numbers and dashes and dots and > replace it with

Re: grep help

2012-08-06 Thread Steven
As maarten guessed, I am trying to remove 560 instances of a date from an SQL file. So I am looking for a way to grab everything from one comma to the other and including the quotes, all the numbers and dashes and dots and replace it with one single comma, Maarten's method didn't work either

Re: grep help

2012-08-06 Thread Terje Bless
On Sun, Aug 5, 2012 at 6:20 AM, Steven wrote: > I am trying to remove a date string from an SQL file. > > I have ,'\d\d\d\d\-\d\d\-\d\d \d\d:\d\d:\d\d', as the string I wish to > replace with , > > It does not like that. What does "does not like that" mean? That it finds no matches? Or do you se

Re: grep help

2012-08-05 Thread Maarten Sneep
On 5 aug. 2012, at 06:20, Steven wrote: > I am trying to remove a date string from an SQL file. > > I have ,'\d\d\d\d\-\d\d\-\d\d \d\d:\d\d:\d\d', as the string I wish to > replace with , > > It does not like that. > > I assume I have to \- because - is a character grep uses Your questi

grep help

2012-08-05 Thread Steven
I am trying to remove a date string from an SQL file. I have ,'\d\d\d\d\-\d\d\-\d\d \d\d:\d\d:\d\d', as the string I wish to replace with , It does not like that. I assume I have to \- because - is a character grep uses Thanks -- -- You received this message because you are subscribed

Re: GREP help

2012-04-16 Thread David
Ron, Perfect! Thanks (again)! Best regards, David -- You received this message because you are subscribed to the "BBEdit Talk" discussion group on Google Groups. To post to this group, send email to bbedit@googlegroups.com To unsubscribe from this group, send email to bbedit+unsubscr...@googl

Re: GREP help

2012-04-16 Thread Ronald J Kimball
On Mon, Apr 16, 2012 at 10:54:55AM -0700, David wrote: > I need some Grep help. > > I need to remove this type of entry from a large file. > > "No Fly List: > 101508 > 100698 > > Other options" > > > ignore the quotation marks, I added

GREP help

2012-04-16 Thread David
I need some Grep help. I need to remove this type of entry from a large file. "No Fly List: 101508 100698 Other options" ignore the quotation marks, I added them to illustrate the start and end of the string. Each six digit employee number begins with 1. Each line e

Re: grep help

2012-03-26 Thread Rick Gordon
I sure did switch up my non-greedy modifier. Thanks for noticing. -- On 3/26/12 at 4:06 PM -0500, Christopher Stone wrote in a message entitled "Re: grep help": >On Mar 26, 2012, at 15:39, Rick Gordon w

Re: grep help

2012-03-26 Thread Ronald J Kimball
On Mon, Mar 26, 2012 at 04:06:40PM -0500, Christopher Stone wrote: > On Mar 26, 2012, at 15:39, Rick Gordon wrote: > > FIND: > > (.?*) > __ > > Hey Rick, > > Didn't you switch up your non-greedy modifier? > > Find: > > (.*?) >

Re: grep help

2012-03-26 Thread Christopher Stone
On Mar 26, 2012, at 15:39, Rick Gordon wrote: > FIND: > (.?*) __ Hey Rick, Didn't you switch up your non-greedy modifier? Find: (.*?) Replace: \1 -- Best Regards, Chris -- You received this message because you are subscrib

RE: grep help

2012-03-26 Thread Rick Gordon
FIND: (.?*) CHANGE TO: \1 -- On 3/26/12 at 12:23 PM -0700, JT wrote in a message entitled "grep help": > I'm trying to replace the in a long table with using >grep > >6-Grain Flakes .. to.. 6- >Grain Flakes > >i tried * .. to.. * to

  1   2   >