File mover software: move, copy, delete your files with our filemover | Blog | ORDER NOW

Contact Us Now

[contact-form-7 id="1125" title="Contact form 1"]

File Mover Blog

  • 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 , , ,
  • 30 Dec

    Split delimited files based on duplicate column

    Split delimited files based on duplicate column

    Q: We receive | (pipe) delimited files (no double quotes):

    Rvman International Inc. – US|CONTENT + US|1310001|0000000122|10/25/2023 1:54 PM
    Rvman International Inc. – US|CONTENT + US|1310002|0000000616|0/25/2023 2:10 PM
    Rvman International Inc. – US|CONTENT + US|1310002|0000000616|0/25/2023 2:10 PM

    Is it possible to create separate files of rows with the same content in column 4?

    The filename(s) would be incremental:

    original .csv

    Rvman International Inc. – US|CONTENT + US|1310001|0000000122|10/25/2023 1:54 PM

    original1.csv

    Rvman International Inc. – US|CONTENT + US|1310002|0000000616|0/25/2023 2:10 PM
    Rvman International Inc. – US|CONTENT + US|1310002|0000000616|0/25/2023 2:10 PM

    Thanks for such a great product!

    A: Yes this is possible using our Pascal Script option

    We used a Windows folder as Source. In this folder we’ll search for .csv files.

    limagito file mover as source

    Since we are only interested in .csv files we added a filename include filter. We want to be sure we’ll only handle .csv files.

    limagito filemover filename filter

    As Destination we used our Pascal Script option. Please replace the default Destination Pascal Script.

    You can download the script: here

    The script will read the csv file with  a pipe as delimiter (this can be adjusted > ctPipe constant). We’ll check the content of column 4 which is index 3 (TStringList = zero index based).

    tmpCol4 := tmpPipe.Strings[3];

    Limagito File Mover pascal script as destination

    Output Result:

    Split delimited files based on duplicate column

    RunTime Log Result:

    limagito file mover runtime log result

    #csv #managedfiletransfer #filetransfer #filemanagement

    If you need any help with this ‘Split delimited files based on duplicate column’ question, please let us know.

    Best Regards,

    Limagito Team

    By Limagito-Team CSV Pascal Script , ,
  • 29 Dec

    Copy and rename a file using its folder name

    Copy and rename a file using its folder name

    Q:  We need your advice please as following:
    A customer need a copy & rename batch to another destination – the mainfolder is e.g. V360_images and inside we have a lot of subfolders with image files in jpg or mp4 file format. The job file named still.jpg should be copied to the another folder destination and renamed with the numbers of the the folder – see here:

    limagito file mover rename a file using its folder name

    Here we are inside of the folder #658301 – the job file still.jpg should be copied to folder e.g.: images and renamed with the folders name to 658301

    limagito file mover rename a file using its folder name

    Is this task possible to automate with Limagito File Mover without any scripting?

    A: Yes this is possible. In our example we used a Windows folder as Source:

    limagito file mover windows folder as source

    Since the customer is only interested in the ‘still.jpg’ file we added the following include filename filter:

    limagito file mover include filename filter

    We only want to scan within the subfolders of the Source root folder ( in our example > C:\Test\Customer\In2\V360_Images\ ). We do not want to pickup any files in this Source Root folder and that is why we enabled the following options:

    limagito file mover directory filter setup

    We used a Windows folder as Destination: ‘C:\Test\Customer\Out2\Images\’

    limagito file mover destination setup

    Since all Source files should go to a single Destination folder, we disabled our ‘Create Subdir’ option (File & Directory Tab). We do not want to create any subfolders in the Destination.

    limagito file mover windows folder as destination

    Next switch to the ‘Rename’ tab and enable ‘Rename Files during Copy/Move’. Open the ‘Rename Filter Setup’.

    limagito file mover file rename options

    We’ll use the Source SubFolder parameter (%SFS) in the renaming setup. RegEx  (.*)\.(.*)  will split the filename into two parts, first part are all characters before the dot and part two are all characters after the dot. The first part \1 will no longer be used but replaced by the Source SubFolder name. The second part \2 (= file extension) will be used again.

    Added the following RegEx and Replacement setup:

    RegEx:  (.*)\.(.*)

    Replacement:  %SFS.\2

    limagito file mover file renaming setup

    RunTime log result:

    limagito file mover runtime log result

     

    #rename #managedfiletransfer #filetransfer #filemanagement

    If you need any help with this ‘rename a file using its folder name’ question, please let us know.

    Best Regards,

    Limagito Team

    By Limagito-Team Rename ,
1 … 16 17 18 19 20 21 22 … 145
SEARCH
CATEGORIES
ARCHIVES
TAGS
365 api code command csv date delete drive Eldos email error filename filter ftp HL7 install License limagito limagitox log monitor multiple oauth OAuth2 parameter parameters Pascal pdf Remote rename roadmap Script service SFTP SharePoint sign SMTP SQL SSH unzip vendor week xls Xml zip

limagito logo

Limagito filemover is an automated file mover solution handling everything from moving, deleting to copying files.

Please don’t hesitate to contact us if you have any questions about our product and services.

DISCOVER OUR SITE
How to to skip files if they already exist at the destination
November 21, 2024 no responses
Problem copying a file due to a folder tree that is too long
October 20, 2024 no responses
How to verify the pgp signature during decryption
October 20, 2024 no responses
© 2007-2024 IT services & software development by CPsoft // Webdesign & webhosting by Siteplan