<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />Hi,
I am trying to clean up a data table from a fairly messing format.
I am trying to create a single column with the relevant data since the input file has multiple delimiters. I am using c000004 as the column for the data I would like to keep.
Some of the data lines have two values in the same row and I am trying to copy them to a single column which entails offsetting the row index.
The first four lines work as intended, but the last one does not. I am looking for a value in c000002 and if true copy a value from column6, but one row down.
:c000004<<set each value(if(Munger(:c000002,1,"clamp")>0, :c000003,:c000004));
:c000004<<set each value(if(Munger(:c000002,1,"rot")>0, :c000005,:c000004));
:c000004<<set each value(if(Munger(:c000002,1,"locY")>0, :c000007,:c000004));
:c000004<<set each value(if(Munger(:c000002,1,"height")>0, :c000005,:c000004));
:c000004<<set each value(If(Munger(:c000002,1,"locX")>0, :c000006[Row()+1],:c000004));
The log file is not overly clarifying
:c000004 << set each value(
If( Munger( :c000002, 1, "locY" ) > 0,
:c000007,
:c000004
)
);
:c000004 << set each value(
If( Munger( :c000002, 1, "height" ) > 0,
:c000005,
:c000004
)
);
:c000004 << set each value(
If( Munger( :c000002, 1, "locX" ) > 0,
:c000006[Row() + 1],
:c000004
)
) /*###*/;
What should I use to get the row offset into a new column?
