| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
End of Record symbol
I am creating a text file within excel and I do not know how to create what
I think is needed and that is an end of line character for each line. The text is all in column A. The text file that excell creates appears to be different to the model I am using in Notepad at the end of the line. Anyone any experience in this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
End of Record symbol
What method are you using to create the text file?
"Mervyn Thomas" wrote: I am creating a text file within excel and I do not know how to create what I think is needed and that is an end of line character for each line. The text is all in column A. The text file that excell creates appears to be different to the model I am using in Notepad at the end of the line. Anyone any experience in this? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
End of Record symbol
I'm using a concatenate function to draw data from Excel fields and so
including for each record the appropriate field lengths such as the calculation for the first record (all of which is in A1). =UPPER(CONCATENATE("1ROYTEST1.CSV",TEXT(Import!$G$ 1,"00000000"),TEXT(Import!$H$1,"000000"))) I think my problem which occurs when I import this file into a banking sytem is that the overall record length is not determined and the import does not know when the next record starts hence my request for an "end of record" sybol or something. On ther model I have this record appears to be padded with blanks up to 180 characters in all. Hope this explains Mervyn "Patricia Shannon" wrote in message ... What method are you using to create the text file? "Mervyn Thomas" wrote: I am creating a text file within excel and I do not know how to create what I think is needed and that is an end of line character for each line. The text is all in column A. The text file that excell creates appears to be different to the model I am using in Notepad at the end of the line. Anyone any experience in this? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
End of Record symbol
How are you actually getting the info into the text file?
1) Putting the data in an Excel spreadsheet, then doing a Save As to a txt file 2) Print # 3 Write # 4) FileSystemObject TextStream a) Write b) WriteLine or what? "Mervyn Thomas" wrote: I'm using a concatenate function to draw data from Excel fields and so including for each record the appropriate field lengths such as the calculation for the first record (all of which is in A1). =UPPER(CONCATENATE("1ROYTEST1.CSV",TEXT(Import!$G$ 1,"00000000"),TEXT(Import!$H$1,"000000"))) I think my problem which occurs when I import this file into a banking sytem is that the overall record length is not determined and the import does not know when the next record starts hence my request for an "end of record" sybol or something. On ther model I have this record appears to be padded with blanks up to 180 characters in all. Hope this explains Mervyn "Patricia Shannon" wrote in message ... What method are you using to create the text file? "Mervyn Thomas" wrote: I am creating a text file within excel and I do not know how to create what I think is needed and that is an end of line character for each line. The text is all in column A. The text file that excell creates appears to be different to the model I am using in Notepad at the end of the line. Anyone any experience in this? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
End of Record symbol
Also, what is happening that leads you to the conclusion that the end of line
characters are non-standard? Is everything on one line or what? "Mervyn Thomas" wrote: I'm using a concatenate function to draw data from Excel fields and so including for each record the appropriate field lengths such as the calculation for the first record (all of which is in A1). =UPPER(CONCATENATE("1ROYTEST1.CSV",TEXT(Import!$G$ 1,"00000000"),TEXT(Import!$H$1,"000000"))) I think my problem which occurs when I import this file into a banking sytem is that the overall record length is not determined and the import does not know when the next record starts hence my request for an "end of record" sybol or something. On ther model I have this record appears to be padded with blanks up to 180 characters in all. Hope this explains Mervyn "Patricia Shannon" wrote in message ... What method are you using to create the text file? "Mervyn Thomas" wrote: I am creating a text file within excel and I do not know how to create what I think is needed and that is an end of line character for each line. The text is all in column A. The text file that excell creates appears to be different to the model I am using in Notepad at the end of the line. Anyone any experience in this? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
End of Record symbol
Patricia - I am doing a programatic file save with "FileFormat:=xlText"
which I think is the same as Text (Tab delimited) in Excel. The records come as seperate lines when viewed in WordPad but when I do an "edit/select all" the records appear longer than what was defined in the formula and the model I am working to requires a fixed record length of 179. I have tried a user defined function called "RightTab" which in excel does seem to provide a fixed length but the same happens in WordPad - the records are much longer than the 179 defined. Thanks for your patience Mervyn "Patricia Shannon" wrote in message ... Also, what is happening that leads you to the conclusion that the end of line characters are non-standard? Is everything on one line or what? "Mervyn Thomas" wrote: I'm using a concatenate function to draw data from Excel fields and so including for each record the appropriate field lengths such as the calculation for the first record (all of which is in A1). =UPPER(CONCATENATE("1ROYTEST1.CSV",TEXT(Import!$G$ 1,"00000000"),TEXT(Import!$H$1,"000000"))) I think my problem which occurs when I import this file into a banking sytem is that the overall record length is not determined and the import does not know when the next record starts hence my request for an "end of record" sybol or something. On ther model I have this record appears to be padded with blanks up to 180 characters in all. Hope this explains Mervyn "Patricia Shannon" wrote in message ... What method are you using to create the text file? "Mervyn Thomas" wrote: I am creating a text file within excel and I do not know how to create what I think is needed and that is an end of line character for each line. The text is all in column A. The text file that excell creates appears to be different to the model I am using in Notepad at the end of the line. Anyone any experience in this? |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
End of Record symbol
Sorry I haven't replied sooner. I don't have a computer at home. If nobody
else has come up with the answer by then, I'll look at this more closely at lunch and/or after work. "Mervyn Thomas" wrote: Patricia - I am doing a programatic file save with "FileFormat:=xlText" which I think is the same as Text (Tab delimited) in Excel. The records come as seperate lines when viewed in WordPad but when I do an "edit/select all" the records appear longer than what was defined in the formula and the model I am working to requires a fixed record length of 179. I have tried a user defined function called "RightTab" which in excel does seem to provide a fixed length but the same happens in WordPad - the records are much longer than the 179 defined. Thanks for your patience Mervyn "Patricia Shannon" wrote in message ... Also, what is happening that leads you to the conclusion that the end of line characters are non-standard? Is everything on one line or what? "Mervyn Thomas" wrote: I'm using a concatenate function to draw data from Excel fields and so including for each record the appropriate field lengths such as the calculation for the first record (all of which is in A1). =UPPER(CONCATENATE("1ROYTEST1.CSV",TEXT(Import!$G$ 1,"00000000"),TEXT(Import!$H$1,"000000"))) I think my problem which occurs when I import this file into a banking sytem is that the overall record length is not determined and the import does not know when the next record starts hence my request for an "end of record" sybol or something. On ther model I have this record appears to be padded with blanks up to 180 characters in all. Hope this explains Mervyn "Patricia Shannon" wrote in message ... What method are you using to create the text file? "Mervyn Thomas" wrote: I am creating a text file within excel and I do not know how to create what I think is needed and that is an end of line character for each line. The text is all in column A. The text file that excell creates appears to be different to the model I am using in Notepad at the end of the line. Anyone any experience in this? |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
End of Record symbol
Normally, a line will end with CR/LF, i.e., carriage return/line feed
(different for MacIntosh). That would be CHAR(13) & CHAR(10) That might, as you suspect, solve your problem. If not, I'll be looking into it more closely. "Mervyn Thomas" wrote: Patricia - I am doing a programatic file save with "FileFormat:=xlText" which I think is the same as Text (Tab delimited) in Excel. The records come as seperate lines when viewed in WordPad but when I do an "edit/select all" the records appear longer than what was defined in the formula and the model I am working to requires a fixed record length of 179. I have tried a user defined function called "RightTab" which in excel does seem to provide a fixed length but the same happens in WordPad - the records are much longer than the 179 defined. Thanks for your patience Mervyn "Patricia Shannon" wrote in message ... Also, what is happening that leads you to the conclusion that the end of line characters are non-standard? Is everything on one line or what? "Mervyn Thomas" wrote: I'm using a concatenate function to draw data from Excel fields and so including for each record the appropriate field lengths such as the calculation for the first record (all of which is in A1). =UPPER(CONCATENATE("1ROYTEST1.CSV",TEXT(Import!$G$ 1,"00000000"),TEXT(Import!$H$1,"000000"))) I think my problem which occurs when I import this file into a banking sytem is that the overall record length is not determined and the import does not know when the next record starts hence my request for an "end of record" sybol or something. On ther model I have this record appears to be padded with blanks up to 180 characters in all. Hope this explains Mervyn "Patricia Shannon" wrote in message ... What method are you using to create the text file? "Mervyn Thomas" wrote: I am creating a text file within excel and I do not know how to create what I think is needed and that is an end of line character for each line. The text is all in column A. The text file that excell creates appears to be different to the model I am using in Notepad at the end of the line. Anyone any experience in this? |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
End of Record symbol
Mervyn,
If you are just doing a .SaveAs as a text file from Excel, it will take of that for you. As long as you are not looking to export this to a UNIX/Mac system, it not a problem. If you are using something like "Open MyFile For Output..", then it depends how you are doing it. NickHK "Mervyn Thomas" wrote in message ... I am creating a text file within excel and I do not know how to create what I think is needed and that is an end of line character for each line. The text is all in column A. The text file that excell creates appears to be different to the model I am using in Notepad at the end of the line. Anyone any experience in this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Type a symbol useing shortcut keys rather the insert a symbol | Excel Discussion (Misc queries) | |||
| Open new record with selected fields from previous record | Excel Discussion (Misc queries) | |||
| Euro symbol displays as dollar symbol in Excel | Excel Worksheet Functions | |||
| I need a symbol but "symbol" in the Insert menu is grayed-out. | Excel Discussion (Misc queries) | |||
| Record Macro - Record custom user actions | Excel Programming | |||
Hybrid Mode
