How to convert a single row into multiple rows

0

Hi,

I have a file that contains fields in a single row e.g

12,13,45,01,05

I would like to write out these fields as seperate rows in a new file e.g

12

13

45

01

05

How do I go about it?

I would appreciate any help.

Thanks

jstrydom's picture
Joined: Aug 19 2009 - 5:36pm
Last seen: 10 years 2 months ago

3 Answers:

0

I believe the tNormalize component should meet your request.

Basically all you need to select is Column and Item seperator.

HTH

Cheers,

         Stas

stasp's picture
15564
Joined: Jun 3 2009 - 9:53am
Last seen: 6 hours 49 min ago
0

Thanks,

I'm just wondering wich column to select, because it's not really a normalization. Do you have to select a column?

 

Johan

jstrydom's picture
Joined: Aug 19 2009 - 5:36pm
Last seen: 10 years 2 months ago
0

Although it's not really a normalization, you are putting values into some column. I'm not sure if it'll work properly without any column defined.

The component description says: "Select the column from the input flow which the normalization is based on"

You'll have to try and see how it works, but I guess you'll need to define some column name if you don't have one.

stasp's picture
15564
Joined: Jun 3 2009 - 9:53am
Last seen: 6 hours 49 min ago
Feedback
randomness