How i export a file .txt positioned like this:?

alvesddalvesdd Member Posts: 6 Contributor II
edited November 2018 in Help
The operator Write_CSV export with separator.

RECORD_N      ID_NumNR_ACCOUNT                  PROG      NOME                             
        1              111052376488756571009            D            ELIDES DELAVECHE NICOLAU         
        2              111053376488785441000            D            CILENE CORTEZ                   
        3              111054376488809141008            D            ELISANGELA D ALVES               
        4              111055376488854051003            D            JOSE MAURICIO P GOM             
        5              111056376488860941007            D            IONE C BRITO                     
        6              111057376488868631006            D            ROMARIO P BARBOSA               
        7              111058376488877841000            D            MARCOS ANTONIO DE SOUZA         
        8              111059376488888601005            D            VAGNER FERREIRA                 
        9              111060376488920671008            D            RAFAEL GORTE P SILVA   


  • Options
    Marco_BoeckMarco_Boeck Administrator, Moderator, Employee, Member, University Professor Posts: 1,996 RM Engineering

    I'm not sure I understand what you want to do. Do you want to write a .txt instead of a .csv? In that case, have a look at the following process:

    <?xml version="1.0" encoding="UTF-8" standalone="no"?>
    <process version="6.1.001-SNAPSHOT">
     <operator activated="true" class="process" compatibility="6.1.001-SNAPSHOT" expanded="true" name="Process">
       <process expanded="true">
         <operator activated="true" class="retrieve" compatibility="6.1.001-SNAPSHOT" expanded="true" height="60" name="Retrieve Iris" width="90" x="45" y="30">
           <parameter key="repository_entry" value="//Samples/data/Iris"/>
         <operator activated="true" class="write_csv" compatibility="6.1.001-SNAPSHOT" expanded="true" height="76" name="Write CSV" width="90" x="179" y="30">
           <parameter key="column_separator" value=" "/>
           <parameter key="quote_nominal_values" value="false"/>
         <operator activated="true" class="write_file" compatibility="6.1.001-SNAPSHOT" expanded="true" height="60" name="Write File" width="90" x="313" y="30">
           <parameter key="filename" value="C:\Users\YOUR_USERNAME\Desktop\export.txt"/>
         <connect from_op="Retrieve Iris" from_port="output" to_op="Write CSV" to_port="input"/>
         <connect from_op="Write CSV" from_port="file" to_op="Write File" to_port="file"/>
         <portSpacing port="source_input 1" spacing="0"/>
         <portSpacing port="sink_result 1" spacing="0"/>
  • Options
    alvesddalvesdd Member Posts: 6 Contributor II
    Marco, thank you !

Sign In or Register to comment.