How to remove commas from a downloaded .dat file?
 

hi all,
i my jsp application, i am the data in .dat file format,
it gives a comma(,) after every column in the reacord.
How to remove commas and make a record look like a complete line
without any delimiter?
tia.

How to remove commas from a downloaded .dat file?
 

Are you saying that you do not need any delimiter? If so, load the file
into notepad and do a Find & Replace to change the comma to nothing (or
newline).

Alternatively, rename the file extension to .txt and in Excel use File
| Open and click on the .txt file (select All files *.* in the File
type panel). In the Data Import Wizard that opens automatically, you
will be guided through the process in 3 panels - you can specify comma
as the delimiter, which will put your data into separate columns.

Hope this helps.

Pete

arvind wrote:
hi all,
i my jsp application, i am the data in .dat file format,
it gives a comma(,) after every column in the reacord.
How to remove commas and make a record look like a complete line
without any delimiter?
tia.

How to remove commas from a downloaded .dat file?
 

Please reply to the newsgroups:

arvind wrote in a private email:
thanx for ur suggetion.
but i guess my question was not clear.
i want to download a file which doesn't contain any commas.
i don't want to remove commas after downloading.
i want the file to be downloaded without any comma in it.
i hope the problem is clear.
please check if u can solve it.
thanx.



Pete_UK wrote:
Are you saying that you do not need any delimiter? If so, load the file
into notepad and do a Find & Replace to change the comma to nothing (or
newline).

Alternatively, rename the file extension to .txt and in Excel use File
| Open and click on the .txt file (select All files *.* in the File
type panel). In the Data Import Wizard that opens automatically, you
will be guided through the process in 3 panels - you can specify comma
as the delimiter, which will put your data into separate columns.

Hope this helps.

Pete

arvind wrote:
hi all,
i my jsp application, i am the data in .dat file format,
it gives a comma(,) after every column in the reacord.
How to remove commas and make a record look like a complete line
without any delimiter?
tia.

How to remove commas from a downloaded .dat file?
 

what was that?
Pete_UK wrote:
Please reply to the newsgroups:

arvind wrote in a private email:
thanx for ur suggetion.
but i guess my question was not clear.
i want to download a file which doesn't contain any commas.
i don't want to remove commas after downloading.
i want the file to be downloaded without any comma in it.
i hope the problem is clear.
please check if u can solve it.
thanx.



Pete_UK wrote:
Are you saying that you do not need any delimiter? If so, load the file
into notepad and do a Find & Replace to change the comma to nothing (or
newline).

Alternatively, rename the file extension to .txt and in Excel use File
| Open and click on the .txt file (select All files *.* in the File
type panel). In the Data Import Wizard that opens automatically, you
will be guided through the process in 3 panels - you can specify comma
as the delimiter, which will put your data into separate columns.

Hope this helps.

Pete

arvind wrote:
hi all,
i my jsp application, i am the data in .dat file format,
it gives a comma(,) after every column in the reacord.
How to remove commas and make a record look like a complete line
without any delimiter?
tia.