top of page

Find~your~tilde~separator


Like a lot of people I habitually use a tilde ~ separator to parse out data in spreadsheets. Today after collecting a large data set of text in Power Grep that was exported to a .csv file, I realized that I needed to remove the tilde separators the grep utility had entered in the text, because they not only were being used as field separators, they were also included as misreads in bad OCR. If you've tried doing this, you will have noticed that Excel won't find a tilde. It's as though the tilde is invisible. See Figure 1 below.

Excel uses a tilde as marker to search for other characters which can serve as a signifier in a search. For example if you'd like to search and remove all occurences where the letters "Lo" begin a word, you would just need to search for Lo* , and replace with nothing, and "Loan", "Lollipop", "Locust", and "Lopez" would all be deleted. If you need to search for and remove all of the asterisks on your worksheet you need to find and replace, ~* with nothing. To take out the tilde just search for ~~ and replace it with nothing.


 
 

Sean O'Shea has more than 20 years of experience in the litigation support field with major law firms in New York and San Francisco.   He is an ACEDS Certified eDiscovery Specialist and a Relativity Certified Administrator.

The views expressed in this blog are those of the owner and do not reflect the views or opinions of the owner’s employer.

If you have a question or comment about this blog, please make a submission using the form to the right. 

Your details were sent successfully!

© 2015 by Sean O'Shea . Proudly created with Wix.com

bottom of page