How to convert text file data into excel format

Hi ,

I want to Validate one keyword from the text file for that i need to convert text file data into excel format. so is there any way in workfusion by which we can convert text file data into excel format. Help would be much appreciated. Thanks.

Hi @meghasoni, good day.

Here’s the example for your reference.
There are some .txt files in the folder of ‘C:\Temp\ValidateText’.
If the text file contains ‘test’, then create one new Excel file and input contents.
image

Main method: Get Folder Contents -> For Each -> Read File -> If contains ‘test’ ->
Create empty Excel file -> Input content -> Save

Capture of Actions Flow:
*Need to change the value of the ‘folder’ variable.

Reference File:
ValidateText.zip (2.0 KB) 1.txt (18 Bytes) 2.txt (12 Bytes)