Getting values from column data

TarunDeep

Hi,

I am getting below line as a value in one of the columns from my input. I want to extract specific information from this value as below. 

Value:

com.xyz.xx.service.run.Run@511de277[id=11293,rvi=49989,state=ACTIVE,name=OUTSIDE XX2W 19.11,startDate=2019-05-22T09:29:55.687-04:00,endDate=2019-06-05T09:29:00.000-04:00,completeDate=<null>,sequence=11293]

I want below output values in seperate columns as:

id=11293

rvi=49989

state=ACTIVE

name=OUTSIDE XX2W 19.11

startDate=2019-05-22T09:29:55.687-04:00

endDate=2019-06-05T09:29:00.000-04:00

completeDate=<null>

Is it possible?

Thableaus

Hi @TarunDeep 

Here's a solution:

- Use Regex to isolate what is in brackets - REGEX_Replace([Field1], "^.*\[(.*?)\]$", "$1")

- Text To columns to split to rows comma separated values

- Split again with text to columns - to columns (using "=" delimiter)

- Cross-Tab using the values on the left of the equal sign as columns

WF attached.

Cheers,

ColumnData.yxmd