| blob | 6107cac36bb7252a9e84690d6d7bd7afef875c59 |
5 <!--
6 ***********************************************************************
7 *
8 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
9 *
10 * Copyright 2008 by Sun Microsystems, Inc.
11 *
12 * OpenOffice.org - a multi-platform office productivity suite
13 *
14 * $RCSfile: 00000208.xhp,v $
15 * $Revision: 1.6 $
16 *
17 * This file is part of OpenOffice.org.
18 *
19 * OpenOffice.org is free software: you can redistribute it and/or modify
20 * it under the terms of the GNU Lesser General Public License version 3
21 * only, as published by the Free Software Foundation.
22 *
23 * OpenOffice.org is distributed in the hope that it will be useful,
24 * but WITHOUT ANY WARRANTY; without even the implied warranty of
25 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
26 * GNU Lesser General Public License version 3 for more details
27 * (a copy is included in the LICENSE file that accompanied this code).
28 *
29 * You should have received a copy of the GNU Lesser General Public License
30 * version 3 along with OpenOffice.org. If not, see
31 * <http://www.openoffice.org/license.html>
32 * for a copy of the LGPLv3 License.
33 *
34 ************************************************************************
35 -->
39 <meta>
43 </topic>
44 </meta>
45 <body>
46 <bookmark xml-lang="en-US" branch="hid/SC:MODALDIALOG:RID_SCDLG_ASCII" id="bm_id3148919" localize="false"/><paragraph role="heading" id="hd_id3150960" xml-lang="en-US" level="1" l10n="U" oldref="1">Text Import</paragraph>
47 <paragraph role="paragraph" id="par_id3149987" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid="SC:MODALDIALOG:RID_SCDLG_ASCII">Sets the import options for delimited data.</ahelp></paragraph>
50 </section>
54 </case>
55 </switch>
56 <paragraph role="heading" id="hd_id3147588" xml-lang="en-US" level="2" l10n="U" oldref="45">Import</paragraph>
57 <bookmark xml-lang="en-US" branch="hid/SC:LISTBOX:RID_SCDLG_ASCII:LB_CHARSET" id="bm_id3155934" localize="false"/><paragraph role="heading" id="hd_id3154788" xml-lang="en-US" level="3" l10n="U" oldref="9">Character Set</paragraph>
58 <paragraph role="paragraph" id="par_id3149495" xml-lang="en-US" l10n="U" oldref="10"><ahelp hid="SC:LISTBOX:RID_SCDLG_ASCII:LB_CHARSET">Specifies the character set to be used in the imported file.</ahelp></paragraph>
59 <bookmark xml-lang="en-US" branch="hid/SC:NUMERICFIELD:RID_SCDLG_ASCII:NF_AT_ROW" id="bm_id3153377" localize="false"/><paragraph role="heading" id="hd_id3154894" xml-lang="en-US" level="3" l10n="U" oldref="47">From Row</paragraph>
60 <paragraph role="paragraph" id="par_id3150247" xml-lang="en-US" l10n="U" oldref="48"><ahelp hid="SC:NUMERICFIELD:RID_SCDLG_ASCII:NF_AT_ROW">Specifies the row where you want to start the import.</ahelp> The rows are visible in the preview window at the bottom of the dialog.</paragraph>
61 <paragraph role="heading" id="hd_id3149999" xml-lang="en-US" level="2" l10n="U" oldref="3">Separator Options</paragraph>
62 <paragraph role="paragraph" id="par_id3149640" xml-lang="en-US" l10n="U" oldref="4">Specifies whether your data uses separators or fixed widths as delimiters.</paragraph>
63 <bookmark xml-lang="en-US" branch="hid/SC:RADIOBUTTON:RID_SCDLG_ASCII:RB_FIXED" id="bm_id3153894" localize="false"/><paragraph role="heading" id="hd_id3156553" xml-lang="en-US" level="3" l10n="U" oldref="7">Fixed width</paragraph>
64 <paragraph role="paragraph" id="par_id3150710" xml-lang="en-US" l10n="U" oldref="8"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_ASCII:RB_FIXED">Separates fixed-width data (equal number of characters) into columns.</ahelp> Click on the ruler in the preview window to set the width.</paragraph>
65 <bookmark xml-lang="en-US" branch="hid/SC:RADIOBUTTON:RID_SCDLG_ASCII:RB_SEPARATED" id="bm_id3147043" localize="false"/><paragraph role="heading" id="hd_id3156560" xml-lang="en-US" level="3" l10n="U" oldref="5">Separated by</paragraph>
66 <paragraph role="paragraph" id="par_id3145136" xml-lang="en-US" l10n="U" oldref="6"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_ASCII:RB_SEPARATED">Select the separator used in your data.</ahelp></paragraph>
67 <bookmark xml-lang="en-US" branch="hid/SC:CHECKBOX:RID_SCDLG_ASCII:CKB_TAB" id="bm_id3153345" localize="false"/><paragraph role="heading" id="hd_id3147250" xml-lang="en-US" level="3" l10n="U" oldref="49">Tab</paragraph>
68 <paragraph role="paragraph" id="par_id3147576" xml-lang="en-US" l10n="U" oldref="50"><ahelp hid="SC:CHECKBOX:RID_SCDLG_ASCII:CKB_TAB">Separates data delimited by tabs into columns.</ahelp></paragraph>
69 <bookmark xml-lang="en-US" branch="hid/SC:CHECKBOX:RID_SCDLG_ASCII:CKB_SEMICOLON" id="bm_id3157959" localize="false"/><paragraph role="heading" id="hd_id3154317" xml-lang="en-US" level="3" l10n="U" oldref="51">Semicolon</paragraph>
70 <paragraph role="paragraph" id="par_id3157863" xml-lang="en-US" l10n="U" oldref="52"><ahelp hid="SC:CHECKBOX:RID_SCDLG_ASCII:CKB_SEMICOLON">Separates data delimited by semicolons into columns.</ahelp></paragraph>
71 <bookmark xml-lang="en-US" branch="hid/SC:CHECKBOX:RID_SCDLG_ASCII:CKB_COMMA" id="bm_id3147089" localize="false"/><paragraph role="heading" id="hd_id3145313" xml-lang="en-US" level="3" l10n="U" oldref="53">Comma</paragraph>
72 <paragraph role="paragraph" id="par_id3150693" xml-lang="en-US" l10n="U" oldref="54"><ahelp hid="SC:CHECKBOX:RID_SCDLG_ASCII:CKB_COMMA">Separates data delimited by commas into columns.</ahelp></paragraph>
73 <bookmark xml-lang="en-US" branch="hid/SC:CHECKBOX:RID_SCDLG_ASCII:CKB_SPACE" id="bm_id3109848" localize="false"/><paragraph role="heading" id="hd_id3163802" xml-lang="en-US" level="3" l10n="U" oldref="55">Space</paragraph>
74 <paragraph role="paragraph" id="par_id3153663" xml-lang="en-US" l10n="U" oldref="56"><ahelp hid="SC:CHECKBOX:RID_SCDLG_ASCII:CKB_SPACE">Separates data delimited by spaces into columns.</ahelp></paragraph>
75 <bookmark xml-lang="en-US" branch="hid/SC:CHECKBOX:RID_SCDLG_ASCII:CKB_OTHER" id="bm_id3149098" localize="false"/>
76 <bookmark xml-lang="en-US" branch="hid/SC:EDIT:RID_SCDLG_ASCII:ED_OTHER" id="bm_id3149801" localize="false"/><paragraph role="heading" id="hd_id3147335" xml-lang="en-US" level="3" l10n="U" oldref="57">Other</paragraph>
77 <paragraph role="paragraph" id="par_id3156329" xml-lang="en-US" l10n="U" oldref="58"><ahelp hid="SC:EDIT:RID_SCDLG_ASCII:ED_OTHER">Separates data into columns using the custom separator that you specify. Note: The custom separator must also be contained in your data.</ahelp></paragraph>
78 <bookmark xml-lang="en-US" branch="hid/SC:CHECKBOX:RID_SCDLG_ASCII:CB_ASONCE" id="bm_id3146807" localize="false"/><paragraph role="heading" id="hd_id3150978" xml-lang="en-US" level="3" l10n="U" oldref="59">Merge delimiters</paragraph>
79 <paragraph role="paragraph" id="par_id3153827" xml-lang="en-US" l10n="U" oldref="60"><ahelp hid="SC:CHECKBOX:RID_SCDLG_ASCII:CB_ASONCE">Combines consecutive delimiters and removes blank data fields.</ahelp></paragraph>
80 <bookmark xml-lang="en-US" branch="hid/SC:COMBOBOX:RID_SCDLG_ASCII:CB_TEXTSEP" id="bm_id3147619" localize="false"/><paragraph role="heading" id="hd_id3155341" xml-lang="en-US" level="3" l10n="U" oldref="15">Text delimiter</paragraph>
81 <paragraph role="paragraph" id="par_id3156326" xml-lang="en-US" l10n="CHG" oldref="16"><ahelp hid="SC:COMBOBOX:RID_SCDLG_ASCII:CB_TEXTSEP">Select a character to delimit text data. You can can also enter a character in the text box.</ahelp></paragraph>
82 <paragraph role="heading" id="hd_id3155388" xml-lang="en-US" level="2" l10n="U" oldref="61">Fields</paragraph>
83 <paragraph role="paragraph" id="par_id3153665" xml-lang="en-US" l10n="U" oldref="62">Shows how your data will look when it is separated into columns.</paragraph>
84 <bookmark xml-lang="en-US" branch="hid/SC:LISTBOX:RID_SCDLG_ASCII:LB_TYPE1" id="bm_id3157909" localize="false"/><paragraph role="heading" id="hd_id3148474" xml-lang="en-US" level="3" l10n="U" oldref="63">Column type</paragraph>
85 <paragraph role="paragraph" id="par_id3149957" xml-lang="en-US" l10n="U" oldref="24"><ahelp hid="SC:LISTBOX:RID_SCDLG_ASCII:LB_TYPE1">Choose a column in the preview window and select the data type to be applied the imported data.</ahelp> You can select one of the following options:</paragraph>
87 <tablerow>
89 <paragraph role="tablehead" id="par_id3152945" xml-lang="en-US" l10n="U" oldref="25">Type</paragraph>
90 </tablecell>
92 <paragraph role="tablehead" id="par_id3145121" xml-lang="en-US" l10n="U" oldref="26">Function</paragraph>
93 </tablecell>
94 </tablerow>
95 <tablerow>
97 <paragraph role="tablecontent" id="par_id3149763" xml-lang="en-US" l10n="U" oldref="27">Standard</paragraph>
98 </tablecell>
100 <paragraph role="tablecontent" id="par_id3155923" xml-lang="en-US" l10n="U" oldref="28">$[officename] determines the type.</paragraph>
101 </tablecell>
102 </tablerow>
103 <tablerow>
105 <paragraph role="tablecontent" id="par_id3152472" xml-lang="en-US" l10n="U" oldref="29">Text</paragraph>
106 </tablecell>
108 <paragraph role="tablecontent" id="par_id3148946" xml-lang="en-US" l10n="U" oldref="30">Imported data are treated as text.</paragraph>
109 </tablecell>
110 </tablerow>
111 <tablerow>
113 <paragraph role="tablecontent" id="par_id3147265" xml-lang="en-US" l10n="U" oldref="31">Date (DMY)</paragraph>
114 </tablecell>
116 <paragraph role="tablecontent" id="par_id3156434" xml-lang="en-US" l10n="U" oldref="32">Applies a date format (Day, Month, Year) to the imported data in a column.</paragraph>
117 </tablecell>
118 </tablerow>
119 <tablerow>
121 <paragraph role="tablecontent" id="par_id3148740" xml-lang="en-US" l10n="U" oldref="33">Date (MDY)</paragraph>
122 </tablecell>
124 <paragraph role="tablecontent" id="par_id3149688" xml-lang="en-US" l10n="U" oldref="34">Applies a date format (Month, Day, Year) to the imported data in a column.</paragraph>
125 </tablecell>
126 </tablerow>
127 <tablerow>
129 <paragraph role="tablecontent" id="par_id3150230" xml-lang="en-US" l10n="U" oldref="35">Date (YMD)</paragraph>
130 </tablecell>
132 <paragraph role="tablecontent" id="par_id3153207" xml-lang="en-US" l10n="U" oldref="36">Applies a date format (Year, Month, Day) to the imported data in a column.</paragraph>
133 </tablecell>
134 </tablerow>
135 <tablerow>
137 <paragraph role="tablecontent" id="par_id3148981" xml-lang="en-US" l10n="U" oldref="65">US English</paragraph>
138 </tablecell>
140 <paragraph role="tablecontent" id="par_id3153178" xml-lang="en-US" l10n="U" oldref="66">Numbers formatted in US English are searched for and included regardless of the system language. A number format is not applied. If there are no US English entries, the <emph>Standard</emph> format is applied.</paragraph>
141 </tablecell>
142 </tablerow>
143 <tablerow>
145 <paragraph role="tablecontent" id="par_id3154329" xml-lang="en-US" l10n="U" oldref="37">Hide</paragraph>
146 </tablecell>
148 <paragraph role="tablecontent" id="par_id3154946" xml-lang="en-US" l10n="U" oldref="38">The data in the column are not imported.</paragraph>
149 </tablecell>
150 </tablerow>
151 </table>
152 <paragraph role="paragraph" id="par_id3149767" xml-lang="en-US" l10n="U" oldref="75">If you selected one of the date formats (DMY), (MDY), or (YMD) and you enter numbers without date delimiters, the numbers are interpreted as follows:</paragraph>
154 <tablerow>
156 <paragraph role="tablehead" id="par_id3150650" xml-lang="en-US" l10n="U" oldref="76">Number of characters </paragraph>
157 </tablecell>
159 <paragraph role="tablehead" id="par_id3150495" xml-lang="en-US" l10n="U" oldref="77">Date format</paragraph>
160 </tablecell>
161 </tablerow>
162 <tablerow>
164 <paragraph role="tablecontent" id="par_id3156212" xml-lang="en-US" l10n="U" oldref="78">6</paragraph>
165 </tablecell>
167 <paragraph role="tablecontent" id="par_id3153056" xml-lang="en-US" l10n="U" oldref="79">Two characters each are taken for day, month, and year in the selected order.</paragraph>
168 </tablecell>
169 </tablerow>
170 <tablerow>
172 <paragraph role="tablecontent" id="par_id3147352" xml-lang="en-US" l10n="U" oldref="80">8</paragraph>
173 </tablecell>
175 <paragraph role="tablecontent" id="par_id3153768" xml-lang="en-US" l10n="U" oldref="81">Four characters are taken for the year, two each for month and day, in the selected order.</paragraph>
176 </tablecell>
177 </tablerow>
178 <tablerow>
180 <paragraph role="tablecontent" id="par_id3147295" xml-lang="en-US" l10n="U" oldref="82">5 or 7</paragraph>
181 </tablecell>
183 <paragraph role="tablecontent" id="par_id3151168" xml-lang="en-US" l10n="U" oldref="83">As with 6 or 8 characters, but the first part of the sequence has one character less. This will suppress a leading zero for month and day.</paragraph>
184 </tablecell>
185 </tablerow>
186 </table>
187 <paragraph role="tip" id="par_id3153143" xml-lang="en-US" l10n="U" oldref="44">If you want to include the leading zero in the data you import, in telephone numbers for example, apply the "Text" format to the column.</paragraph>
188 <paragraph role="heading" id="hd_id3149287" xml-lang="en-US" level="3" l10n="U" oldref="39">Preview</paragraph>
189 <paragraph role="paragraph" id="par_id3147377" xml-lang="en-US" l10n="U" oldref="40">Shows how the imported text will look after it is separated into columns. To apply a format to a column when it is imported, click a column and select a <emph>Column type</emph>. When you select a <emph>Column type</emph>, the column heading displays the applied format.</paragraph>
190 <paragraph role="paragraph" id="par_id3150105" xml-lang="en-US" l10n="U" oldref="64">If you want to use a fixed width to separate the imported data into columns, click in the ruler to set the width boundaries.</paragraph>
191 <paragraph role="paragraph" id="par_id3155746" xml-lang="en-US" l10n="U" oldref="74"><link href="text/shared/guide/keyboard.xhp" name="Navigating Without the Mouse">Navigating Without the Mouse</link></paragraph>
192 <paragraph role="paragraph" id="par_id3146120" xml-lang="en-US" l10n="U" oldref="43">For more information, see <link href="text/shared/00/00000020.xhp" name="Information about Import and Export Filters">Information about Import and Export Filters</link>.</paragraph>
193 </body>
194 </helpdocument>