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"]

Pascal Script

Home / Archive by Category "Pascal Script" ( - Page 7)
  • 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 , ,
  • 19 Nov

    How to rename a file to include day of the week

    How to rename a file to include day of the week

    Q: I found this in your blog but my filename pattern is different and I don’t know enough of the Pascal language to edit it.

    Here is an example of what I would like to rename.

    Original Filename: 2023-10-24_section_A2.pdf
    (2023-10-24 = October 24, 2023)
    Rename To:  Tues_2023-10-24_section_A2.pdf

    Any help you can provide would be greatly appreciated.

    A: Please have a look at the following example, I guess we need to fine-tune it. Let us know what you think.

    • We used a Windows folder as source:

    limagito file mover windows folder as source

    • Next, open our Pascal Script option:

    limagito file mover paascal script option

    • Enable and add the following ‘On Destination’ Pascal Script:

    You can download the script: here

    limagito file mover include day of the week pascal script

    • We used a Windows Folder as Destination:

    limagito file mover windows folder as destination

    •  Enable ‘Rename Files during Copy/Move’

    limagito file mover file renaming option

    • Renaming Setup:

    RegEx:   (.*)
    Replacement:   %VSA

    limagito file mover file renaming setup

    • RunTime Log Result:

    limagito file mover runtime log result

    #managedfiletransfer #filetransfer #filemanagement

    If you need any help with this ‘include day of the week’ request, please let us know.

    Best Regards,

    Limagito Team

    By Limagito-Team How-to Pascal Script Rename Uncategorized ,
  • 19 Nov

    How to move files based on data from a csv file

    How to move files based on data from a csv file

    Q: I have the Limagoto X software installed, and I would like to know if it’s possible to move files, based on some information from a csv file? I have an csv file with some order numbers, and the folders I want to move, are label with these order numbers.

    A line in the csv file would look like this:

    The file structure looks like this:

    limagito file mover folder structure example

    So I would have to extract “D” first letter of “Donald Duck” -> then look in folder “Donald Duck”\ordre and search for 9999999 and move that folder to a new location with the same folder structure.

    A: We asked and received a dummy csv file, data content lookes like:

    Art;Ordrenr.;Arkiveret;Arkivdato;Jobnavn;Kundenavn;Statuskode;Ordretype;S‘lger;Ordrestyrer
    Ordre;9876543;SAND;17-11-2023;Arkiveringstest;Limagito Complete;AABEN_ARKIV;ARK;TEAM-E;MHOE

    So in this example:

    • We would strip the first char of the ‘Kundenavn’ field:  L
    • Next it would be the full name of the same ‘Kundenavn’ field:  Limagito Complete
    • Add fixed text:  Ordre
    • And finally the value of data field ‘Ordre’:  9876543

    Result as Directory filter: *\L\Limagito Complete\Ordre\9876543\*

    • As source we used a Windows folder, root folder to start from is ‘Jobs’ :

    limagito file mover windows folder as source

    • Next we’ll need to add a ‘Pascal Script’ to strip data from the csv file and use it as directory filter:

    limagito file mover pascal script option

    • Enable and add the following ‘On Rule Begin’ Pascal Script:

    You can download the script: here

    Do not forget to adjust the ctDataPath const (must end with a \ ). In this path we’ll search for .csv data file(s) with a date structure in its filename like ‘YYYY-MM-DD’. This can, of course, be adjusted.

    limagito fil emover move files based on data from a csv file

    • Directory filter setup:

    limagito file mover directory filter setup

    The %VSA (= Var String A) configured by the previous script will be used as ‘Directory Name Include Filter’:

    limagito file mover directory filter

    This ‘Allow parameters in Directory Name Filter’ option should be enabled by default:

    limagito file mover directory filter

    • As Destination we used a Windows folder:

    limagito file mover windows folder as destination

    • RunTime log result:

    limagito file mover runtime log result

    #csv #managedfiletransfer #filetransfer #filemanagement

    If you need any help with this ‘move files based on data from a csv file’ request, please let us know.

    Best Regards,

    Limagito Team

    By Limagito-Team CSV Filters Pascal Script ,
1 … 4 5 6 7 8 9 10 … 30
SEARCH
CATEGORIES
ARCHIVES
TAGS
365 api code command convert csv date delete drive email error filename filter ftp HL7 install License limagito limagitox log monitor multiple oauth OAuth2 parameter parameters Pascal pdf python regex Remote rename roadmap Script service SFTP SharePoint sign SMTP SQL SSH unzip vendor xls Xml

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 delete Folders based on the name of the folder
August 1, 2025 no responses
How to disable destinations in limagito file mover
July 25, 2025 no responses
How to search for a rule in limagito file mover
July 25, 2025 no responses
© 2007-2025 IT services & software development by CPsoft // Webdesign & webhosting by Siteplan