DSXchange

Use DCOUNT(In.ColumnName,' ') to get the number of space-delimited words, then use FIELD(In.ColumnName,' ',DCOUNT(In.ColumnName,' ')) to get the last "word". p.s. Corrected mistyping of the FIELD function, the original post mistakenly used INDEX. Thanks JoshGeorge for bringin...

Ravi, although you didn't ask a question I'll assume you want to know how to do this. You can write a simple job to do this read and write 1 or 0 records to a sequential file. Then, from a sequencer job, you can check this file's size to determine how to proceed. Alternately, you can set the user re...

msc_giri - I am confused by your suggestion, could you perhaps explain how using quotes will allow these columns to be read correctly?

Is there some way that we can remove duplicate posts? This problem seems to be getting worse on a weekly basis Perhaps some automated program that scans threads and just drop duplicates?

In the CFF stage, right-mouse click on the column name and then choose the option "edit row", the rest follows from there.

Pravin - you might have an implicit sort in your input link that you have overlooked.

The sequential stage does not allow multiple separators; but you can use a simple tr command to convert the commas into pipes.

The job is broken if you cannot edit or recompile it. Do you have an export backup version of it you can re-import? Also, how did this job get corrupted - could there be others in the same project with problems as well?

Try to see if you can edit and recompile the job you just tried to run.

That is very unfortunate. I tested it and don't have the warning.

The -5 you used subtracted 5 seconds from the TimeStamp; you need to subtract (5*60*60) from the timestamp.

modify stage , not modify state. You haven't specified how you are reading your file - as one big column, or separated into columns. Your functions in a modify stage are limited to the substring you have already asked about, so if the "=" sign is always in the same position you can use substrings, o...

WRITE errors are most likely from your project directory being 100% or a corrupted log file. The first condition you need to check yourself, the second might be fixed by clearing the log file. Actually, the third option is that your log is >2Gb and that would also be fixed by clearing your log.

The FIELD function does not exist in a modify stage; only in the transform stage.

tini - I used a fixed length CHAR instead of VarChar and the message went away. Or just deprecate the warning message in the log.