Try:
Select whole column
Edit -> find
enter in "search for" : [0-9]+,[0-9]+,
Leave "replace with" blank
Click "other options"
mark "regular expressions"
click "replace all"
The reg expression above expects at least 1 digit before the first comma and
between the commas.
If this is not the case (the value can also be ..Text), then replace the "+"
with "*" in above regular expression
Success,
Rob.
On 5 okt. 2015, at 08:54, Pat Brown wrote:
> I have over 2000 records in a sheet. At the beginning of each record there
> is a series of numerals. I want to do a Find & Replace to remove these
> numerical values but I cannot seem to find the right formula. The leading
> numerals are not of consistent length, example
> 1,1,Guide
> 1,24,Field
> 1,225,The Music
> The format is consistent in each case, just the length differs
> Any suggestions?
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted