INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Data Display issue and the "\" Character

Data Display issue and the "\" Character

(OP)
I am trying to display data containing the "\" character.

This text data is stored in one only database field as ' PN\abc123PN\def234PN\hij345 '
The PN\ is the identifier for each new instance of a PartNumber. Each PartNumber is always in the alph-numeric format of abc123

When the field is added to the report only the first PartNumber displays i.e. "PN\abc123"
The rest of the string is ignored.

I think the "\" character is somehow 'to blame' for this strange behavior.

Any thoughts on what may be causing this condition or work arounds are apprecaited.


KMD

RE: Data Display issue and the "\" Character

I have had fields in the past where the "\" character has been used and it has never caused a problem, and have just tested it now and it worked.

Are you sure it's not just a question of the size of the field on the report (probably a silly question but thought it worth asking anyway)?

Have you checked the Display String properties (right click => Format Field => Common Tab => x2 beside Display String) to make sure it hasn't been formatted to display only the first part of the string?

What sort of source data (ie, database) are you querying from? How are you connecting (ie, ODBC)?. The only other thing I can think of is that it is something to do with either the database itself of the connector.

What happens if you use a formula to return the field, rather than the field itself? What happens if you use REPLACE Function to replace the "\" with another separator character, eg:

CODE

REPLACE({Table.Field}, '\', '|') 

Hope something above helps you to get to the bottom of this. If not, post back with the answers to the questions raised and hopefully one of us will be able to assist.

Cheers
Pete

RE: Data Display issue and the "\" Character

Do you have rtf text interpretation enabled for that field?
I think \def may be an rtf tag. At least \deff is. This issue would be very unlikely though.

I tested entering your text in a formula and had no problems with all possible settings.
Try setting the field to grow - perhaps there are some hidden line breaks after each Part number.

RE: Data Display issue and the "\" Character

(OP)
Setting to CAN GROUW did the trick..... thank you !

PS
The PN now display in column format... not a long string such as in the data field. So it displays better that I was hoping for..... Merci again.)

RE: Data Display issue and the "\" Character

Excellent!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close