Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove previous file reference | Excel Discussion (Misc queries) | |||
I have downloaded a .xls document I cant open need file extension | Excel Discussion (Misc queries) | |||
how to remove print option in a particular excel file | Excel Discussion (Misc queries) | |||
canot remove command from FILE MENU | Excel Discussion (Misc queries) | |||
How to remove an Excel Main Menu item inserted by .xla file | Excel Discussion (Misc queries) |