DataReader: cannot read right-justified numeric field

achan

• December 04, 2008 00:00

• Answered

Follow

Hi,

My FMT looks like this:

<?xml version="1.0" encoding="UTF-8"?>
<Record name="test" type="fixed" recordDelimiter="\n">
<Field name="ref_code" type="string" nullable="false" size="1"/>
<Field name="amt" type="numeric" nullable="false" size="5" format="#####"/>
</Record>

and my fix-length data looks like this:

a 100
b 200


when I try to read this data using the Data_Reader, i am getting this message:

WARN [INPUT_0] - amt (numeric) cannot be set to " 100" in field # 1 of record # 1


and my output file is empty...

Is there a workaround or fix to read numeric field that is right-justified with leading blanks in a fix-length data file?

Thanks,
al

• 

  avackova

  • December 05, 2008 09:08

  0

  Comment actions Permalink

  Hi Al,
  I can't reproduce your problem. Which Clover version do you use?
• 

  achan

  • December 08, 2008 18:20

  0

  Comment actions Permalink

  Hi Agata,
  
  I am using version 2.5.2
  
  al
• 

  avackova

  • December 09, 2008 08:44

  0

  Comment actions Permalink

  I run the graph under the 2.5.2 version with Universal Data Reader as well as with Fixlen Data Reader, and both run successfully.
  Do you have space before end of line (the number has length 5)?
• 

  achan

  • December 10, 2008 20:13

  0

  Comment actions Permalink

  Hi Agata,
  
  yes, i have 2 spaces in front of my amt... so it's " 100" and " 200" are my amt values...
  
  al
• 

  avackova

  • December 11, 2008 08:01

  0

  Comment actions Permalink

  Hi, I really don't know where the problem can be. Maybe setting locale could help.

Please sign in to leave a comment.