[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1485
  • Last Modified:

ASCII/Keyboard

Is there a combination of ascii characters/keyboard strokes to generate a page break/slew characters? This combination would be stored in an SQL table and placed in a file using bcp. Read by an application which is able to recognize a page break/slew characters.
0
TDENNIS
Asked:
TDENNIS
1 Solution
 
david_levineCommented:
What's a page break and a slew? Are they just Ascii characters? What do you want to do with them?

If they are just ascii characters, you can refer to them directly like chr(13) or whatever the correct asci code is, in a stored procedure.

David
0
 
jkotekCommented:
In Wintel enviromet you can hold <Alt> and type a character code ('1000' for 'R'...). Sometimes you have to use numeric keypad to type the character code and you can use good old ASCII code by suplying 0 in fromt of number ('082' for 'R', '065' for 'A'...)

In Unix there is allways possible to use '\' (backslash) to escape next character (<enter>, <tab>...)

Does this answer your question?
0
 
csabayCommented:
I don't actually see what be your problem, TDENNIS. As David pointed out you can use char function to insert as many ascii characters as you like into every column of char-like type of your tables. Use the SQL command INSERT [INTO] or UPDATE to put certain values to columns.

Probably you don't know the ascii code? Page break used to be an ascii 12 almost always.

Remember to use -c option when bcp-ing because native form builds a file containing ascii 11 characters which can disturb your application working with the text.

Charles
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
TDENNISAuthor Commented:
I found an ascii table with descriptions which listed ascii 12 as the (NP, Form Feed, new page) character. Thanks.
0
 
TDENNISAuthor Commented:
I found an ascii table with descriptions which listed ascii 12 as the (NP Form Feed, new page) character. Thanks.
0
 
csabayCommented:
OK, TDENNIS, we all are glad. By the way: you can accept David's comment as an answer (as well as mine :-)...

Charles
0
 
albertspCommented:
Why put ascii code in your table just for the newline in your bcp file?

When bcp your data to a text file you can create and use a format file.
In this file it is possible to give the field terminator.

use "\n" for the last field wich is the same as ascii 12

Albert
0
 
TDENNISAuthor Commented:
The page break/form feed is different from the new line charater. Currently, I am using a format file which contains the newline and carrige returns characters.  
0
 
csabayCommented:
TDENNIS,

the question is quite old. Have you still got the problem? If it is solved please accept a comment as an answer. (David's comment was satisfying, I think.)

If it is not please explain us why not.

Regards

Charles
0
 
csabayCommented:
TDENNIS,

are you here?

Charles
0
 
russ_henselCommented:
Seems like a bad idea to put formatting in data.  Generally you should use a cr lf pair of characters.  What the heck is a windows printer driver going to do with the characters.  How will the data be used in other contexts, that is other than the one output scheme that you are currently continplating.


Russ
0
 
TDENNISAuthor Commented:
Comment accepted as answer
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now