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

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!

@Zroy21

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

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

@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.

I have enabled scripting

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