Parsing a variable length text field

Anonymous — Wed, 17 Oct 2018 16:21:35 GMT

Hello community, please help!

I have a table with the following values:

profile_id | vul_id

'1' |'33 - .10\n34 - .10\n56 - .10\n57 - .20\n58 - .25\n'
'2' |'5 - .5\n6 - .5'
'3' |'8 - .5'
'4' |'4 - .1\n24 - .25\n25 - .25\n26 - .15\n27 - .25'

I need to parse it in a following manner: (multiplying each record according to the number of values in the Vul_id column:

profile_id | vul_id | weight

'1' |'33' | .1
'1' |'34' | .1
'1' | '56' | .1
'1' | '57' | .2
'1' |'58' | .25
'2' |'5' | .5
'2' |'6' | .5
'3' |'8' | .5
'4' |'4' | .1
'4' | '24' | .25
'4' | '25' | .25
'4' |'26' | .15
'4' |'27' | .25

Please suggest how to approach this task

Re: Parsing a variable length text field

Anonymous — Mon, 22 Oct 2018 05:55:45 GMT

Hello,

Could you please let us know if this community knowledge article helps?

https://community.talend.com/t5/Migration-Configuration-and/Converting-columns-to-rows/ta-p/21658

Best regards

Sabrina

topic Re: Parsing a variable length text field in Talend Studio

Parsing a variable length text field

Re: Parsing a variable length text field