=?Utf-8?Q?Import_|_and_=C2=A6_Delimted_Text_Fil?= =?Utf-8?Q?es?=

=?Utf-8?Q?Import_|_and_=C2=A6_Delimted_Text_Fil?= =?Utf-8?Q?es?=

Post by UGV0ZXIgU2 » Mon, 02 Nov 2009 23:01:01


I wish to import a delimited text file where the bar character (|) is used as
the column delimiter and the broken pipe () is used as the record delimiter.
The standard import does not allow you to specify the record delimiter.

The file contains unquoted text that contains punctuation and return
character codes so I can't even do a search and replace on the file prior to
import.

Any suggestions please?
 
 
 

1. =?Utf-8?Q?___Bad_IE7_install_proc?= =?Utf-8?Q?es:_=C2=A1=C2=A1_IE7_IS_ALIVE_!!!?=

2. =?Utf-8?Q?_why_can=C2=B4t_I_open_.doc_and_.w?= =?Utf-8?Q?ps_files_attached_to_email=3F?=

Hi bitla50,

Which version of Office do you use? Meanwhile, try this:

1. Download FileExtInfo.zip from here:
http://www.yqcomputer.com/

2. Unzip the utility and extract the files to Desktop.
3. Double-click "FileExtInfo.exe" to run it.
4. Select ".DOC" from the list box
5. Click "View file association report"
6. Copy the contents of the report and include it in your reply.

--
Regards,

Ramesh Srinivasan, Microsoft MVP [Windows Shell/User]
Windows Troubleshooting http://www.yqcomputer.com/



When I try to open a .doc or a .wps file attached to an email, I get an error
info. When I save the file and try to open it, all is fine. The same used to
be the case with pdf, but that has miraculously repaired itself after an
Adobe-update. I have Vista Home Premium and the email program I use is a
webmail thing. With XP it worked fine and also with another PC I have with
Ultimate and another protetion program. So why not here?Grateful for any
useful tips.

3. =?Utf-8?Q?_ASP_VBScript_insert_/_Update?= =?Utf-8?Q?_and_=C2=A3_sign?=

4. =?Utf-8?Q?installed_sonicencoders.msi_and_?= =?Utf-8?Q?still_can=C2=B4t_burn_DVD?=

5. =?Utf-8?Q?_Talking_about_difficult_thin?= =?Utf-8?Q?gs=C2=A1=C2=A1=C2=A1=C2=A1?=

6. =?Utf-8?Q?_I_don't_understand_classes=C2=A1=C2=A1?= =?Utf-8?Q?=C2=A1=C2=A1?=

7. =?Utf-8?Q?_HOW_TO__install_ax4=C2=A3=C2=BFWHY_ERR?= =?Utf-8?Q?OR=C2=A3=C2=BF?=

8. =?Utf-8?Q?Talking_about_difficult_things=C2=A1=C2=A1?= =?Utf-8?Q?=C2=A1=C2=A1?=

9. =?Utf-8?Q?COMO_PUEDO_ARREGLAR_=C2=B4=C2=B4ERROR_COOD?= =?Utf-8?Q?1177=C2=B4=C2=B4?=

10. =?Utf-8?Q?How_do_I_make_the_symbol_=C2=AE_appea?= =?Utf-8?Q?r_each_time_I_type_word_Realtor=C2=AE?= =?Utf-8?Q?=3F?=

11. =?Utf-8?Q?How_do_I_get_only_nonbreaking_sp?= =?Utf-8?Q?aces_within_french_quotes__=C2=AB__=C2=BB_?= =?Utf-8?Q?=3F?=

12. =?Utf-8?Q?_click_on_the_scroll_bar_in_I?= =?Utf-8?Q?nternet_Explorer_scrolls_1_=C2=BC_to_?= =?Utf-8?Q?1_=C2=BD_screens?=

13. =?Utf-8?Q?_Tablet_PC_Edition_2005_Tutor?= =?Utf-8?Q?ials_for_Microsoft=C2=AE_Windows=C2=AE_XP_?= =?Utf-8?Q?SP2?=

14. =?Utf-8?Q?11292.1_LabelId=C2=B4s_from_Enum_Valu?= =?Utf-8?Q?es?=

15. =?Utf-8?Q?_clients_didn=C2=B4t_receive_patch?= =?Utf-8?Q?es?=