Ask Your Question

Can't Filter Tab Delimited CSV Percentages

asked 2016-08-23 00:47:00 +0200

I need to be able to use a standard filter to show me all rows in a CSV that are above a certain percentage. Percents are listed in the file as: 99.95% 100.0% 99.97% 0.02% etc. I cannot seem to make Calc understand that those are numbers that I need to filter. I tried removing the percent signs, reformatting as numbers, re-saving the file in an open doc format, filtering on 90.0, or .9, tried to change the type in the import wizard when I open the file, making sure the strings do not start with a ', and more with no luck. Calc will not understand that the 99.95 or the 99.95% I have in my CSVs are numbers. How can I filter these rows?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-08-23 01:09:44 +0200

mark_t gravatar image

Use view, Value Highlighting to make sure the percentages are recognized as numbers, they should show in blue.

When you open the csv file, make sure you enable the checkbox for Detect special numbers. This will allow you to include % in the numbers.

Make sure there are no spaces in front of the numbers. Depending on your data format you might be able to enable space as a separator and enable merge separators.

edit flag offensive delete link more


Enabling space as a separator got rid of a rouge space after the % sign and and I used detect special numbers and now I can filter properly. Thanks!

FistCar gravatar imageFistCar ( 2016-08-23 01:37:26 +0200 )edit

If the answer solves your question please tick the ✔.

m.a.riosv gravatar imagem.a.riosv ( 2016-08-23 14:25:47 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-08-23 00:47:00 +0200

Seen: 74 times

Last updated: Aug 23 '16