Skip to Content

conditional flat file extraction in sap bods 3.2 from remote location

Jul 29, 2017 at 04:11 PM


avatar image
Former Member


I have project requirement wherein we have to extract data from flat file(some are csv,xls,txt format ) from remote location based on certain conditions.

1 > extracting data only from latest available file (since days wise flat file are generated on remote location).

Data conversion as per requirement.

2 > converting html to txt file / directly extracting data from html file from remote location.

incase of file conversion from html to txt certain formatting is required.


Sachin Gupta

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ravi kiran Pagidi Jul 29, 2017 at 09:13 PM

Hi Sachin,

Use get_file_attribute() function to extract data from latest available file.

syntax :- get_file_attribute('//order', 'date_created') . Write conditions using this function in a script and extract data from latest file.


Ravi kiran

10 |10000 characters needed characters left characters exceeded