473,696 Members | 1,989 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

convert nulls to spaces in file

first question... I have a flat file which unfortinuatly has columns
seperated by nulls instead of spaces (a higher up company created it this
way for us) is there anyway to do a readline with this and not have it
affected by the null? because it is right now causes truncated data at wierd
places... but as soon as i manually with a hex editor change char(00) to
char(20) in the files it reads prerfectly... which leads me to my 2nd
question... if you cant do what i said in the 1st question, is there a way
to go through the file, convert the nulls to spaces and save it back then
open it as a stream reader to read it line by line? the lines are delimited
by CR+LF's thanks!
Nov 21 '05 #1
12 2976
Brian,
I would simply open it with a System.IO.FileS tream, read a buffer full of
bytes, change the null bytes to AscW(" "c) then write the buffer to a second
FileStream.

Something like:

Imports System.IO

Dim input As New FileStream("inp ut.txt", FileMode.Open)
Dim output As New FileStream("out put.txt", FileMode.Create )

Dim buffer(1023) As Byte
Dim length As Integer
Do
length = input.Read(buff er, 0, buffer.Length)
For index As Integer = 0 To length - 1
If buffer(index) = 0 Then
buffer(index) = AscW(" "c)
End If
Next
output.Write(bu ffer, 0, length)
Loop Until length < buffer.Length
input.Close()
output.Close()

Note the above may not work correctly for non Ansi 8-bit encodings, however
it should be easy enough to adapt.

Hope this helps
Jay
"Brian Henry" <br**********@n ewsgroups.nospa m> wrote in message
news:eD******** *****@TK2MSFTNG P15.phx.gbl...
first question... I have a flat file which unfortinuatly has columns
seperated by nulls instead of spaces (a higher up company created it this
way for us) is there anyway to do a readline with this and not have it
affected by the null? because it is right now causes truncated data at
wierd places... but as soon as i manually with a hex editor change
char(00) to char(20) in the files it reads prerfectly... which leads me to
my 2nd question... if you cant do what i said in the 1st question, is
there a way to go through the file, convert the nulls to spaces and save
it back then open it as a stream reader to read it line by line? the lines
are delimited by CR+LF's thanks!

Nov 21 '05 #2
forgot to say the test data is in the text file attached

"Brian Henry" <br**********@n ewsgroups.nospa m> wrote in message
news:%2******** ********@TK2MSF TNGP15.phx.gbl. ..
here is some test data where this works... its meaningless data but it
shows the point... and here is the code i used to read it
What it does that it shouldnt do is instead of reading this whole line..

456456456456456 456 100 156454541
02/20/1955FDFHGEL R OCONFGG MGK
K40 09/04/2004 00 Y48/17/1982

it will read only this
456456456456456 456 100
then stop completely for that line and move to the next line and do the
same thing! the first line wont even read any data (has no inital text
only null values until the 000)... as soon as a i replace those ASCII
Char(00) [null]'s with spaces ASCII Char(20) it works perfectly!... any
ways to get around this? thanks
If IO.File.Exists( Me.txtFileName. Text.Trim) Then

Me.lblStatus.Te xt = "File exists... Trying to open..."

' we have a file, try to open it now

Dim fs As New IO.FileStream(M e.txtFileName.T ext, IO.FileMode.Ope n,
IO.FileAccess.R ead)

Dim sr As New IO.StreamReader (fs, True)

Me.lblStatus.Te xt = "File opened..."

Do Until sr.Peek = -1

debug.writeline (sr.ReadLine)

Loop

sr.Close()

End If

Nov 21 '05 #3
Hrm, how about read in the file to a string and do a split with the null
char being the delimiter? I haven't tried it and don't know if it will
work...but what the heck, worth a try eh?

Mythran

"Jay B. Harlow [MVP - Outlook]" <Ja************ @msn.com> wrote in message
news:O$******** ******@TK2MSFTN GP11.phx.gbl...
Brian,
I would simply open it with a System.IO.FileS tream, read a buffer full of
bytes, change the null bytes to AscW(" "c) then write the buffer to a
second FileStream.

Something like:

Imports System.IO

Dim input As New FileStream("inp ut.txt", FileMode.Open)
Dim output As New FileStream("out put.txt", FileMode.Create )

Dim buffer(1023) As Byte
Dim length As Integer
Do
length = input.Read(buff er, 0, buffer.Length)
For index As Integer = 0 To length - 1
If buffer(index) = 0 Then
buffer(index) = AscW(" "c)
End If
Next
output.Write(bu ffer, 0, length)
Loop Until length < buffer.Length
input.Close()
output.Close()

Note the above may not work correctly for non Ansi 8-bit encodings,
however it should be easy enough to adapt.

Hope this helps
Jay
"Brian Henry" <br**********@n ewsgroups.nospa m> wrote in message
news:eD******** *****@TK2MSFTNG P15.phx.gbl...
first question... I have a flat file which unfortinuatly has columns
seperated by nulls instead of spaces (a higher up company created it this
way for us) is there anyway to do a readline with this and not have it
affected by the null? because it is right now causes truncated data at
wierd places... but as soon as i manually with a hex editor change
char(00) to char(20) in the files it reads prerfectly... which leads me
to my 2nd question... if you cant do what i said in the 1st question, is
there a way to go through the file, convert the nulls to spaces and save
it back then open it as a stream reader to read it line by line? the
lines are delimited by CR+LF's thanks!


Nov 21 '05 #4
Mythran,
Brian (the original poster) stated:
because it is right now causes truncated data at wierd places...

Which leads me to believe something strange is going on with the encoding
when you attempt to read the file into a string (an encoding is required).
There may not be, or it may be something simple, why risk it, when I know
the FileStream won't cause problems, especially on the sample file he
provided...
Reading it as bytes with FileStream will not involve any Encoding objects. I
am reading pure bytes, changing pure bytes, writing pure bytes. Hence I
won't be taking time to track down any potential encoding problems implied
with the Brian's statement.

Hope this helps
Jay

"Mythran" <ki********@hot mail.comREMOVET RAIL> wrote in message
news:et******** ******@TK2MSFTN GP09.phx.gbl... Hrm, how about read in the file to a string and do a split with the null
char being the delimiter? I haven't tried it and don't know if it will
work...but what the heck, worth a try eh?

Mythran

"Jay B. Harlow [MVP - Outlook]" <Ja************ @msn.com> wrote in message
news:O$******** ******@TK2MSFTN GP11.phx.gbl...
Brian,
I would simply open it with a System.IO.FileS tream, read a buffer full of
bytes, change the null bytes to AscW(" "c) then write the buffer to a
second FileStream.

Something like:

Imports System.IO

Dim input As New FileStream("inp ut.txt", FileMode.Open)
Dim output As New FileStream("out put.txt", FileMode.Create )

Dim buffer(1023) As Byte
Dim length As Integer
Do
length = input.Read(buff er, 0, buffer.Length)
For index As Integer = 0 To length - 1
If buffer(index) = 0 Then
buffer(index) = AscW(" "c)
End If
Next
output.Write(bu ffer, 0, length)
Loop Until length < buffer.Length
input.Close()
output.Close()

Note the above may not work correctly for non Ansi 8-bit encodings,
however it should be easy enough to adapt.

Hope this helps
Jay
"Brian Henry" <br**********@n ewsgroups.nospa m> wrote in message
news:eD******** *****@TK2MSFTNG P15.phx.gbl...
first question... I have a flat file which unfortinuatly has columns
seperated by nulls instead of spaces (a higher up company created it
this way for us) is there anyway to do a readline with this and not have
it affected by the null? because it is right now causes truncated data
at wierd places... but as soon as i manually with a hex editor change
char(00) to char(20) in the files it reads prerfectly... which leads me
to my 2nd question... if you cant do what i said in the 1st question, is
there a way to go through the file, convert the nulls to spaces and save
it back then open it as a stream reader to read it line by line? the
lines are delimited by CR+LF's thanks!



Nov 21 '05 #5
Yes, your way would work...maybe even better...

What I was stating is that he reads it all into a string instead of line by
line (regardless of how he reads it in....such as FileStream or whatever).
Then he just splits the results based on the Null...but my way may not work
anyways because the Split method may not accept DBNull.Value... .but it may
take Chr(x). Hrm, probably would just do it your way if it was me :P

Mythran
"Jay B. Harlow [MVP - Outlook]" <Ja************ @msn.com> wrote in message
news:%2******** ********@TK2MSF TNGP14.phx.gbl. ..
Mythran,
Brian (the original poster) stated:
because it is right now causes truncated data at wierd places...


Which leads me to believe something strange is going on with the encoding
when you attempt to read the file into a string (an encoding is required).
There may not be, or it may be something simple, why risk it, when I know
the FileStream won't cause problems, especially on the sample file he
provided...
Reading it as bytes with FileStream will not involve any Encoding objects.
I am reading pure bytes, changing pure bytes, writing pure bytes. Hence I
won't be taking time to track down any potential encoding problems implied
with the Brian's statement.

Hope this helps
Jay

"Mythran" <ki********@hot mail.comREMOVET RAIL> wrote in message
news:et******** ******@TK2MSFTN GP09.phx.gbl...
Hrm, how about read in the file to a string and do a split with the null
char being the delimiter? I haven't tried it and don't know if it will
work...but what the heck, worth a try eh?

Mythran

"Jay B. Harlow [MVP - Outlook]" <Ja************ @msn.com> wrote in message
news:O$******** ******@TK2MSFTN GP11.phx.gbl...
Brian,
I would simply open it with a System.IO.FileS tream, read a buffer full
of bytes, change the null bytes to AscW(" "c) then write the buffer to a
second FileStream.

Something like:

Imports System.IO

Dim input As New FileStream("inp ut.txt", FileMode.Open)
Dim output As New FileStream("out put.txt", FileMode.Create )

Dim buffer(1023) As Byte
Dim length As Integer
Do
length = input.Read(buff er, 0, buffer.Length)
For index As Integer = 0 To length - 1
If buffer(index) = 0 Then
buffer(index) = AscW(" "c)
End If
Next
output.Write(bu ffer, 0, length)
Loop Until length < buffer.Length
input.Close()
output.Close()

Note the above may not work correctly for non Ansi 8-bit encodings,
however it should be easy enough to adapt.

Hope this helps
Jay
"Brian Henry" <br**********@n ewsgroups.nospa m> wrote in message
news:eD******** *****@TK2MSFTNG P15.phx.gbl...
first question... I have a flat file which unfortinuatly has columns
seperated by nulls instead of spaces (a higher up company created it
this way for us) is there anyway to do a readline with this and not
have it affected by the null? because it is right now causes truncated
data at wierd places... but as soon as i manually with a hex editor
change char(00) to char(20) in the files it reads prerfectly... which
leads me to my 2nd question... if you cant do what i said in the 1st
question, is there a way to go through the file, convert the nulls to
spaces and save it back then open it as a stream reader to read it line
by line? the lines are delimited by CR+LF's thanks!



Nov 21 '05 #6
Mythran,
Brian is referring to a Null Char (ChrW(0)).

If you look at the file he attached to one of his messages the file is fixed
length records. The first couple of records have 20 or 30 zero bytes at the
start of the line.

The ChrW(0) are not being used for record or field delimiters per se.

I would use the Split method if the file was using ChrW(0) for record or
field delimiters.
What I was stating is that he reads it all into a string instead of line
by line (regardless of how he reads it in....such as FileStream or
whatever). FileStream cannot read a file into a string, it only reads Bytes. To read a
file into an System.Text.Enc oding object is needed, as System.Text.Enc oding
is used to convert the bytes in the file to Unicode which is what Strings
are. StreamReader uses an Encoding object to convert the bytes to a String,
if you use a FileStream you would need to create your own Encoding object &
use it to convert the bytes into a String. As I stated Brian's original
statement suggested that the Encoding object may have been having problems
with the 20 or 30 zero bytes...

Hope this helps
Jay

"Mythran" <ki********@hot mail.comREMOVET RAIL> wrote in message
news:us******** ******@TK2MSFTN GP10.phx.gbl... Yes, your way would work...maybe even better...

What I was stating is that he reads it all into a string instead of line
by line (regardless of how he reads it in....such as FileStream or
whatever). Then he just splits the results based on the Null...but my way
may not work anyways because the Split method may not accept
DBNull.Value... .but it may take Chr(x). Hrm, probably would just do it
your way if it was me :P

Mythran
"Jay B. Harlow [MVP - Outlook]" <Ja************ @msn.com> wrote in message
news:%2******** ********@TK2MSF TNGP14.phx.gbl. ..
Mythran,
Brian (the original poster) stated:
> because it is right now causes truncated data at wierd places...


Which leads me to believe something strange is going on with the encoding
when you attempt to read the file into a string (an encoding is
required). There may not be, or it may be something simple, why risk it,
when I know the FileStream won't cause problems, especially on the sample
file he provided...
Reading it as bytes with FileStream will not involve any Encoding
objects. I am reading pure bytes, changing pure bytes, writing pure
bytes. Hence I won't be taking time to track down any potential encoding
problems implied with the Brian's statement.

Hope this helps
Jay

"Mythran" <ki********@hot mail.comREMOVET RAIL> wrote in message
news:et******** ******@TK2MSFTN GP09.phx.gbl...
Hrm, how about read in the file to a string and do a split with the null
char being the delimiter? I haven't tried it and don't know if it will
work...but what the heck, worth a try eh?

Mythran

"Jay B. Harlow [MVP - Outlook]" <Ja************ @msn.com> wrote in
message news:O$******** ******@TK2MSFTN GP11.phx.gbl...
Brian,
I would simply open it with a System.IO.FileS tream, read a buffer full
of bytes, change the null bytes to AscW(" "c) then write the buffer to
a second FileStream.

Something like:

Imports System.IO

Dim input As New FileStream("inp ut.txt", FileMode.Open)
Dim output As New FileStream("out put.txt", FileMode.Create )

Dim buffer(1023) As Byte
Dim length As Integer
Do
length = input.Read(buff er, 0, buffer.Length)
For index As Integer = 0 To length - 1
If buffer(index) = 0 Then
buffer(index) = AscW(" "c)
End If
Next
output.Write(bu ffer, 0, length)
Loop Until length < buffer.Length
input.Close()
output.Close()

Note the above may not work correctly for non Ansi 8-bit encodings,
however it should be easy enough to adapt.

Hope this helps
Jay
"Brian Henry" <br**********@n ewsgroups.nospa m> wrote in message
news:eD******** *****@TK2MSFTNG P15.phx.gbl...
> first question... I have a flat file which unfortinuatly has columns
> seperated by nulls instead of spaces (a higher up company created it
> this way for us) is there anyway to do a readline with this and not
> have it affected by the null? because it is right now causes truncated
> data at wierd places... but as soon as i manually with a hex editor
> change char(00) to char(20) in the files it reads prerfectly... which
> leads me to my 2nd question... if you cant do what i said in the 1st
> question, is there a way to go through the file, convert the nulls to
> spaces and save it back then open it as a stream reader to read it
> line by line? the lines are delimited by CR+LF's thanks!
>



Nov 21 '05 #7
On Thu, 21 Oct 2004 14:48:52 -0400, Brian Henry wrote:
What it does that it shouldnt do is instead of reading this whole line..
then stop completely for that line and move to the next line and do the same


I don't think you have an error. I think the problem is with
Debug.WriteLine . It does not properly deal with zero bytes in the string.
If you add a watch and inspect the length of the string, does it show the
correct length for the string?

I used the code below on your file and even though Debug.WriteLine could
not display the string correctly, the length of the string was correct for
the line read in and the output file was identical to the input file. I
think you are experiencing a bug in Debug.WriteLine .


Dim fs As New FileStream("tes t.txt", FileMode.Open, FileAccess.Read )
Dim sr As New StreamReader(fs , True)

Dim sw As New StreamWriter("t estout.txt")

Dim sBuf As String

Do Until sr.Peek() = -1
sBuf = sr.ReadLine
Debug.WriteLine (sBuf)
Debug.WriteLine (vbCrLf)
Debug.WriteLine (sBuf.Length.To String)
sw.WriteLine(sB uf)
Loop

sr.Close()
fs.Close()

sw.Close()

--
Chris

dunawayc[AT]sbcglobal_lunch meat_[DOT]net

To send me an E-mail, remove the "[", "]", underscores ,lunchmeat, and
replace certain words in my E-Mail address.
Nov 21 '05 #8
Ahh, didn't look at the file...but according to his first post, the columns
are separated by Null. Which I read as "ROWS" separated by NULL...so
scratch everything I've said in this thread...

Sometimes you just have to NOT listen to me at all :P

Mythran
"Jay B. Harlow [MVP - Outlook]" <Ja************ @msn.com> wrote in message
news:O7******** ******@TK2MSFTN GP12.phx.gbl...
Mythran,
Brian is referring to a Null Char (ChrW(0)).

If you look at the file he attached to one of his messages the file is
fixed length records. The first couple of records have 20 or 30 zero bytes
at the start of the line.

The ChrW(0) are not being used for record or field delimiters per se.

I would use the Split method if the file was using ChrW(0) for record or
field delimiters.
What I was stating is that he reads it all into a string instead of line
by line (regardless of how he reads it in....such as FileStream or
whatever).

FileStream cannot read a file into a string, it only reads Bytes. To read
a file into an System.Text.Enc oding object is needed, as
System.Text.Enc oding is used to convert the bytes in the file to Unicode
which is what Strings are. StreamReader uses an Encoding object to convert
the bytes to a String, if you use a FileStream you would need to create
your own Encoding object & use it to convert the bytes into a String. As I
stated Brian's original statement suggested that the Encoding object may
have been having problems with the 20 or 30 zero bytes...

Hope this helps
Jay

"Mythran" <ki********@hot mail.comREMOVET RAIL> wrote in message
news:us******** ******@TK2MSFTN GP10.phx.gbl...
Yes, your way would work...maybe even better...

What I was stating is that he reads it all into a string instead of line
by line (regardless of how he reads it in....such as FileStream or
whatever). Then he just splits the results based on the Null...but my way
may not work anyways because the Split method may not accept
DBNull.Value... .but it may take Chr(x). Hrm, probably would just do it
your way if it was me :P

Mythran
"Jay B. Harlow [MVP - Outlook]" <Ja************ @msn.com> wrote in message
news:%2******** ********@TK2MSF TNGP14.phx.gbl. ..
Mythran,
Brian (the original poster) stated:
>> because it is right now causes truncated data at wierd places...

Which leads me to believe something strange is going on with the
encoding when you attempt to read the file into a string (an encoding is
required). There may not be, or it may be something simple, why risk it,
when I know the FileStream won't cause problems, especially on the
sample file he provided...
Reading it as bytes with FileStream will not involve any Encoding
objects. I am reading pure bytes, changing pure bytes, writing pure
bytes. Hence I won't be taking time to track down any potential encoding
problems implied with the Brian's statement.

Hope this helps
Jay

"Mythran" <ki********@hot mail.comREMOVET RAIL> wrote in message
news:et******** ******@TK2MSFTN GP09.phx.gbl...
Hrm, how about read in the file to a string and do a split with the
null char being the delimiter? I haven't tried it and don't know if it
will work...but what the heck, worth a try eh?

Mythran

"Jay B. Harlow [MVP - Outlook]" <Ja************ @msn.com> wrote in
message news:O$******** ******@TK2MSFTN GP11.phx.gbl...
> Brian,
> I would simply open it with a System.IO.FileS tream, read a buffer full
> of bytes, change the null bytes to AscW(" "c) then write the buffer to
> a second FileStream.
>
> Something like:
>
> Imports System.IO
>
> Dim input As New FileStream("inp ut.txt", FileMode.Open)
> Dim output As New FileStream("out put.txt", FileMode.Create )
>
> Dim buffer(1023) As Byte
> Dim length As Integer
> Do
> length = input.Read(buff er, 0, buffer.Length)
> For index As Integer = 0 To length - 1
> If buffer(index) = 0 Then
> buffer(index) = AscW(" "c)
> End If
> Next
> output.Write(bu ffer, 0, length)
> Loop Until length < buffer.Length
> input.Close()
> output.Close()
>
> Note the above may not work correctly for non Ansi 8-bit encodings,
> however it should be easy enough to adapt.
>
> Hope this helps
> Jay
>
>
> "Brian Henry" <br**********@n ewsgroups.nospa m> wrote in message
> news:eD******** *****@TK2MSFTNG P15.phx.gbl...
>> first question... I have a flat file which unfortinuatly has columns
>> seperated by nulls instead of spaces (a higher up company created it
>> this way for us) is there anyway to do a readline with this and not
>> have it affected by the null? because it is right now causes
>> truncated data at wierd places... but as soon as i manually with a
>> hex editor change char(00) to char(20) in the files it reads
>> prerfectly... which leads me to my 2nd question... if you cant do
>> what i said in the 1st question, is there a way to go through the
>> file, convert the nulls to spaces and save it back then open it as a
>> stream reader to read it line by line? the lines are delimited by
>> CR+LF's thanks!
>>
>
>



Nov 21 '05 #9
Chris,
Ah! yes the Debug.Writeline doesn't like ChrW(0)...

Actually its the Marshaling class that treats the ChrW(0) in the string as a
string terminator.

Good point...

Jay

"Chris Dunaway" <"dunawayc[[at]_lunchmeat_sbcg lobal[dot]]net"> wrote in
message news:1a******** *************** ******@40tude.n et...
On Thu, 21 Oct 2004 14:48:52 -0400, Brian Henry wrote:
What it does that it shouldnt do is instead of reading this whole line..
then stop completely for that line and move to the next line and do the
same


I don't think you have an error. I think the problem is with
Debug.WriteLine . It does not properly deal with zero bytes in the string.
If you add a watch and inspect the length of the string, does it show the
correct length for the string?

I used the code below on your file and even though Debug.WriteLine could
not display the string correctly, the length of the string was correct for
the line read in and the output file was identical to the input file. I
think you are experiencing a bug in Debug.WriteLine .


Dim fs As New FileStream("tes t.txt", FileMode.Open, FileAccess.Read )
Dim sr As New StreamReader(fs , True)

Dim sw As New StreamWriter("t estout.txt")

Dim sBuf As String

Do Until sr.Peek() = -1
sBuf = sr.ReadLine
Debug.WriteLine (sBuf)
Debug.WriteLine (vbCrLf)
Debug.WriteLine (sBuf.Length.To String)
sw.WriteLine(sB uf)
Loop

sr.Close()
fs.Close()

sw.Close()

--
Chris

dunawayc[AT]sbcglobal_lunch meat_[DOT]net

To send me an E-mail, remove the "[", "]", underscores ,lunchmeat, and
replace certain words in my E-Mail address.

Nov 21 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
3628
by: Eric Lilja | last post by:
Hello, I've made a templated class Option (a child of the abstract base class OptionBase) that stores an option name (in the form someoption=) and the value belonging to that option. The value is of the type the object is instantiated with. In my test program I have Option<std::string> and Option<long>. Here's the code for OptionBase and Option along with a small helper function. In the code are comments describing my problem, look closely...
3
2842
by: craig.wagner | last post by:
I've got an application that is calling a command-line executable. The command-line tool uses stdin and stdout as its interface, and it expects a binary stream in and sends a binary stream out. I have the calling side working and am capturing the return value into a MemoryStream. Now I'm breaking up the MemoryStream into structures. Some of the values coming back are character arrays which I want to turn into strings. They are not...
3
7399
by: Thom | last post by:
I'm trying to use shell to execute an old dos based program. This program takes a binary file and does internal processing and then outputs a text file based on the processing. I am choking on the spaces in the valid pathnames. Any ideas on how to convert from the long file name format to an 8.3 format? Thank you for any help. Thom
2
8544
by: noopathan | last post by:
Hi experts , I have an excel file in the below format --------------------------------------------------------------------- CodeID CodeName Market Name Date -------------------------------------------------------------------- 1 Sample1 Market1 22/2/2004 -------------------------------------------------------------------- 2 Sample2 Market2 22/2/2003
15
8060
by: angellian | last post by:
Sorry to raise a stupid question but I tried many methods which did work. how can I conserve the initial zero when I try to convert STR(06) into string in SQL statment? It always gives me 6 instead of 06. Thanks a lot.
6
1858
by: othellomy | last post by:
create table t1(c1 int, c2 varchar(10)) insert t1 values(1,'Hello') insert t1 values(2,'') insert t1 values(3,NULL) select * from t1 c1 c2 1 Hello
6
5450
by: Cliff72 | last post by:
I need to fill in the nulls in the batch field the value from the record immediately preceding the null one ie replace the nulls with the preceding value until I hit a record with a value in it--then hold the next value through the next set of nulls, and so on. See example below: I wanna copy down batch "IMR138" in record ID 1, all the way to ID 10. Then copy down batch "7138" all the way to ID 20 and so on....
5
2729
by: bobh | last post by:
Hi All, I have this query which updates a field based on the result of an IIF statement. The table is on SQLServer and I'm linked to it and it has many records and will take Access a very long time to run so I'm thinking I can make this query a pass-thru query and I hope someone can write the proper SQLServer SQL for this Access SQL I know I have to change the IIF to Case When Else but I haven't been able to get it figured out yet.
12
4957
by: aatif | last post by:
I want to convert a string of hex characters (2 hex chars = 1 byte), to ASCII. Hex chars include zeros (0x00) as well, which I want to include in ASCII string. hex string: 5000005355.... ASCII: P<null><null>SU... I can do it and the string length also includes nulls but when I concatenate other string, it doesn't show as its part. string HexValue = "500000535500";
0
8666
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8597
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9145
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8880
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7703
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6515
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5857
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4356
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
2319
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.