Skip to Content
avatar image
Former Member

Count lines of xml file

hi

i have flat file -> idoc scenario and I want to use mapping/cr8 user-defined function to count ALL the lines of the xml file

I tried to use index function with remove context and split by value and it didnt help ( mayb i did it wrong )

if i use count function i have to use it on EACH line and add all

the flat file MT is

Integral_MT

___________IDOC

__________________H_Line (1)

__________________L_Line (unbounded)

__________________V_Line (unbounded)

any suggestions?

thx

Shai

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 28, 2006 at 09:52 AM

    Hi,

    You can use user defined function. Handle the context. just return the length.

    Regards,

    Kavita

    Add comment
    10|10000 characters needed characters exceeded

    • put the context to the parent node (maybe the MT itself), then use a UDF like

      public void RecordCount(String[] a, .....)

      {

      tempCount = a.length;

      ........

      }

      for each node once you get the count pass them to a add function or create onto handle the add with the number of inputs (the count functions) and return the total number of count.

  • avatar image
    Former Member
    Jun 28, 2006 at 10:45 AM

    Hi,

    You just need to write one liner code in function.

    result.addValue(Integer.toString(a.length));

    and change context to root.

    -Kavita

    Add comment
    10|10000 characters needed characters exceeded

    • public void count(String[] a, String[] b, String[] c, ResultList result,Container container)

      {

      //write your code here

      int i = 0;

      int j = 0;

      int k = 0;

      i = a.length;

      j = b.length;

      k = c.length;

      i = ijk;

      String val = String.valueOf(i);

      result.addValue(val);

      }

      and all the context will be the root.