Example

In this example, we are passing the required parameter to the function transformation object using a Variables object. We will be deleting a “Test.txt” source file which exists within a folder.

Where,

filePath = C:\Users\Kanwal.Azim\OneDrive - Astera Software\Desktop\Functions Documentation\Files\DeleteFile\Test.txt

Right-click on the function transformation object and select Preview Output. While the Data Preview will not generate an output, the existing file within the specified location will be deleted.

Example

In this example, we are passing the required parameter to the function transformation object using a Variables object. We will be checking for an existing directory.

Where,

filePath = C:\Users\Kanwal.Azim\OneDrive - Astera Software\Desktop\Functions Documentation\Files

Right-click on the function transformation object and select Preview Output. As you can see, Astera Data Stack has returned the Boolean value “True”, as this directory does exist.

Example

In this example, we are passing the required parameter to the function transformation object using a Variables object. We will be checking for an existing file.

Where,

filePath = C:\Users\Kanwal.Azim\OneDrive - Astera Software\Desktop\Functions Documentation\Files\File Exists\FileExists.docx

Right-click on the function transformation object and select Preview Output. As you can see, Astera Data Stack has returned the Boolean value “True”, as this file does exist.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object. We will be appending the string, “HELLO WORLD”, into an empty ‘Test’ .txt file.

Where,

str = C:\Users\Kanwal.Azim\OneDrive - Astera Software\Desktop\Functions Documentation\Test.txt

text = HELLO WORLD

Right-click on the function transformation object and select Preview Output. While the Data Preview will not generate an output. Upon opening the file for which the path was defined earlier, you will see that Astera Data Stack has appended the provided string value into this file.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

filePath = C:\Users\Kanwal.Azim\OneDrive - Astera Software\Desktop\Documentation Projects\Functions Documentation\Files\FileLineCount\Test.txt

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the number of lines in the specified file, as evident below:

Example

In this example, we are passing the required parameter to the function transformation object using a Variables object.

Where,

filePath = C:\Users\Kanwal.Azim\OneDrive - Astera Software\Desktop\Functions Documentation\Files\GetDirectory\GetDirectory.docx

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has extracted the directory of the specified file.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object. We will be copying a “Test.txt” source file to a different destination file folder.

Where,

sourceFilePath = C:\Users\Kanwal.Azim\OneDrive - Astera Software\Desktop\Functions Documentation\Files\AppendTextToFile\Test.txt

destFilePath = C:\Users\Kanwal.Azim\OneDrive - Astera Software\Desktop\Functions Documentation\Files\CopyFile\Test3.txt

overWrite = False

Right-click on the function transformation object and select Preview Output. While the Data Preview will not generate an output. Upon opening destination file location, you can see that Astera Data Stack has copied the Test.txt file, with the specified name, Test3.txt.

Example

In this example, we are passing the required parameter to the function transformation object using a Variables object.

Where,

filePath = C:\Users\Kanwal.Azim\OneDrive - Astera Software\Desktop\sampledata

Right-click on the function transformation object and select Preview Output. As you can see, Astera Data Stack has returned the specified EDI file’s meta-data.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

filePath = C:\Users\Kanwal.Azim\OneDrive - Astera Software\Desktop\Functions Documentation\Files\FileLength\Test.txt

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the number of bytes in the specified file, as evident below:

Example

In this example, we are passing the required parameter to the function transformation object using a Variables object.

Where,

filePath = C:\Users\Kanwal.Azim\OneDrive - Astera Software\Desktop\Functions Documentation\Files\GetFileNameWithoutExtension\GetFileNameWithoutExtension.docx

Right-click on the function transformation object and select Preview Output. As you can see, Astera Data Stack has returned the file name without extension of the specified file path.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

filePath = C:\Users\Kanwal.Azim\OneDrive - Astera Software\Desktop\Functions Documentation\Files\LastUpdateDateTime\LastUpdateDateTime.docx

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the datetime value of when the specified file was last updated.

Example

In this example, we are passing the required parameter to the function transformation object using a Variables object. We will be defining the file path of the file for which we want to extract the extension.

Where,

filePath = C:\Users\Kanwal.Azim\OneDrive - Astera Software\Desktop\Functions Documentation\Files\GetFileExtension\GetFileExtension.docx

Right-click on the function transformation object and select Preview Output. As you can see, Astera Data Stack has returned the extracted file extension from the specified file path.

Example

In this example, we are passing the required parameter to the function transformation object using a Variables object. We will be checking for worksheets in an Excel file.

Where,

excelFilePath = C:\Users\Kanwal.Azim\OneDrive - Astera Software\Desktop\Test.xlsx

Right-click on the function transformation object and select Preview Output. As you can see, Astera Data Stack has returned a list of all the worksheet present in the Excel workbook, for which the path was specified.

Example

In this example, we are passing the required parameter to the function transformation object using a Variables object.

Where,

filePath = C:\Users\Kanwal.Azim\OneDrive - Astera Software\Desktop\Functions Documentation\Files\GetFileInfo\GetFileInfo.docx

Right-click on the function transformation object and select Preview Output. As you can see, Astera Data Stack has returned all file properties of the specified file.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

filePath = C:\Users\Kanwal.Azim\OneDrive - Astera Software\Desktop\Functions Documentation\Files\CreateDateTime\Test.txt

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the datetime value of when he specified file was created, as evident below:

Example

In this example, we are passing the required parameter to the function transformation object using a Variables object.

Where,

filePath = C:\Users\Kanwal.Azim\OneDrive - Astera Software\Desktop\Functions Documentation\Files\GetFileName\GetFileName.docx

Right-click on the function transformation object and select Preview Output. As you can see, Astera Data Stack has returned the file name of the specified file path.

Example

In this example, we are passing the required parameter to the function transformation object using a Variables object.

Where,

filePath = C:\Users\Kanwal.Azim\OneDrive - Astera Software\Desktop\Functions Documentation\Files\ReadFileFirstLine\Test.txt

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the first line of the specified file.

Example

In this example, we are passing the required parameter to the function transformation object using a Variables object.

Where,

filePath = C:\Users\Kanwal.Azim\OneDrive - Astera Software\Desktop\Documentation Projects\Functions Documentation\Files\ReadFileText-codePage\Test.txt

codepage = 65001 (UTF-8 Unicode)

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the entire text of the specified file.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object. We will be moving a “Test.xlsx” source file to a different destination file folder.

Where,

filePath = C:\Users\Kanwal.Azim\OneDrive - Astera Software\Desktop\Test.xlsx

newFilePath = C:\Users\Kanwal.Azim\OneDrive - Astera Software\Desktop\TestFileMove

Right-click on the function transformation object and select Preview Output. While the Data Preview will not generate an output. Upon opening the destination file location, you can see that Astera Data Stack has moved the Test.xlsx file to the specified folder.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object and a ToBytes function transformation object. We will be writing the byte array, “48656C6C6F20576F726C64”, into a new, empty Test.txt file.

Where,

filePath = C:\Users\Kanwal.Azim\OneDrive - Astera Software\Desktop\Test.txt

bytes = 48656C6C6F20576F726C64

Right-click on the function transformation object and select Preview Output. While the Data Preview will not generate an output, a new file with the specfied name will be created at the specified loaction, and the provided byte array will be written to this file, after being converted into a string value.

Example

In this example, we are passing the required parameter to the function transformation object using a Variables object.

Where,

filePath = C:\Users\Kanwal.Azim\OneDrive - Astera Software\Desktop\Functions Documentation\Files\ReadFileBytes\Test.txt

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has read and returned the bytes of the specified file.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object. We will be writing the string, “HELLO WORLD 123”, into a new, empty ‘TEST_WRITE’ .txt file.

Where,

filePath = C:\Users\Kanwal.Azim\OneDrive - Astera Software\Desktop\TEST_WRITE.txt

text = HELLO WORLD 123

Right-click on the function transformation object and select Preview Output. While the Data Preview will not generate an output, a new file with the specfied name will be created in the specified loaction, and the provided text will be written to this file.

Example

In this example, we are passing the required parameter to the function transformation object using a Variables object.

Where,

filePath = C:\Users\Kanwal.Azim\OneDrive - Astera Software\Desktop\Functions Documentation\Files\ReadFileText\Test.txt

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the entire text of the specified file.