DataMystic

Yes, we have purchased the software... It was a consultant whom informed us of this..

I was informed that TextPipe is not able to handle such a complex process... Still a good product

I have a file that contains data in the in the following order 12345 Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data D...

The suggestion is not working for me... My excel file contains eight columns. I have created the filter, but I doesn't appear to update the table. I was hoping to upload the filter, but I am getting a message that reads: The extension fll is not allowed. My filter looks: TextPipe Edition 9.9 Filter ...

Sorry for the late response... I didn't realize I would have gotten an answer... I will try your suggestion immediately.

is it possible to insert data from an excel file into a DB2 database (ODBC connection) table?

I solved the problem... I am going to leave this alone just incase someone else maybe having the same problem... To make this work, you would need to add the restrict filter "Each line in turn", then make all your restrict filters a subfilter... in other words, simple drag all your filter ...

I am using the Capture to variable as a Sub-filter for Restrict columns. The problem I am having is that it is only capturing data from the last line as it was explained below: I am a little confuse what I need to add for the filter to not only look at the last line of recorder, but all the records....

Copy 1name*.* merged1.txt Copy 2name*.* merged2.txt Copy 2name*.* merged3.txt I the copy command doesn't work, use xcopy. What I am saying here is you don't need TP for such a simple task... Open up notepad and enter the above... Modify the above to include the path of the files... Save the notepad ...

I don't know... I'm not feeling the love in here... I was able to accomplish this task using another tool... I was hopping to have done it with TP...

I have two files, the first file (FileA) is an excel file with only account numbers... the second file (File B) is a pipe (|) delimited file with 44 fields. If the account number in 'File A' matches the account number in field 28 of 'File B' then extract the full line. I used 'Extract lines matching...