Row-Delimiter & column Delimiter in Datastage
Posted: Thu May 06, 2010 1:29 am
Hi,
Could you please help me out in the below questions.
1) If we have a file with combined row-delimiter (which
means a char is appended in front of the new line char), is it possible
to set the combined delimiter as the row delimiter in data stage?
Field1|Field2|Field3${LR} Field1|Field2|Field3${LR}
Field1|Field2|Field3${LR} ---> here ${LR} is the row-delimiter.
2) If we have a file with combined column-delimiter, is it possible to
set the combined delimiter as the column delimiter in data stage?
Field1$|Field2$|Field3{LR}Field1$|Field2$|Field3{LR}
Field1$|Field2$|Field3{LR} ---> here $| is the column delimiter.
Could you please help me out in the below questions.
1) If we have a file with combined row-delimiter (which
means a char is appended in front of the new line char), is it possible
to set the combined delimiter as the row delimiter in data stage?
Field1|Field2|Field3${LR} Field1|Field2|Field3${LR}
Field1|Field2|Field3${LR} ---> here ${LR} is the row-delimiter.
2) If we have a file with combined column-delimiter, is it possible to
set the combined delimiter as the column delimiter in data stage?
Field1$|Field2$|Field3{LR}Field1$|Field2$|Field3{LR}
Field1$|Field2$|Field3{LR} ---> here $| is the column delimiter.