Hi :) Is there not some way to identify how far along the letter is through one of the count functions? If so then a +1 should give the required value?
In the interests of "release early and release often" it might be faster for you to 'just' do a macro since you already have the skill-set for that. Regards from Tom :) >________________________________ > From: Steve Edmonds <[email protected]> >To: [email protected] >Sent: Tuesday, 9 October 2012, 0:05 >Subject: [libreoffice-users] regexp function > >Hi. >I have had a look, and before I go writing a macro I thought I would check >there is no easier solution. >I want to return the part of a string in a cell matched by a regular >expression. > >I have strings in cells that could be X12.4Y.2Z1.234 or any combination of any >letter followed by a number. I want to be able to return the number after a >specified letter, not hard in a regexp. >I have not been able to find an LO function to do this. > >TIA, steve > >-- For unsubscribe instructions e-mail to: [email protected] >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 > > > > -- For unsubscribe instructions e-mail to: [email protected] 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
