G
GulfLass
We have a set of data from a laboratory containing <values that we want to
prepare for importing to Access. We need to ensure that Access recognises the
values as numeric (for later graphing & calculations) but cannot simply
remove the < symbol - rather we want to remove the < symbol and multiply the
value by e.g. 0.99999 (to differentiate from values that were actually 'x'
not '<x'.
e.g. have
Sample ID, Parameter 1, Parameter 2,
abc, <0.001, 0.01
want
Sample ID, Parameter 1, Parameter 2
abc, 0.000999999, 0.01
Any help would be appreciated (maybe this can be done at the Access import
stage?).
prepare for importing to Access. We need to ensure that Access recognises the
values as numeric (for later graphing & calculations) but cannot simply
remove the < symbol - rather we want to remove the < symbol and multiply the
value by e.g. 0.99999 (to differentiate from values that were actually 'x'
not '<x'.
e.g. have
Sample ID, Parameter 1, Parameter 2,
abc, <0.001, 0.01
want
Sample ID, Parameter 1, Parameter 2
abc, 0.000999999, 0.01
Any help would be appreciated (maybe this can be done at the Access import
stage?).