DSXchange

Hi,
I have record in the following format

Id1:Value1
id2: value2
id3:value3

id1:value1
id2:value2
id3:value3

I have to parse these records.
Which stage i should use in data stage. If there is no stage available then what could be the workaround for this.

Thanks in advance,
Burendra

What do you mean, specifically, by "parse"?

Only with that knowledge could we proffer cogent advice.

Do you mean upper case to lower case? And remove spaces if any? Look at the functions Convert(), DownCase() in a transformer stage.

Parsing means i want the record in the following format

id1 id2 id3
value1 value2 value3
value1 value2 value3



where id1 , id2 and id3 are the heading of the file.

To clarify, you want to pivot rows into columns? Is that correct? The technique is called "vertical pivoting", and a search of the forum for that term will reveal a number of ways that it can be done with DataStage.