Difficulty in parsing column

[sriniprad08]

Hi Team,

Hope you are well. i have a column which has different categories.

if the numbers after the 'cxl' needs to be split into different columns. they have varying field. so the number of column has to be dynamically created to accomodate numbers.

Please let me know how to go about it?

thank

Sri

[PhilipMannering]

Sure @sriniprad08. Please see attached,

[sriniprad08]

Hi @martinding ,

The previous workflow is not picking the below example where its separated by comma, can you please help?

thanks

[sriniprad08]

Hi @PhilipMannering ,

thank you . sorry where should i change please? + to "*"

[PhilipMannering]

The first one. See the attachment in my previous comment.

[martinding · Accepted solution]

Hi @sriniprad08,

I've made a simple change to the Regex, under one assumption: that the dates following the contract are always in the form of dd.mm.yyyy, rather than ddmmyyyy.