--- title: "Text Adapter Actions" slug: "text-adapter-actions" description: "This is a list of actions that can be used in RapidIdentity Connect to interact with various text formats, inputs, and outputs." tags: ["RapidIdentity ", "Connect", "Adapter", "Actions", "Text", "CSV", "LDIF"] updated: 2023-06-27T18:55:07Z published: 2023-06-27T18:55:07Z canonical: "help.rapididentity.com/text-adapter-actions" --- > ## Documentation Index > Fetch the complete documentation index at: https://help.rapididentity.com/llms.txt > Use this file to discover all available pages before exploring further. # Text Adapter Actions ## Text Adapter Actions ### openDelimitedTextInput Open a Delimited Text file for reading. | Property | Value | Description | | --- | --- | --- | | filesystem | expression, variable | the filesystem definition to use (default: dss server managed files) | | fileName* | text, expression, variable | the name of the Delimited Text input file | | charSet | text, expression, variable | the character encoding of the file (default: ISO-8859-1) | | fieldNames | text, expression, variable | comma separated string containing the names of the fields in each Record | | firstRecordHandling | choice (Normal, Field Names, Skip), text, expression, variable | how to handle the first Record of the file | | fieldSeparator | text, expression, variable | the field separator character (default: ',') | | quoteCharacter | text, expression, variable | the quote character (default: '"') | | escapeCharacter | text, expression, variable | the quote character (default: the quoteCharacter) | | strictQuoteHandling | boolean, expression, variable | true if strict quote handling should be enforced (default: false) | | returnVariable | expression, variable | name of the variable to be assigned to the return value | ```actionscript csvInput = openDelimitedTextInput("input.csv", "utf-8", "fname,lname,dept,loc,job,status,type", "Skip", ",", "\\"", "\\"", false) ``` ### openDelimitedTextOutput Open a Delimited Text file for writing. | Property | Value | Description | | --- | --- | --- | | filesystem | expression, variable | the filesystem definition to use (default: dss server managed files) | | fileName* | text, expression, variable | the name of the Delimited Text output file | | appendToFile | boolean, expression, variable | true if the file should be appended to (default: false) | | charSet | text, expression, variable | the character encoding of the file (default: ISO-8859-1) | | fieldNames* | text, expression, variable | comma separated string containing the names of the fields in each Record | | outputHeaderRecord | boolean, expression, variable | true if a header Record should be output containing the field names (default: false) | | fieldSeparator | text, expression, variable | the field separator character (default: ',') | | quoteCharacter | text, expression, variable | the quote character (default: '"') | | escapeCharacter | text, expression, variable | the quote character (default: the quoteCharacter) | | eol | expression, variable | the character(s) to use as end-of-line (default: '\n') | | quoteAllFields | boolean, expression, variable | quote all fields (default: false) | | returnVariable | expression, variable | name of the variable to be assigned to the return value | ```actionscript csvOutput = openDelimitedTextOutput("output.csv", "utf-8", "fname,lname,dept,loc,job,status,type", true, ",", "\\"", "\\"", false) ``` ### openLDIFOutput Open an LDIF file for writing. | Property | Value | Description | | --- | --- | --- | | filesystem | expression, variable | the filesystem definition to use (default: dss server managed files) | | fileName* | text, expression, variable | the name of the LDIF output file | | appendToFile | boolean, expression, variable | true if the file should be appended to (default: false) | | returnVariable | expression, variable | name of the variable to be assigned to the return value | ```actionscript ldifOutput = openLDIFOutput("output.ldif", false) ``` ### openTextInput Open a Text file for reading. | Property | Value | Description | | --- | --- | --- | | filesystem | expression, variable | the filesystem definition to use (default: dss server managed files) | | fileName* | text, expression, variable | the name of the Delimited Text input file | | charSet | text, expression, variable | the character encoding of the file (default: ISO-8859-1) | | returnVariable | expression, variable | name of the variable to be assigned to the return value | ```actionscript textInput = openTextInput("input.txt", "utf-8", false) ``` ### openTextOutput Open a Text file for writing. | Property | Value | Description | | --- | --- | --- | | filesystem | expression, variable | the filesystem definition to use (default: dss server managed files) | | fileName* | text, expression, variable | the name of the Delimited Text output file | | appendToFile | boolean, expression, variable | true if the file should be appended to (default: false) | | charSet | text, expression, variable | the character encoding of the file (default: ISO-8859-1) | | eol | expression, variable | the character(s) to use as end-of-line (default: '\n') | | returnVariable | expression, variable | name of the variable to be assigned to the return value | ```actionscript textOutput = openTextOutput("output.txt", false, "utf-8", false, "\\r\\n") ``` ### putTextOutputLine Put a line to a Text Output. | Property | Value | Description | | --- | --- | --- | | textOutput* | expression, variable | the Text Output | | line* | expression, variable | the output line | ```actionscript putTextOutputLine(textOutput, "The quick brown fox jumped over the lazy dog.") ``` ### putTextOutputRecord Put a Record to a Text Output. | Property | Value | Description | | --- | --- | --- | | textOutput* | expression, variable | the Text Output | | record* | expression, variable | the output Record | ```actionscript record = createRecord(, ) setRecordFieldValue(record, "fname", "John") setRecordFieldValue(record, "lname", "Doe") setRecordFieldValue(record, "dept", "Sales") setRecordFieldValue(record, "loc", "CA") setRecordFieldValue(record, "job", "Manager") setRecordFieldValue(record, "status", "Active") setRecordFieldValue(record, "type", "Full-Time") putTextOutputRecord(textOutput, record) ``` ### rewindTextInput Rewind Text Input back to the beginning. | Property | Value | Description | | --- | --- | --- | | textInput* | expression, variable | the Text Input | ```actionscript rewindTextInput(csvInput) ``` ### Complete Examples ```actionscript # open csv input file using first line as field names csvInput = openDelimitedTextInput("input.csv", "utf-8", 1, \',\\' "\\'"\false) # open csv output file using specified field names, don't write header, append if existing file csvOutput = openDelimitedTextOutput("input.csv", false, "utf-8", "sn,givenName,gender,species", true, \'\\n\') # open ldif output file ldifOutput = openLDIFOutput("output.ldif") # loop through input records forEach(record, csvInput) { # write record to output csv putTextOutputRecord(csvOutput, record) } # add dn and also write to output ldif setRecordFieldValue(record, record[\'@dn\'] , "cn=" + record[\'givenName\'] + " " + record[\'sn\'] + "OU=Staff,OU=Internal,DC=test,DC=local") putTextOutputRecord(output, ldifOutput) close(csvInput) close(csvOutput) close(ldifOutput) ``` ```actionscript # read lines from input file, transform to uppercase, and write to output file lineInput = openTextInput("input.txt", "utf-8") lineOutput = openTextOutput("output.txt", "utf-8", "\\n") forEach(line, lineInput) { line = stringToUpper(line)\n putTextOutputLine(lineOutput, line) } close(lineOutput) close(lineInput) ```