Many thanks to all,
You show me the light !!!!!!
At the end what I have done is:
1.-Add to text columns "#" and "~"
2.-Join data column as follow
"#1000~"
"#2345-~"
3.-Replace "#" with "-"
"-1000~"
"-2345-~"
3.-Replace "-~" with " "
"-1000~"
"-2345"
4.-In the data load rule reject values which contains "~"
So I have 2 data load rules,
One for positive values, that give to me a warning (due to the "21312-" values)
Other one for the new negative and properly values.
Many thanks to all mates.
David
|