* Vincent Stoessel > Hello, I am trying to convert this weird cobol style number into a > regular integer. I got it from a fixed length text file. [...] > If the value is negative, the right most column will contain a > > special character: ] = -0, j = -1, k = -2, l = -3, m = -4, > > n = -5, o = -6, p = -7, q = -8, and r = -9. > > > example numbers: > > I have 1500 numbers that look like this! the rest are "normal" integers. > Any help would /really/ be appreciated. TIA. > > 000125] > 000020] > 000025]
As ] is -0, these numbers should be -1250, -200 and -250... right? What is the problem? -- Roger query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
