Parsing of the record

bkumar103 · Post by **bkumar103** » Tue Apr 01, 2008 12:50 am

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

ray.wurlod · Post by **ray.wurlod** » Tue Apr 01, 2008 1:03 am

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

Only with that knowledge could we proffer cogent advice.

BugFree · Post by **BugFree** » Tue Apr 01, 2008 1:03 am

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

bkumar103 · Post by **bkumar103** » Tue Apr 01, 2008 5:27 am

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.

ray.wurlod · Post by **ray.wurlod** » Tue Apr 01, 2008 6:11 am

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.