Ask Your Question
0

Find text after a specific character in Calc

asked 2019-02-16 23:45:58 +0200

Dave Quail gravatar image

updated 2019-02-16 23:48:23 +0200

Hi there, I am new here, and also new to Libreoffice. I have used Excel for many years, but have moved to Libreoffice recently. I hope to find an answer to a problem i have extracting text in a cell, following a specific character. "@" This character is part of a list of email addresses i am working on, so will not always be in a static position. The Excel equivalent formula is: =MID(D3,SEARCH(@,D3)+1,255), where D3 is the cell reference containing the text. This formula returns an error in Calc, despite me replacing commas with semicolons and placing @ within quotes "@". e.g. johnnysmith@acmeremovals.com, or annedaly@acmeremovals.com. "@" is not at a fixed position in the text string. I would like to extract acmeremovals.com only. Thank you.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-02-17 00:17:50 +0200

robleyd gravatar image

This works for me in 6.0.7.3

=MID(D3,SEARCH("@",D3)+1,255)

Sample file attached; C:\fakepath\midtest.ods

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.

edit flag offensive delete link more

Comments

Thanks robleyd, the semi-colons and quotation marks were the difference. We live and learn!

Dave Quail gravatar imageDave Quail ( 2019-02-17 09:49:19 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-02-16 23:45:58 +0200

Seen: 53 times

Last updated: Feb 17