Search found 11 matches

by access1denied
Sat Mar 25, 2017 8:00 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Copy and paste/insert
Replies: 4
Views: 3921

Re: Copy and paste/insert

Yes, we have purchased the software... It was a consultant whom informed us of this..
by access1denied
Mon Feb 06, 2017 3:32 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Copy and paste/insert
Replies: 4
Views: 3921

Re: Copy and paste/insert

I was informed that TextPipe is not able to handle such a complex process... Still a good product
by access1denied
Sat Feb 04, 2017 10:24 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Copy and paste/insert
Replies: 4
Views: 3921

Copy and paste/insert

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...
by access1denied
Fri Aug 28, 2015 12:39 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: insert aata from Excel file into IMB Database
Replies: 3
Views: 5681

Re: insert aata from Excel file into IMB Database

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 ...
by access1denied
Thu Aug 27, 2015 10:49 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: insert aata from Excel file into IMB Database
Replies: 3
Views: 5681

Re: insert aata from Excel file into IMB Database

Sorry for the late response... I didn't realize I would have gotten an answer... I will try your suggestion immediately.
by access1denied
Thu Jul 30, 2015 4:49 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: insert aata from Excel file into IMB Database
Replies: 3
Views: 5681

insert aata from Excel file into IMB Database

is it possible to insert data from an excel file into a DB2 database (ODBC connection) table?
by access1denied
Mon Aug 12, 2013 11:00 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Capture to variable
Replies: 2
Views: 6584

Re: Capture to variable

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 under Each...
by access1denied
Mon Aug 12, 2013 7:54 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Capture to variable
Replies: 2
Views: 6584

Capture to variable

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....
by access1denied
Thu Apr 04, 2013 10:39 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Joining files with same part of the name
Replies: 3
Views: 5735

Re: Joining files with same part of the name?

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 ...
by access1denied
Thu Apr 04, 2013 6:23 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Extract Matching numbers from a file
Replies: 2
Views: 4488

Re: Extract Matching numbers from a file

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...
by access1denied
Wed Apr 03, 2013 5:19 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Extract Matching numbers from a file
Replies: 2
Views: 4488

Extract Matching numbers from a file

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...