Convert text to columns

[geeklarokcmie]

Hello,

I'm looking to convert values in Summary and Description field to date and number columns. 

Input: 

Summary	Desc
Error Report for 11/1	There were 88 active error for 11/1 NCS: 80 Errors  Tow: 0 Errors Tage: 8 Errors CG: 0 Errors Â
Error Report for 11/5	There were 87 active error for 11/5 NCS: 0 Errors  Tow: 0 Errors Tage: 77 Errors CG: 10 Errors

Expected Output:

	Systems	CG	TOW	NCS	TAGE
Dates	Active Errors	Errors	Errors	Errors	Errors
11/1/2024	88	0	0	80	8
11/5/2024	87	10	0	0	77

[cpet13]

@geeklarokcmie a REGEX tool would probably help you get what you need. You could use that to parse out the fields and get the values you are looking for. Are the values in the DESC field stored as tab separated items, line breaks, or how?

[geeklarokcmie]

Values in the Description field are separated into multiple lines with space after each line

[cpet13]

@geeklarokcmie here is an example of how you could use the Regex tool to get yourself started. If the errors are always going to be in that same order, you could simply use a select tool after and rename Errors1 to be NCS, Errors2 to be TOW, etc. You would then just need the digits portion of the regex tool to be returned.

[Qiu · Accepted solution]

@geeklarokcmie 
Parsing non-structured data is not requiring much skills but just patience. 😁
here is my try on this.

[flying008]

Hi, @geeklarokcmie 

FYI.