Easy question

[ray.wurlod]

There are many variations on this. Here's just one solution. Note, though, that you need to do these transformations in a Transformer stage; in server jobs a Sequential File stage accesses data in the text file, without modifying it. Version 6 will allow you to pass the data through a filter, such as a sed or awk script.

To get the four characters to the left of the first "]" character:
Right(Field(TheString, "]", 1, 1), 4)

To get the four characters to the immediate right of the first "]" character:
Left(Field(TheString, "]", 2, 1), 4)

Will you need to handle the case that there might not be a "]" character?

[Angel]

Thank you for question.
By

[Angel]

yes, of course, but the problem is that de length before 2000 is not always the same.

[ray.wurlod]

For example [Tue Dec 9 2003] versus [Wed Dec 10 2003].

[Teej]

For example [Tue Dec 9 2003] versus [Wed Dec 10 2003].

That's why I said most date formats. Sometimes (especially in UNIX), I would see "Tue Dec 09 2003".

Ah well.

-T.J.