How can I change a quotation mark in a text string readed from an excel sheet ?

1 view (last 30 days)

Show older comments

Christophe on 16 Jun 2014

0
Link

Direct link to this question

https://se.mathworks.com/matlabcentral/answers/134681-how-can-i-change-a-quotation-mark-in-a-text-string-readed-from-an-excel-sheet

Commented: Christophe on 17 Jun 2014

Accepted Answer: Mischa Kim

In an excel sheet, I have this string : Pression d'injection I want to change the quotation mark ' with a double quotation mark "

0 Comments
Show -2 older commentsHide -2 older comments

Sign in to comment.

Sign in to answer this question.

Accepted Answer

Mischa Kim on 16 Jun 2014

0
Link

Direct link to this answer

https://se.mathworks.com/matlabcentral/answers/134681-how-can-i-change-a-quotation-mark-in-a-text-string-readed-from-an-excel-sheet#answer_141165

Open in MATLAB Online

Christophe, do you mean:

 old_str = 'Pression d''injection'
 old_str =
    Pression d'injection
 new_str = strrep(old_str,'''','"') 
 new_str =
    Pression d"injection

1 Comment
Show -1 older commentsHide -1 older comments

Christophe on 17 Jun 2014

Why I don't think to it before !!! Thanks

Sign in to comment.

More Answers (1)

SRI on 16 Jun 2014

0
Link

Direct link to this answer

https://se.mathworks.com/matlabcentral/answers/134681-how-can-i-change-a-quotation-mark-in-a-text-string-readed-from-an-excel-sheet#answer_141166

Hi could you elaborate the task which you want to be done

0 Comments
Show -2 older commentsHide -2 older comments

Sign in to comment.

Sign in to answer this question.

Categories

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

Find more on Spreadsheets in Help Center and File Exchange

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!