Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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]
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]
Thanks for VERY fast answer. I took 5 times longer time to create the question than get the answer.
Awsome.
kindly
Håkan