How to remove numbers from a cell array

21 views (last 30 days)
I have a cell array which its elements contain both number and characters.
["LAN310"]
["SHA550"]
["SHA430"]
["SHB331"]
["EDU110"]
["IFE101"]
["BSM110"]
["BSM310"]
["BSM540"]
["LAN121"]
["LAN330"]
["IFE151"]
["IFE111"]
["BSM170"]
["BSM320"]
["BSM550"]
["LAN132"]
["SHB492"]
["EDU251"]
["IFC130"]
["IFC170"]
["CCT891"]
["IFC291"]
["IFC121"]
["BSM191"]
["SHB451"]
["TAM160"]
["EDU210"]
["IFC180"]
["IFC150"]
["IFC161"]
["IFC200"]
["IFC301"]
["EDU220"]
["EDU180"]
["IFC431"]
["IFC240"]
["IFC250"]
["IFC311"]
["IFC210"]
["IFC190"]
["TAM111"]
["EDU820"]
["IFC441"]
["IFC353"]
["IFC260"]
["IFC421"]
["IFC411"]
["BSM790"]
["SHB242"]
["EDU261"]
["EDU201"]
["IFC451"]
["IFC224"]
["IFE130"]
["IFC373"]
["IFC363"]
["IFC461"]
["IFC330"]
["BSM461"]
["IMA262"]
I want to remove the " and numbers from my cell and I want the characters to remain only so it becomes like this :
[LAN]
[SHA]
[SHA]
[SHB]
[EDU]
[IFE]
[BSM]
[BSM]
[BSM]
[LAN]
[LAN]
[IFE]
[IFE]
[BSM]
[BSM]
[BSM]
[LAN]
[SHB]
[EDU]
[IFC]
[IFC]
[CCT]
[IFC]
[IFC]
[BSM]
[SHB]
[TAM]
[EDU]
[IFC]
[IFC]
[IFC]
[IFC]
[IFC]
[EDU]
[EDU]
[IFC]
[IFC]
[IFC]
[IFC]
[IFC]
[IFC]
[TAM]
[EDU]
[IFC]
[IFC]
[IFC]
[IFC]
[IFC]
[BSM]
[SHB]
[EDU]
[EDU]
[IFC]
[IFC]
[IFE]
[IFC]
[IFC]
[IFC]
[IFC]
[BSM]
[IMA]
Can someone please guide me how to do this?
Thanks
  5 Comments
Codemaster
Codemaster on 9 Jun 2020
Thank you so much Stephen for clearing that out. Yes I am aware of the terms of use, that's why I was looking for an alternate to delete this thread entirely eventhough some time has passed by. Nevertheless it was very nice of you to spend your time on reminding me them! I wish you best of luck

Sign in to comment.

Accepted Answer

Stephen23
Stephen23 on 24 Jan 2018
Edited: Stephen23 on 24 Jan 2018
A trivial implementation using regexprep:
D = regexprep(C,'[\d"]','');
And tested:
>> C = {'["LAN310"]';'["SHA550"]';'["SHA430"]';'["SHB331"]';'["EDU110"]', ... };
>> D = regexprep(C,'[\d"]','');
>> D{:}
ans = [LAN]
ans = [SHA]
ans = [SHA]
ans = [SHB]
ans = [EDU]
... etc

More Answers (0)

Community Treasure Hunt

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

Start Hunting!