How Can we write validated from [Create validation task and wait activity]?

[annet_mdamugade]

-How Can we write validated data from [Create validation task and wait activity] to excel?
-i want to write data to excel in to various fields eg. Date, Asset etc
-Go through image as follows

-in that image [message box]there are column name and their value i want to write into excel.

[lrtetala (Lakshman Reddy)]

Hi @annet_mdamugade

Use Generate DataTable from Text activity and then use Write Range Workbook activity

Regards,

[lrtetala (Lakshman Reddy)]

@annet_mdamugade

Output:

Regards,

[lrtetala (Lakshman Reddy)]

@annet_mdamugade

If you want only specific fields by using Regex you can extract it

(?<=Asset:\s+).*

System.Text.RegularExpressions.Regex.Match(Input,"(?<=Asset:\s+).*").Value

(?<=Date:\s+).*

System.Text.RegularExpressions.Regex.Match(Input,"(?<=Date:\s+).*").Value

Regards,

[pradeep931 (Pradeep Bandharam)]

@annet_mdamugade

Create a DataTable with the required fields using the Build DataTable activity. Perform split operations using Environment.NewLine and then split again by ":" . Finally, use the Add Data Row activity to add the extracted values to the DataTable