Search found 6 matches

by SoreHeed
Tue Jan 28, 2020 9:37 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Access violation error using database connection
Replies: 2
Views: 2800

Access violation error using database connection

Hi Using Special -> Database connection I created a connection to a SQL Server 2014 SP3 database. When trial running, Textpipe reports the following error in the Status tab… Error 2020-01-28 11:30:09 Access violation at address 0000000000E56509 in module 'textpipe.exe'. Read of address 0000000000000...
by SoreHeed
Mon Jan 27, 2020 10:27 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Updating csv Field Values When Empty
Replies: 2
Views: 2584

Updating csv Field Values When Empty

Hi I am using TextPipe Pro to extract csv formatted records from a file and insert them into a SQL table. All fields in the file are qualified using single quotes. However field 4, see below, is considered by SQL as an empty string and the Insert fails as field 4 is a numeric field in the DB. In thi...
by SoreHeed
Fri Jan 24, 2020 12:15 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Remove Last Character from Last Line
Replies: 2
Views: 2658

Remove Last Character from Last Line

Hi I was trying to use Restrict -> Line Range to select the last line and then remove the last character. But after many attempts and reading what I could find about configuring a line range, I couldn't find out how to set the Line Range to the last line. Is this possible or is my approach wrong? Th...