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 · Accepted solution]

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,

[TarunDeep]

Thank you @Thableaus That is what I wanted. It was quick. 

[Thableaus]

@TarunDeep 

You're welcome, my friend.

Just another tip:

If you have many strings like these in rows, you can use a Record ID to properly order the results:

- Add the Record ID and then group by in your Cross Tab Tool.

Cheers,