change text type to integer

bangswit

hi...
how to change text file to integer type?
i have imported txt file
but while i want to import to integer field, it can't

Sunset

Evaluate(IntVariable, TextVariable)

bangswit

so if we want to fill to database field (integer), we should create 2 variable ?? (1 integer, 1 text)

my code doesn't work

Linenumber := COPYSTR(vstring3,4,6);
DF."3-Detail Tag" := 'DET';
DF."3-Line Item Number" := EVALUATE(LineNUmber,vstring3);

Sunset

OBJECT Report 50000 Text2Integer
{
  OBJECT-PROPERTIES
  {
    Date=12-08-10;
    Time=11:31:37;
    Modified=Yes;
    Version List=;
  }
  PROPERTIES
  {
    ProcessingOnly=Yes;
    OnPostReport=BEGIN
                   RandomText := 'RAN123456';
                   EVALUATE(LineInteger, COPYSTR(RandomText, 4, 6));
                   MESSAGE('%1', LineInteger);
                 END;

  }
  DATAITEMS
  {
  }
  REQUESTFORM
  {
    PROPERTIES
    {
      Width=9020;
      Height=3410;
    }
    CONTROLS
    {
    }
  }
  REQUESTPAGE
  {
    PROPERTIES
    {
    }
    CONTROLS
    {
    }
  }
  CODE
  {
    VAR
      RandomText@1000000000 : Text[10];
      LineInteger@1000000001 : Integer;

    BEGIN
    END.
  }
  RDLDATA
  {
  }
}

bangswit

ow ok
thanks a lot

bangswit

but how about the reversal?
change integer type to text

Sunset

Text := FORMAT(YourVariable)

bangswit

thanks a lot Sunset
=D> =D>