Question
Accenture
IN
Last activity: 16 Oct 2018 12:03 EDT
How to convert a notepad to excel in openspan?
i need to convert a notepad to excel. should I write a script or is there any other method for it?
example:
custid custName
1 aaa
2 bbb
3 ccc
thanks in advance.!
***Moderator Edit: Vidyaranjan | Updated Categories***
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Pegasystems Inc.
US
You can use the Excel connector for this: http://help.openspan.com/80/Components/Microsoft_Excel.htm
Capgemini Technology Services India Limited
IN
Hi Aswini,
Did you get the solution?
how can we read that data from notepad and store to excel sheet in a table format.
Pegasystems Inc.
US
Reading out of notepad can be done by interrogating the Notepad window. You will need to read the text line by line and then split it. You can read line by line by using the .Net StringReader. Here is a simple example of reading through the text and splitting by a space.
Add your logic at the end to do something with the data acquired on each line.
Capgemini Technology Services India Limited
IN
Hi Jeff,
Thanks for the reply!!
I am not using Pega_8, In openspan unable to get the control NewStringReader, please help.
Thanks in advanced.
Anil
Capgemini Technology Services India Limited
IN
Hi Shang,
Yeah I got the solution, By Adding Constructor for type (looks like flower sysmbol,we can find it beside try catch icons) "System.IO.Streamreader" enter then select (String path) in Choose Method overload Pop up, After that i will add to your automation as well as in object explorer, Then You can do any operations with that.
Best Regards,
Anil Nalla
Pegasystems Inc.
IN
Hi,
Thank you for posting your query in the PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write a Post button that’s available on the top right pane of this page. Once created, please reply back here with the URL of the new post.
You may also refer this discussion link as a reference in the new thread.