Community

I have this funny looking character at the end of each record that I would like to remove. The character can only be seen if I turn on visible spaces and it looks
like a "d". I believe it might be a form feed character? I can remove it using SQL once the file is put into an Oracle table by referring to it as "CH(13)". Is there a way to eliminate this character in the file before I load data into table using Textpad?

Thanks,

Ralph

TextPad is showing you the linebreaks. Nothing special.
Why do you want to do this?
Lines are separated by carriage return and/or linefeeds.
With Visible spaces on TextPad just shows you where a line break occurs.
If you want to save the file in a different textfile format (Unix, Mac)
you can do that by changing the File Format in the Save (As) dialog.

If you want to delete all linebreaks and thus make the file contain only 1 (long) line you can use a regular expression.

Berend

I saw your reply to the above question and thought you might be able to help with this too?

Well actually i want to ADD special charatcters...

In fact i want to replace " , " with line return. Any ideas?
Thanks

I saw your reply to the above question and thought you might be able to help with this too?

Well actually i want to ADD special charatcters...

In fact i want to replace " , " with line return. Any ideas?
Thanks

Look for the following entry in the help file

How To, Find and Replace text, Replace text

Start a Replace dialog and enter \n in the Replace with input
check Regular expression.