How to divide csv columns

[Anonymous]

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

[akumar2301]

can you please explain it with sample input and output

[Anonymous]

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

[TRF]

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            |
+---------+-----------------+