How to RemoVe all text between brackets
Hi,
I have a database that I transferred to csv file, for some reason I have text between brackets that I don't need
like {{Attention|date=2014-08-10}} and [[Category:Guitar]]
all these types of text I want to remove , csv file contains 9K cells
so , any function or formula that can help me to remove these types of text?
Thanks
Last edited by drhema; 11-13-2014 at 11:28 AM.
add selection for whatever else you wanted to get rid of
Please Login or Register to view this content.
thanks , that save me tons of timeOriginally Posted by AlanY
add selection for whatever else you wanted to get rid of
Please Login or Register to view this content.
Just do a search and replace
Find {*} Replace with: nothing (leave field blank)
repeat with[*]
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
you're welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks