Excel quotation marks / VBS to SAP

[former_member1238704]

Hi guys!

Im new SAP user 🙂

I made a script in sap, to export information from excel. The original script was originated through executions within SAP, and later I adapted so that the information updated according to the excel data.

the marked cells change with the excel information, and then i save in VBS and run the script in SAP.

The big problem is, as the SAP field information needs to be enclosed in double quotes (" "), I'm not able to adjust this automatically.... just manually right in the VBS TXT!

Does anyone have any tips or an easier way?

[jerryjanda]

Welcome to the SAP Community! Thank you for visiting us to get answers to your questions. We're always happy to see new SAP users here.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Second, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html, as that will help you when submitting questions to the community.

I also recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

All the best,

--Jerry

Moderation Lead

[k_bar]

The ASCII code for quotes is 34 (22 for HEX, 042 for OCT). Depending on the coding language, you would use the appropriate function to generate the ASCII character for quotes. For example, in VB it's chr(34)