Text File data fill 1

[proximity]

Hi everyone,

Can anyone suggest the best way to get ColA values of a plain text to repeat until it changes to another value:

Before:

ColA ColB
001/0222 901123
001/0255 855524
855524
855524
001/6622 855666
001/1222 123456
123456
123456

After:
ColA should never have any null values - the value should be the last preceding one, so that the result should look like this:

001/0222 901123
001/0255 855524
001/0255 855524
001/0255 855524
001/6622 855666
001/1222 123456
001/1222 123456
001/1222 123456

Once that's done, I can simly import the data into a table.

Thanks.

 

[PWise]

See my post here

http://www.tek-tips.com/viewthread.cfm?qid=1556900

 

[proximity]

Thanks pwise, that was exactly what I was looking for!