dataport format int

yacineCHERMAK · 2006-04-07

Hello,
I would like to create a dataport to export an order.
I would like to export fields quantity on 7 positions with zero on a left: example:
if the quantity is equal to 5 then 0000005
if the quantity is equal to 350 then 0000350
could you give me the function has to use
Thank you in advance

jhoek · 2006-04-07

Definitely possible using the standard FORMAT function. Let me try and find the right syntax for you and post it here in a few minutes.

amunozsu · 2006-04-07

In the table 288 "Vendor bank account", you have the function PrePadString() it does exactly what you need.

-- Alejandro --

jhoek · 2006-04-07

FORMAT(350, 0, '<Integer,7><Filler Character,0>');

ashishgupta · 2006-04-10

Hello yacineCHERMAK,
As u said that you would like to create a dataport to export order. Tell me one thing that what do you mean by exporting order ? do u mean export header and line both. If u r doing this then tell me how r u doing it ? b'coz I have the same requirement. It's urgent.

Thanks & Regards
Ashish

sgg · 2006-04-10

As Mentioned by Jhoek, put the following Codes in the Format Property of the Quantity DataPort field of your Dataport :

<Integer,7><Filler Character,0>

Note however that if you want to import the Data Exported by using your dataport into Excel, ands you want to maintain the Exported Format, you will have to make sure that you format the Number Accordingly, else, all the Leading Zero's will disappear since the values will be seen as Integer or will be formated using "General" format in Excel.

yacineCHERMAK · 2006-10-24

thanks for your help

dataport format int

Comments

Categories