where clause issues/stripping out extraneous characters

[a212830]

Hi,

I need to do a where clause on a value that includes a % in the result, how can I strip off the percentage character so I can do a numerical where evaluation?

11:06:44 05/07/2015 good 1048333195 [Linux][Baseline][lrtp23][FileSystem][/boot] FileSystems\/boot\Use%=47% 7:45845 0 47

The "Use%" is a field, but the values get the percentage stored with them.

[woodcock · Accepted solution]

Try this:

... | eval NoPct=rtrim(Use%,"%")