Remove Non Printer characters

[Cairmor]

I have a report column which appears blank when printing via Crystal reports 2008.

I ran a length({column}) on it and verified that length returns 1-15 blank characters on many records (the records appearing to be null)

I then ran length(trim({column})) on it, but the length did not change.

My data source is an old SAS system.

Any ideas on how to get rid of the records with non-printing characters?

Is there something like a clean() function in cr2008?

 

[IanWaterman]

Have you turned off set Nulls to default.

File -> Report options uncheck box

Then in select expert set

not(isnull(yourfield))

Ian

 

[HowardHammerman]

There is no clean() function.

You can use the ASC function which returns the ASCII value of a single character.

So create a formula with the following expression:

ASC({table.field}[1])

in the selection formula make sure you only select those recrods with a value between 48 and 122.

ASCII 48 is 0 and 122 is z



Howard Hammerman,
Crystal Training and Crystal Material
On-site classes and one-on-one coaching
Low-cost telephone/email support
FREE independent Crystal newsletter
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[Cairmor]

Thanks for the replies..

.I used Howards recommendation with the asc function and got what I needed by looping thru each character of the field, checking for asc() being between 48 and 122, and reassembling the field value if the character was a valid one.

It worked out. Problem solved.

 

[HowardHammerman]

Good work! I should have suggested a loop.

Howard Hammerman,
Crystal Training and Crystal Material
On-site classes and one-on-one coaching
Low-cost telephone/email support
FREE independent Crystal newsletter
howard@hammerman.com

http://www.hammerman.com

800-783-2269