pbare
Well Known Member
I am reading in a line from a flat file
The file consists of 4 columns that are strings and 1 numerical field.
I can successfully read all of the fields into my variables as expected except the numerical field.
I can read it into a string variable but everything I have tried to convert the value from a string to a value, nothing seems to work.
I have tried converting my string for this field to Math Numeric (B0000580) but only get a zero
I tried assigned the string value to the numerical value with no luck
The numerical field is the last one in my data file, would that have anything to do with it?
This is the last thing I need to fix so that I can provide a solution to my business users.
I am under a bit of a crunch so if anyone has any suggestions, I am willing to try it
thanks
Pam
The file consists of 4 columns that are strings and 1 numerical field.
I can successfully read all of the fields into my variables as expected except the numerical field.
I can read it into a string variable but everything I have tried to convert the value from a string to a value, nothing seems to work.
I have tried converting my string for this field to Math Numeric (B0000580) but only get a zero
I tried assigned the string value to the numerical value with no luck
The numerical field is the last one in my data file, would that have anything to do with it?
This is the last thing I need to fix so that I can provide a solution to my business users.
I am under a bit of a crunch so if anyone has any suggestions, I am willing to try it
thanks
Pam