I wrote the code as below its extracting all tabular data by splitting. Now i want to extract the last column(Values) data by removing Text in the middle of the table.
import re f_read = open('filename','r') f_write=open('filename','w') str='CEN/4' for line in f_read: m=re.search(str,line) if m: for line in f_read: # loop over the rows if not line.strip(): continue line = line.split(' ',1) # parse the columns print line f_write.writelines(line)
Table looks like this followed by values in each column.Now i want to remove the text and extract only the values of last column.
S T R E S S E S I N Q U A D R I L A T E R A L E L E M E N T S ( Q U A D 4 ) OPTION = BILIN ELEMENT FIBER STRESSES IN ELEMENT COORD SYSTEM PRINCIPAL STRESSES (ZERO SHEAR) ID GRID-ID DISTANCE NORMAL-X NORMAL-Y SHEAR-XY ANGLE MAJOR MINOR VON MISES 121 3423 342 4545 45435 4345 42353 3456456 67658 3435