0

I have a piece of code where I fill variables with data
and would like to add the first column of each row into the variable:
So each variable in a row should contain: %VAR_ + 'value of column[0]' + headerRow[i] + %
Now it looks like this which makes variables only unique within a row.

       result = []
        for line in lines:            
            i = 0
            for cell in row:
                tmp = ('%VAR_' + headerRow[i] + '%')
                line = line.replace(tmp, cell) # string.replace(old, new)
                i = i + 1
            result.append(line)
        return result
2
Contributors
4
Replies
5
Views
4 Years
Discussion Span
Last Post by biscayne
1

You should first test that what you want is there.

for cell in row:
    tmp = ('%VAR_' + headerRow[i] + '%')
    if tmp in line:
        line = line.replace(tmp, cell) # string.replace(old, new)
        print "replaced line =", line
    else:
        print tmp, "not found"
0

What I want is there, but tmp (variable with column name included) is only unique per row, I want it to be unique for the whole file so it should contain some kind of row id.

Edited by biscayne

0

Note that you will replace tmp with cell no matter when it is found, i.e the for loop will always replace tmp with cell 1 on the first pass if it is found, no matter where in the line it occurs. Without more info about what input and output should be, and what row contains, there is nothing more that can be said.

Edited by woooee

0

Thanks Woooee, got your point.
While debugging the program I can actually see what happens and that is rather
surprising ! ;-)
Thanks again.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.