Padding in Dataport

Answers

• Options

  mohana_cse06 Member Posts: 5,503

  2011-02-11

  I tries like this
  
  

  AmountPay := FORMAT(4325.80);
  AmountPay := PADSTR('',18 - STRLEN(AmountPay),'0') + FORMAT(AmountPay);
  message('%1', AmountPay);
  

  
  and output is
  
  
  Please check the value of Amount in your case..

  output.JPG 5.9K

  
  -Mohana
  http://mohana-dynamicsnav.blogspot.in/
  https://www.facebook.com/MohanaDynamicsNav

  0
• Options

  Aravindh_Navision Member Posts: 258

  2011-02-11

  Hi Mohana,
  
  Thanks a lot for your response. It displays the value in normal condition, but I need to get in text file in dataport.
  
  Thanks,
  Aravindh

  0
• Options

  xin Member Posts: 10

  2011-02-11

  Hi,
  
  I think you can try this:-
  
  AmountPay := FORMAT(Amount,0,'<Precision,2:2><Standard Format,0>');
  AmountPay2 := PADSTR('',18 - STRLEN(AmountPay),'0') + FORMAT(AmountPay);
  message('%1', AmountPay2);
  
  But declare another global variable for AmountPay2 and both of them datatype = Code, so the decimal places .80 will be show.
  
  Thanks.

  0
• Options

  Aravindh_Navision Member Posts: 258

  2011-02-11

  Hi Xin,
  
  In which trigger I need to write this code? Because I am getting zeros as output...
  
  Thanks,
  Aravindh

  0
• Options

  xin Member Posts: 10

  2011-02-11

  Hi,
  
  You can put on OnBeforeExportRecord() & for the Dataport Fields, put variable AmountPay2 instead of Amount.
  Also make sure you've write the code CalcFields(Amount) (if amount is flow field) before the code.
  
  Thanks.

  0
• Options

  Aravindh_Navision Member Posts: 258

  2011-02-11

  Hi Xin,
  
  Great.. It works perfectly.
  
  Thanks a lot,
  Aravindh

  0
• Options

  xin Member Posts: 10

  2011-02-11

  Hi,
  You are welcome.

  0