IBM Sterling Transformation Extender

Hello everyone, I am new to WTX. My question is, is it possible with a function to read the last line of an input file, that is, to read the entire last row to extract that information and send it to processdata or somewhere else? ty for ur time   

It depends on how you define your type tree.  Usually the last line may contain some summary information and it's represented in the type tree.  In this case, you can drag the object to the output card and either use the Sterling adapter to write to ProcessData or write it to a file followed by a FileSystemAdapter service to write it to ProcessData.

Hello everyone, I am new to WTX. My question is, is it possible with a function to read the last line of an input file, that is, to read the entire last row to extract that information and send it to processdata or somewhere else? ty for ur time   

Thanks for your kind response. In my case, there is a field called 'renglón' that is in a group; that's my type tree.  Is  very simple ,The file comes to me from a primary document, and I put everything into that 'renglón' field. From there, I need to see how I can extract the last line of the file.

It depends on how you define your type tree.  Usually the last line may contain some summary information and it's represented in the type tree.  In this case, you can drag the object to the output card and either use the Sterling adapter to write to ProcessData or write it to a file followed by a FileSystemAdapter service to write it to ProcessData.

Hello everyone, I am new to WTX. My question is, is it possible with a function to read the last line of an input file, that is, to read the entire last row to extract that information and send it to processdata or somewhere else? ty for ur time   

Thanks for your kind response. In my case, there is a field called 'renglón' that is in a group; that's my type tree.  Is  very simple ,The file comes to me from a primary document, and I put everything into that 'renglón' field. From there, I need to see how I can extract the last line of the file.

It depends on how you define your type tree.  Usually the last line may contain some summary information and it's represented in the type tree.  In this case, you can drag the object to the output card and either use the Sterling adapter to write to ProcessData or write it to a file followed by a FileSystemAdapter service to write it to ProcessData.

Hello everyone, I am new to WTX. My question is, is it possible with a function to read the last line of an input file, that is, to read the entire last row to extract that information and send it to processdata or somewhere else? ty for ur time   

Hello everyone, I am new to WTX. My question is, is it possible with a function to read the last line of an input file, that is, to read the entire last row to extract that information and send it to processdata or somewhere else? ty for ur time   

Hello,
for accessing the last occurrence of the object you can use LAST key word, please refer to attached screen shot from WTX redbook.

Hello everyone, I am new to WTX. My question is, is it possible with a function to read the last line of an input file, that is, to read the entire last row to extract that information and send it to processdata or somewhere else? ty for ur time   

Great suggestion - but would only work if he updates the type tree to use repeating objects that could be indexed.  He seems to indicate this is a blob text field he needs to parse. This is a handy feature to use when the data is parsed correctly.

Hello,
for accessing the last occurrence of the object you can use LAST key word, please refer to attached screen shot from WTX redbook.

Hello everyone, I am new to WTX. My question is, is it possible with a function to read the last line of an input file, that is, to read the entire last row to extract that information and send it to processdata or somewhere else? ty for ur time   

Thank you for your time and your well-constructed response. In my case, it is a file like the one I have in the image. It is a file that, after some previous mappings, produces a random result, so I don't think I can put a delimiter or a reference value. I think that after the last <CR><LF>, I should extract what follows. 

import java.io.BufferedReader;import java.io.FileReader;import java.io.IOException;public class LastLineExtractor {    public static void main(String[] args) {        String filePath = "my/path/document.txt";         try (BufferedReader br = new BufferedReader(new FileReader(filePath))) {            String currentLine;            String lastLine = "";            while ((currentLine = br.readLine()) != null) {                lastLine = currentLine;            }            System.out.println("last line in ur file : " + lastLine);        } catch (IOException e) {            e.printStackTrace();        }    }}

ty for the help  

Great suggestion - but would only work if he updates the type tree to use repeating objects that could be indexed.  He seems to indicate this is a blob text field he needs to parse. This is a handy feature to use when the data is parsed correctly.

Hello,
for accessing the last occurrence of the object you can use LAST key word, please refer to attached screen shot from WTX redbook.

Hello everyone, I am new to WTX. My question is, is it possible with a function to read the last line of an input file, that is, to read the entire last row to extract that information and send it to processdata or somewhere else? ty for ur time   

A java program such as this is going to be using a line terminator to determine the reading of each line.  WTX has the ability ti set variable terminators so that the same map could be used to parse data sets originating from varying platforms and OS systems.  For example, DOS/Windows based systems typically end lines with a Carriage Return Line Feed combination - in WTX this can be referenced by the syntax shorthand of <CR><LF> or with the characters decimal equivalent in the SYMBOL function such as SYMBOL(13) SYMBOL(10) - in contrast Unix/Linux systems typically/natively just use the <LF> as line terminators. 

If you change the input type tree to have a group of text fields that are Terminated by Variable syntax and include all possible combinations with the most likely being the default, you can then parse through the file like Java does.  AND you can use that handy LAST keyword to retrieve the last line of the file. 

By just putting in a little effort into defining the type tree your job becomes so much simpler.

Line group is a text field with a Variable terminator.  File is a repeating group of Line groups.  There are several ways this could be organized.  You could instead just have repeating text items in the File group and have them in an Explicit, Delimited group with the Variable Terminator as well. I tend organize for additions and enhancements.

Variable terminator Include list...  Make sure the sub-type of the Item is Syntax.

With this set up you can use the [LAST] key word on the Line group to get the last line in the map.  I've attached my sample type tree - however it is ITX 10 - not sure if that is compatible with your version.

Happy mapping!

Thank you for your time and your well-constructed response. In my case, it is a file like the one I have in the image. It is a file that, after some previous mappings, produces a random result, so I don't think I can put a delimiter or a reference value. I think that after the last <CR><LF>, I should extract what follows. 

import java.io.BufferedReader;import java.io.FileReader;import java.io.IOException;public class LastLineExtractor {    public static void main(String[] args) {        String filePath = "my/path/document.txt";         try (BufferedReader br = new BufferedReader(new FileReader(filePath))) {            String currentLine;            String lastLine = "";            while ((currentLine = br.readLine()) != null) {                lastLine = currentLine;            }            System.out.println("last line in ur file : " + lastLine);        } catch (IOException e) {            e.printStackTrace();        }    }}

ty for the help  

Great suggestion - but would only work if he updates the type tree to use repeating objects that could be indexed.  He seems to indicate this is a blob text field he needs to parse. This is a handy feature to use when the data is parsed correctly.

Hello,
for accessing the last occurrence of the object you can use LAST key word, please refer to attached screen shot from WTX redbook.

Hello everyone, I am new to WTX. My question is, is it possible with a function to read the last line of an input file, that is, to read the entire last row to extract that information and send it to processdata or somewhere else? ty for ur time