Skip to main content

Combine Multiple Lines to 1 line with delimiter

  • February 28, 2016
  • 8 replies
  • 0 views
D

Hi all,

I'm not a developer and need some help.  Doing a screen scrape I need to copy 7 values to a .txt or .csv in the following format:

Value1,Value2,Value3,Value4,Value5,Value6,Value7

I'm able to get the data, but the values are being written to individual lines:

Value1

Value2

Value 3

Value 4

Value 5

Value 6

Value 7

The script in Rumba looks like this:

For a = 1 to 5


EMReadScreen ScreenText,10,2,29
FileAppend ScreenText

EMReadScreen ScreenText,6,9,25
FileAppend ScreenText

EMReadScreen ScreenText,6,10,25
FileAppend ScreenText

EMReadScreen ScreenText,3,11,25
FileAppend ScreenText

EMReadScreen ScreenText,6,12,25
FileAppend ScreenText

EMReadScreen ScreenText,20,13,25
FileAppend ScreenText

EMReadScreen ScreenText,10,14,25
FileAppend ScreenText

EMSendKey "<enter>"

Next a

loop

Thank you for any help that anyone can offer.


#Rumba

8 replies

D

Hi all,

I'm not a developer and need some help.  Doing a screen scrape I need to copy 7 values to a .txt or .csv in the following format:

Value1,Value2,Value3,Value4,Value5,Value6,Value7

I'm able to get the data, but the values are being written to individual lines:

Value1

Value2

Value 3

Value 4

Value 5

Value 6

Value 7

The script in Rumba looks like this:

For a = 1 to 5


EMReadScreen ScreenText,10,2,29
FileAppend ScreenText

EMReadScreen ScreenText,6,9,25
FileAppend ScreenText

EMReadScreen ScreenText,6,10,25
FileAppend ScreenText

EMReadScreen ScreenText,3,11,25
FileAppend ScreenText

EMReadScreen ScreenText,6,12,25
FileAppend ScreenText

EMReadScreen ScreenText,20,13,25
FileAppend ScreenText

EMReadScreen ScreenText,10,14,25
FileAppend ScreenText

EMSendKey "<enter>"

Next a

loop

Thank you for any help that anyone can offer.


#Rumba

This should work for what you are asking for.

Sub Main

'if data values are not text strings change the types below to Long or integer for integer numbers or double for decimal numbers.

Dim Value1 As String

Dim Value2 As String

Dim Value3 As String

Dim Value4 As String

Dim Value5 As String

Dim Value6 As String

Dim Value7 As String

Dim Filename As String

'replace "filename here" with file to append to, example "C:\\myfile.csv"

Filename = "filename here"

Open Filename For append As #I

For a = 1 to 5

EMReadScreen Value1,10,2,29

EMReadScreen Value2,6,9,25

EMReadScreen Value3,6,10,25

EMReadScreen Value4,3,11,25

EMReadScreen Value5,6,12,25

EMReadScreen Value6,20,13,25

EMReadScreen Value7,10,14,25

Write #1,Value1,Value2,Value3,Value4,Value5,Value6,Value7

EMSendKey "<enter>"

Next a

close

End Sub

D

Hi all,

I'm not a developer and need some help.  Doing a screen scrape I need to copy 7 values to a .txt or .csv in the following format:

Value1,Value2,Value3,Value4,Value5,Value6,Value7

I'm able to get the data, but the values are being written to individual lines:

Value1

Value2

Value 3

Value 4

Value 5

Value 6

Value 7

The script in Rumba looks like this:

For a = 1 to 5


EMReadScreen ScreenText,10,2,29
FileAppend ScreenText

EMReadScreen ScreenText,6,9,25
FileAppend ScreenText

EMReadScreen ScreenText,6,10,25
FileAppend ScreenText

EMReadScreen ScreenText,3,11,25
FileAppend ScreenText

EMReadScreen ScreenText,6,12,25
FileAppend ScreenText

EMReadScreen ScreenText,20,13,25
FileAppend ScreenText

EMReadScreen ScreenText,10,14,25
FileAppend ScreenText

EMSendKey "<enter>"

Next a

loop

Thank you for any help that anyone can offer.


#Rumba

elcron,  Thanks a million.  This worked!!

D

Hi all,

I'm not a developer and need some help.  Doing a screen scrape I need to copy 7 values to a .txt or .csv in the following format:

Value1,Value2,Value3,Value4,Value5,Value6,Value7

I'm able to get the data, but the values are being written to individual lines:

Value1

Value2

Value 3

Value 4

Value 5

Value 6

Value 7

The script in Rumba looks like this:

For a = 1 to 5


EMReadScreen ScreenText,10,2,29
FileAppend ScreenText

EMReadScreen ScreenText,6,9,25
FileAppend ScreenText

EMReadScreen ScreenText,6,10,25
FileAppend ScreenText

EMReadScreen ScreenText,3,11,25
FileAppend ScreenText

EMReadScreen ScreenText,6,12,25
FileAppend ScreenText

EMReadScreen ScreenText,20,13,25
FileAppend ScreenText

EMReadScreen ScreenText,10,14,25
FileAppend ScreenText

EMSendKey "<enter>"

Next a

loop

Thank you for any help that anyone can offer.


#Rumba
Gchizz,

Hello. I was reading your post above and wanted to ask you how you got started doing a screen scrape in Rumba. My manager has asked me to look into screen scraping in Rumba, and I am trying to figure out where and how to start. Any help would be greatly appreciated. Thanks.
D

Hi all,

I'm not a developer and need some help.  Doing a screen scrape I need to copy 7 values to a .txt or .csv in the following format:

Value1,Value2,Value3,Value4,Value5,Value6,Value7

I'm able to get the data, but the values are being written to individual lines:

Value1

Value2

Value 3

Value 4

Value 5

Value 6

Value 7

The script in Rumba looks like this:

For a = 1 to 5


EMReadScreen ScreenText,10,2,29
FileAppend ScreenText

EMReadScreen ScreenText,6,9,25
FileAppend ScreenText

EMReadScreen ScreenText,6,10,25
FileAppend ScreenText

EMReadScreen ScreenText,3,11,25
FileAppend ScreenText

EMReadScreen ScreenText,6,12,25
FileAppend ScreenText

EMReadScreen ScreenText,20,13,25
FileAppend ScreenText

EMReadScreen ScreenText,10,14,25
FileAppend ScreenText

EMSendKey "<enter>"

Next a

loop

Thank you for any help that anyone can offer.


#Rumba
Gchizz,

Hello. I was reading your post above and wanted to ask you how you got started doing a screen scrape in Rumba. My manager has asked me to look into screen scraping in Rumba, and I am trying to figure out where and how to start. Any help would be greatly appreciated. Thanks.
D

Hi all,

I'm not a developer and need some help.  Doing a screen scrape I need to copy 7 values to a .txt or .csv in the following format:

Value1,Value2,Value3,Value4,Value5,Value6,Value7

I'm able to get the data, but the values are being written to individual lines:

Value1

Value2

Value 3

Value 4

Value 5

Value 6

Value 7

The script in Rumba looks like this:

For a = 1 to 5


EMReadScreen ScreenText,10,2,29
FileAppend ScreenText

EMReadScreen ScreenText,6,9,25
FileAppend ScreenText

EMReadScreen ScreenText,6,10,25
FileAppend ScreenText

EMReadScreen ScreenText,3,11,25
FileAppend ScreenText

EMReadScreen ScreenText,6,12,25
FileAppend ScreenText

EMReadScreen ScreenText,20,13,25
FileAppend ScreenText

EMReadScreen ScreenText,10,14,25
FileAppend ScreenText

EMSendKey "<enter>"

Next a

loop

Thank you for any help that anyone can offer.


#Rumba
1st step:
Know the routes:
1. Rumba Macro's
2. Rumba Scripting
2.1 Do you have Rumba 9.5 or higher, then you can use VBA voor scripting
2.2 Below 9.5 the own scripting language
3. Rumba Development Edition (RDE) for .NET FrameWork and use the underlying libs like HLLAPI.dll
D

Hi all,

I'm not a developer and need some help.  Doing a screen scrape I need to copy 7 values to a .txt or .csv in the following format:

Value1,Value2,Value3,Value4,Value5,Value6,Value7

I'm able to get the data, but the values are being written to individual lines:

Value1

Value2

Value 3

Value 4

Value 5

Value 6

Value 7

The script in Rumba looks like this:

For a = 1 to 5


EMReadScreen ScreenText,10,2,29
FileAppend ScreenText

EMReadScreen ScreenText,6,9,25
FileAppend ScreenText

EMReadScreen ScreenText,6,10,25
FileAppend ScreenText

EMReadScreen ScreenText,3,11,25
FileAppend ScreenText

EMReadScreen ScreenText,6,12,25
FileAppend ScreenText

EMReadScreen ScreenText,20,13,25
FileAppend ScreenText

EMReadScreen ScreenText,10,14,25
FileAppend ScreenText

EMSendKey "<enter>"

Next a

loop

Thank you for any help that anyone can offer.


#Rumba
Hi Gchizz,

Jacco has pointed out the various methods of driving the screen navigation. Which one you should use really depends on the task you need to perform.

e.g.
a) You just need to navigate from screen A to screen X
b) You need to navigate from screen A to screen X and record/send information from/to various screens using a text file
c) You need to navigate from screen A to screen X and record/send information from/to various screens using COM (say MS Excel).
d) You need to drive the navigation from outside Rumba, say for example a custom app or MS Excel

for a) Rumba macros should suffice. You can record Rumba Macros for "Tools" | "Record Macro" (if you get various options in the save as type drop-down choose "Rumba Macro .rmc")
for b) and c) Rumba Script is likely the best option, rumba script is a seperate MSI installation, you can easily check itif it is installed by looking at the "Tools", do you have any option with "Script" in them e.g. "Record Script", "Edit Script"?
If yes they you can record a script and subsequently edit it in the Script editor. The editor has some help and it supports COM, so you can create an Excel object and talk to it from Rumba Script, etc.
If you don't have Rumba Scripting installed then you should contact your internal product owner, who can provide it or he/she can contact Micro Focus it needed.
d) This is where things get a little more difficult, you have a couple of options RDE, HLLAPI, or if you have 9.5 and the VBA Add-on then you can use COM.

As you can see there are many possibilities, and it may appear to be a little overwhelming. If you need a little help you should contact the Micro Focus Supportline. Naturally you can post question here also, if you do try to have specific ones, e.g. how do I read from a text file in Rumba script, or how do I talk to an Extra! spreadsheet from Rumba script etc. This allows us to create a sample that you can play with and modify to suit your needs.
D

Hi all,

I'm not a developer and need some help.  Doing a screen scrape I need to copy 7 values to a .txt or .csv in the following format:

Value1,Value2,Value3,Value4,Value5,Value6,Value7

I'm able to get the data, but the values are being written to individual lines:

Value1

Value2

Value 3

Value 4

Value 5

Value 6

Value 7

The script in Rumba looks like this:

For a = 1 to 5


EMReadScreen ScreenText,10,2,29
FileAppend ScreenText

EMReadScreen ScreenText,6,9,25
FileAppend ScreenText

EMReadScreen ScreenText,6,10,25
FileAppend ScreenText

EMReadScreen ScreenText,3,11,25
FileAppend ScreenText

EMReadScreen ScreenText,6,12,25
FileAppend ScreenText

EMReadScreen ScreenText,20,13,25
FileAppend ScreenText

EMReadScreen ScreenText,10,14,25
FileAppend ScreenText

EMSendKey "<enter>"

Next a

loop

Thank you for any help that anyone can offer.


#Rumba
Thanks, Tom and Jacco, for your responses. I appreciate the information and options you two gave me . I will do a little bit of research/exploring in Rumba and post any questions I have here in the forum. Thanks again.
D

Hi all,

I'm not a developer and need some help.  Doing a screen scrape I need to copy 7 values to a .txt or .csv in the following format:

Value1,Value2,Value3,Value4,Value5,Value6,Value7

I'm able to get the data, but the values are being written to individual lines:

Value1

Value2

Value 3

Value 4

Value 5

Value 6

Value 7

The script in Rumba looks like this:

For a = 1 to 5


EMReadScreen ScreenText,10,2,29
FileAppend ScreenText

EMReadScreen ScreenText,6,9,25
FileAppend ScreenText

EMReadScreen ScreenText,6,10,25
FileAppend ScreenText

EMReadScreen ScreenText,3,11,25
FileAppend ScreenText

EMReadScreen ScreenText,6,12,25
FileAppend ScreenText

EMReadScreen ScreenText,20,13,25
FileAppend ScreenText

EMReadScreen ScreenText,10,14,25
FileAppend ScreenText

EMSendKey "<enter>"

Next a

loop

Thank you for any help that anyone can offer.


#Rumba
Thanks, Tom and Jacco, for your responses. I appreciate the information and options you two gave me . I will do a little bit of research/exploring in Rumba and post any questions I have here in the forum. Thanks again.

Recent badge winners

Explore all badges
Terms & ConditionsAccessibility statement