Screen Scraping reading one column with two words as two separate columns

Help
, , , ,
1

Hello, everybody! I am hoping that someone will be able to help me with this request!

I am using Screen Scraping to scrape seemingly structured data from SAP. I have 8 columns, only one of which contains a space in the header name. When I extract the data, the column with the space between the words is splitting into two columns. I need them to be one. Below is the structure:

Date, Lockbox, Batch, Checks, Applied, Part.appl, On account, Unprocess

On account should be one column and is being extracted as two.

Any help would be greatly appreciated!

2

@Zroy21

As you said it is structured data right. Use Data scraping instead of screen scraping.

3

It appears structured but Data Scraping is not supported in the application that I am using

4

@Zroy21

Have you enabled script in both client and server side or not ? To automate SAP application then we need to enable script then only BOT can identify elements.

5

I have enabled scripting

6

Hi , Once you use the Screenscrapping , copy the extracted text from the preview area of screenscrapping
Now use "generate datatable’ activity , double click it
Paste the above selected text and select multiple options like ‘Detect columns automatically’ , ‘CSV parsing’ , ‘COnsider first row as headers’
try all these options differently and see the output preview
Once you get the proper Datatable output
You can merge the columns data

1 Like