Use previous

[#1]

Hello,

I´m loading a text file with orders and some of the detail order lines contains a number but some of the other

does not. My aim is to add the number to all records within the order. An excerpt of the text file looks like this:

with this line in my script can I only fill in 506 in the first record after 506 and the others will remain empty.

This is what I get:

How do I get the lines with 'ST' empty filled with 506?

kindly

Håkan

[sunny_talwar · Accepted solution]

Try this:

If([@350:359] = Previous([@350:359]) and [@484:486] = '    ', Peek('ST'), [@484:486]) as [ST]

or

If([@350:359] = Previous([@350:359]) and Len(Trim([@484:486])) = 0, Peek('ST'), [@484:486]) as [ST]

[#3]

Thanks for VERY fast answer. I took 5 times longer time to create the question than get the answer.

Awsome.

kindly

Håkan