The Open
action lets you choose the delimiter that you must use in the file, remove the
spaces from the file, and set the correct encoding for the file.
Note:
- If a double quotation mark (") is the last element of the
last line of the CSV/TXT file, the bot encounters an error during
runtime.
- When you use the
action to open a CSV file, read it, and assign it to a table, then
write it to a file using the action, the automation interprets any commas in the header or cell
data as delimiters. For instance, if three consecutive cells contain data like
"abc", "bcd",
"efd", the final output will enclose each in triple
double quotes, resulting in """abc""",
"""bcd""", """efd""".
Once you create a bot, perform the following steps to open a
CSV or text file using the Open action.
Procedure
-
Double-click or drag the Open
action from the CSV/TXT
package in the Actions palette.
-
Select any of the following options to specify the location of the CSV or text file
to open:
-
Arquivo da Control Room: Permite que você abra um arquivo da Control Room.
-
Arquivo de desktop: Permite que você abra um arquivo a partir do dispositivo. Este campo também aceita a entrada do caminho do arquivo como uma variável de string ou valor global.
Note: Quando você entra em um caminho de arquivo no campo Arquivo do desktop ou procura um arquivo específico no sistema, em que o caminho do arquivo é separado pelo caractere \ e salva o bot, o caractere \ é alterado para /, já que o bot usa / para separar caminhos de arquivos. Seus bots continuam funcionando com sucesso mesmo que o \ seja alterado para / durante a execução do bot.
-
Variável: Permite que você abra um arquivo especificando uma variável de arquivo.
Open action supports file streaming.
You can map a file from any cloud storage to a file variable and use the variable as
a data source. You can use one of the supported actions to create a streamable file
variable.
-
Enable the Contains header check box if the file contains a
header row and you want to retrieve values from that row.
-
Select any of the following options to specify the
Delimiter used in the file:
-
Comma
-
Tab
-
Regional list
separator: Enables you to specify the delimiter as
configured in the regional settings of the Windows operating system. If
the List Separator in the Windows regional
settings is modified, then the CSV file should also contain that
character as a delimiter.
-
Newline
-
Other: Enables you to specify a delimiter other
than the options listed above.
-
Select the Trim leading spaces and Trim trailing
spaces check boxes to remove the leading and trailing spaces from the
data extracted from the CSV/TXT file.
-
Select an option from the Encoding list to specify the
encoding that is applied on the file. Data from the CSV/TXT file will be
retrieved based on the selected encoding option even if the input file has a
different encoding.
-
ANSI: Usado para codificar o alfabeto latino.
-
UTF8: Pode codificar todos os caracteres possíveis.
-
UNICODE
-
Win1251: used to encode languages that use the
Cyrillic script, including Bulgarian, Russian, and Serbian.
-
UTF-16LE: ignores the byte order mark (BOM)
Unicode character at the beginning of file.
-
Default: identifies
file encoding. This option supports UTF-8, UTF-16LE, and UTF-16BE file
encoding.
Note: Shift-JIS files must use ANSI
as encoding to read text file content.
-
Click Save.
Next steps
Use the Read
action to retrieve the data from CSV/TXT file and assign them to a
table variable. You can use the loop action to retrieve each row of
data from the file or table variable and assign them to the record variable for
further operations.