Validate Quantity value in excelsheet during upload.

[Former Member]

Dear all ABAP guru,

Can anyone tell me how to validate quantity value from excel during an upload. What is the best option to validate quantity value.

As we know, quantity value can be 3, 000 or 3.000 or 3 all depends on user profile settings

Appreciate if someone can give some idea. Thanks

Thanks

[Former Member]

Hi,

Always the separator will be , in Excel. When ever there is a value with separator the value will be enclosed in quotes, like "3,000.00" .

So validation can be like this

Upload the Value.

Remove the " if there is one

Remove the separator , if there is one

Do a numberic check If it is numeric, then the quantity is valid else invalid.

Please reward if useful.