How to detect the presence of '^Z' character

savis · Post by **savis** » Wed Apr 23, 2008 11:12 am

Hi,

Is there a way to detect the presence of '^Z' character in a field.

I tried using count() function.

But it is not detecting.

Thanks in advance

Savis

ArndW · Post by **ArndW** » Wed Apr 23, 2008 11:21 am

Exactly how did you use the Count() function? I would recommend

Code: Select all

Count(In.ColumnName,CHAR(26))

savis · Post by **savis** » Wed Apr 23, 2008 11:53 am

thanks.. It worked..

Can i replace the '^Z' character with space?

Is there a way to do it?

umapathi · Post by **umapathi** » Wed Apr 23, 2008 12:00 pm

This could help you...

Convert(Char(26),' ',In.ColumnName)

JSimon · Post by **JSimon** » Wed Apr 23, 2008 12:05 pm

The Convert function. You would have to check the syntax, but off the top of my head maybe something like Convert(Char(26)," ",variable)

Jason

umapathi · Post by **umapathi** » Wed Apr 23, 2008 12:18 pm

it wl work....
Convert(Char(26),' ',In.ColumnName)
or
Convert(Char(26),Space(1),In.ColumnName)

savis · Post by **savis** » Wed Apr 23, 2008 12:55 pm

Thanks..