Talend community forum / How to substring data from a multivalue column?

ectl_mun · 2012-04-30 06:33:10

Hello All,

I need help to extract the data from a multivalue column which are in Pipe delimeter.

My files are semicolon delimiter, and i have 1 column which having multivalue is with Pipe delimeter. Example:

545990;C545990;545990;Name-1;|||N||8100|W1|1|50-01-00-00-00-00-00|;545990;
545990;C545990;545990;Name-1;|||||3114|J1|63|50-15-60-63-00-00-00|;545990;
545990;C545990;545990;Name-1;|||Yes||3860|P1|63|50-15-60-63-00-00-00|N;545990;
545990;C545990;545990;Name-1;|||No||8130|W1|71|50-15-70-71-00-00-00|545990;

I want to extract the 8100, 3114,3860, 8130 from the multivalue column. Can i scan the "|" and get the value after the 5th "|" delimeter?

Please help!!

Thanks!

walkerca · 2012-04-30 13:30:40

Hi,

Try tNormalize. This blog post links to a video that shows an Excel example that can be modified for your text file.

http://bekwam.blogspot.com/2011/01/tuto … -with.html

Announcement

Unanswered posts

#1 2012-04-30 06:33:10

How to substring data from a multivalue column?

#2 2012-04-30 13:30:40

Re: How to substring data from a multivalue column?

Board footer