I am having difficulties on how I can remove all the "\0" (and all other garbage stuffs) in my variable.
Code:
byte[] mybuff = new byte[512]; API_Read(handle, block, mybuff);
Code:
string newStr = Encoding.ASCII.GetString(retbuff);
3 results in 0.0013 seconds.
-
Remove garbage data in byte[]
Hi,
I am having difficulties on how I can remove all the "\0" (and all other garbage stuffs) in my variable.
After calling the API, mybuff will return something that I will convert to string by using this
However,... -
how to use something like left in select statement
I have two tables which have a field, let's call it FORM_TYPE, in which table 1's FORM_TYPE is LA-- and table 2's FORM_TYPE is LA---. Now I want to use a Where clause of Table1.FORM_TYP E = Table2.FROM_TYP E which always fails because of the extra -. I can't go change the database to make them the same. I was trying to use Where Left(Table1.FOR M_TYPE,4) = Left(Table2.FOR M_TYPE,4) so that I was basically stripping off some of the -. But it appears... -
Trim function
hi all..
i have a doubt...how we can remove blank spaces
in a column value while retrieving?
i tried using LTRIM(RTRIM(COL UMN NAME))...
But it's removing only the leading and trailing spaces...
how i can remove spaces in between?
anybody please help...
thanks and regards,
Sand...
