• 05 Jan

    How to remove the header row from a CSV file

    How to remove the header row from a CSV file

    Q: We have a CSV file that contains a header row.  Is it possible for Limagito to remove the first row in the file when we move it to a new folder?  Both the start and ending locations are on a windows server.

    A: Yes, this is possible. Please have a look at the following screenshots.

    • The customer is using a Windows folder as Source so we used this also in our example:

    limagito file mover Windows folder as source

    • We added an include filename filter so we are 100% we’ll only pickup .csv files:

    limagito managedfiletransfer filename filter

    • In our Destination setup we added our ‘Pascal Script’ option:

    limagito managedfiletransfer destination setup

    • Please add the following script (v1): link
    • We also added an alternative for the first script. In this script you can enable or disable the “TrailingLineBreak = finishing line break” (v2): link
      • psSaveListToFile(tmpList, tmpOutputFile, False);
      • psSaveListToFile(tmpList, tmpOutputFile, True);
    • We even added a third possibility where you can change the encoding and BOM of the resulting Csv file (v3): link
    • If you would need a different option, please let us know, many options are possible.

    remove the header row

    • RunTime Log Result:

    remove the header row

    #csv #managedfiletransfer #filetransfer #filemanagement

    If you need any help with this ‘remove the header row’ question, please let us know.

    Best Regards,

    Limagito Team

    By Limagito-Team CSV Pascal Script , , ,
  • 16 May

    Q&A 10: Can we remove empty directories in LimagitoX File Mover

    Q: Can we create a rule which will remove empty directories once a week, not every scan?
    A: Yes this is possible. Let’s start with a new rule. Source will be the Windows folder you want to scan. Trigger it once a week and add a dummy Pascal Script as destination. Some screenshots to get you started.

    1.- Setup the Schedule.

    Disable the Scan Timers because we are going to use the Scheduler option instead.


    Swith from Timer to Scheduler Tab and <Add> a Schedule. Change the setup of this schedule to once a week and <Save>.


    2.- Set the File PreFix Filter to something impossible so it will never pickup files:


    3.- Directory Filter Setup, enable ‘Include Subdirectories’ and ‘Delete Empty Subdirectories On Scan’:


    4.- Add a Dummy ‘Pascal Script’ as Destination:


    If you need help with ‘remove empty directories ‘, please let us know.


    Limagito Team

    By Limagito-Team Q&A , , ,