Reading larger text file and extracting certail part of data from it

activities
studio

#1

hi,
i want to extract data from the text file with is larger in size i only want the last 3 pages of text to be extracted. i tried to copy text into excel but its not pasting the data correctly. i want the text to be neatly extracted in cell wise so i can use that as an input for copying few values into another excel.any ways to acheive this and this should be reliable as this should work for all report files of same type.


#2

please share your workflow @sravyarao20


#3

i did not develop the workflow yet i tried pasting manually the text data into excel but the text document is completley in unformatted state so i am not getting correct column wise data


#4

Just try to scrap by microsoft ocr activity and change the scale to 2 or 3 . So that you will get the correct data and please make sure that your font size is more than 12.


#5

what is your intended structure?


#6

i have 6 columns in the text file but when extracting it is giving 2 column names as single column name.i want 6 columns sepratley as it is in the text document how to achieve this


#7

i want to extract data from text document and keep it in the datatable the problem here is with the text document pattern its unformatted its having many spaces so i am not able to extract it in proper column wise its giving 2 columns together in single columns


#8

check inbox