Importing Water Quality Less Than values

[SLee]

Hello, 

I was wondering when importing data with less then (<) values do you keep the (<) symbol or do you edit the data? For example if a value reads <1 do you edit it to read 0.5, as entering 1 is an incorrect value?  I know in excel (<) values can't be worked with you have to edit the value to get rid of the (<) symbol. Is WISKI the same?  Any help would be greatly appreciated. 
Thanks, Sue Lee (A Newbie to WISKI)

@SteveWKISTERS @massimo.narini

[SteveWKISTERS]

Hi Sue Lee,

When importing the water quality data there is the ability to map any symbols (I. E. < > ~) to the Symbol attribute. These are stored with each applicable value result in the system.

You can find the the symbol column if you navigate to Import > Sampling > Available Columns tab.

Note that if the symbol and value are stored in the same column in Excel,  I believe you will need to use the split function to separate the symbol from the value.

Steve with KISTERS