topic Re: Validate Quantity value in excelsheet during upload. in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/validate-quantity-value-in-excelsheet-during-upload/m-p/4120132#M985002 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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" .</P><P></P><P>So validation can be like this</P><P></P><P>Upload the Value. </P><P>Remove the " if there is one</P><P>Remove the separator , if there is one</P><P>Do a numberic check If it is numeric, then the quantity is valid else invalid.</P><P></P><P>Please reward if useful.</P></BODY></HTML> Fri, 04 Jul 2008 03:51:07 GMT Former Member 2008-07-04T03:51:07Z Validate Quantity value in excelsheet during upload. https://community.sap.com/t5/application-development-and-automation-discussions/validate-quantity-value-in-excelsheet-during-upload/m-p/4120131#M985001 <HTML><HEAD></HEAD><BODY><P>Dear all ABAP guru,</P><P></P><P>Can anyone tell me how to validate quantity value from excel during an upload. What is the best option to validate quantity value.</P><P></P><P>As we know, quantity value can be 3, 000 or 3.000 or 3 all depends on user profile settings</P><P></P><P>Appreciate if someone can give some idea. Thanks</P><P></P><P>Thanks</P></BODY></HTML> Fri, 04 Jul 2008 01:26:32 GMT https://community.sap.com/t5/application-development-and-automation-discussions/validate-quantity-value-in-excelsheet-during-upload/m-p/4120131#M985001 Former Member 2008-07-04T01:26:32Z Re: Validate Quantity value in excelsheet during upload. https://community.sap.com/t5/application-development-and-automation-discussions/validate-quantity-value-in-excelsheet-during-upload/m-p/4120132#M985002 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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" .</P><P></P><P>So validation can be like this</P><P></P><P>Upload the Value. </P><P>Remove the " if there is one</P><P>Remove the separator , if there is one</P><P>Do a numberic check If it is numeric, then the quantity is valid else invalid.</P><P></P><P>Please reward if useful.</P></BODY></HTML> Fri, 04 Jul 2008 03:51:07 GMT https://community.sap.com/t5/application-development-and-automation-discussions/validate-quantity-value-in-excelsheet-during-upload/m-p/4120132#M985002 Former Member 2008-07-04T03:51:07Z