Page 1 of 1
How to detect the presence of '^Z' character
Posted: Wed Apr 23, 2008 11:12 am
by savis
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
Posted: Wed Apr 23, 2008 11:21 am
by ArndW
Exactly how did you use the Count() function? I would recommend
Posted: Wed Apr 23, 2008 11:53 am
by savis
thanks.. It worked..
Can i replace the '^Z' character with space?
Is there a way to do it?
Posted: Wed Apr 23, 2008 12:00 pm
by umapathi
This could help you...
Convert(Char(26),' ',In.ColumnName)
Posted: Wed Apr 23, 2008 12:05 pm
by JSimon
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
Posted: Wed Apr 23, 2008 12:18 pm
by umapathi
it wl work....
Convert(Char(26),' ',In.ColumnName)
or
Convert(Char(26),Space(1),In.ColumnName)
Posted: Wed Apr 23, 2008 12:55 pm
by savis
Thanks..