For that you need to read and understand about TEXTTABLE
http://community.jboss.org/wiki/TextToTableWithTeiid
https://www.icts.uiowa.edu/confluence/display/ICTSit/Creating+a+View+from+text+table+using+Teiid
Ramesh..