Kunena Site Syndication http://www.flowheater.net/ Sat, 19 May 2012 00:26:51 +0200 Kunena 1.5.10 http://www.flowheater.net/components/com_kunena/template/default_ex/images/english/emoticons/rss.gif http://www.flowheater.net/ Kunena Site Syndication http://www.flowheater.net/forum/common/314-text-process-question.html#315 Hi Christian, The easiest way to do that is you read your CSV file with the standard CSV delimiter comma. The field that contains two fields delimited by SPACES you have to split by yourself with the help of the String Split Heater (http://www.flowheater.net/help/heater-split.htm). In your case you need 2 String Split Heaters. On for the first column and one for the second column. The output of these two Heaters you have to move to the certain field on the WRITE side, that’s all. I've made a brief example; please have a look to the attachment. Your second question ) The TextFile and the Excel Adapter supports to add new columns by Drag&Drop fields to the WRITE side. It’s also possible to add new fields in the Adapter Configurator. Database Adapter can't handle this. If you need here new fields you have to alter the table schema by yourself and read in the new table schema with the FlowHeater Designer. http://www.flowheater.net/images/fbfiles/files/two_column_separator_in_csv_file.zip Thu, 26 Apr 2012 15:10:51 +0200 http://www.flowheater.net/forum/common/314-text-process-question.html#314 I need to re-organize a tab delimited file, easy right? One of my columns will be LAST,FIRSTMI. is there a way to look for the , and to make them separate TAB delimiters? Also how can I insert a new column when one doesn't exist? Thank you FH forum members. You rock! Thu, 26 Apr 2012 02:46:43 +0200 http://www.flowheater.net/forum/common/310-text-file-adapter-to-access.html#313 Hi Mark, I guess you have changed some data types on the WRITE side. Please try to read in the table schema on WRITE side again. The reason why only one record writes to the write side is the GroubBy Heater on the default layer! Remove this Heater/Functions and the definition could be work fine. I've modified your definition. Have a look to the attachment and try it again, please. http://www.flowheater.net/images/fbfiles/files/flowheat2.zip Thu, 19 Apr 2012 08:54:26 +0200