DataMystic

Thanks.

Yep - it is easy! Thanks.

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

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

Thanks -0..-0 worked

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