topic How to divide csv columns in Talend Studio

How to divide csv columns

Anonymous — Sat, 16 Nov 2024 06:07:15 GMT

Hello,

I have a csv file, where there "are" columns but its basicly everything in 1st column even when there are spaces between the needed columns.

What way can I divide the column into more than one and how do I set the conditions so it knows which part should be i next column.

Thanks for help

Re: How to divide csv columns

akumar2301 — Tue, 09 Apr 2019 13:37:22 GMT

can you please explain it with sample input and output

Re: How to divide csv columns

Anonymous — Tue, 09 Apr 2019 13:49:50 GMT

I Input a csv file, where there is 1 row and 1 column (as in attachment) and output should be that these 5 potentional columns (vserver/volume/index/tree/Disk) are actually become 5 columns one in each with its infromation below (DISK - 5555).

example.png

Re: How to divide csv columns

TRF — Wed, 10 Apr 2019 09:02:42 GMT

tMap and String.split() are your friends for that:

Here is the result:

.---------------------------.
|      #1. tLogRow_12       |
+---------+-----------------+
| key     | value           |
+---------+-----------------+
| vserver | XXXXXX          |
| volume  | AAAAAAAAAAAAAAA |
| index   | BBBBBBBBBB      |
| tree    | DDDDDDDDDDDD    |
| disk    | 5555            |
+---------+-----------------+