How to write Text file data in excel

Hello everyone,
I need you to help me with this , how do i write the text data in excel which is in table format

here highlighted text data should be written in column 3(System) and sometimes it may be missing, it should be left empty in excel while writing

Here is the text file
Text_extraction.txt (1.2 KB)

Help me write this data in excel
Output.xlsx (8.9 KB)

Hi @nisarga

Please check the below files and xaml attached. Please check and let me know if any modifications needed.

Excel File:
Output.xlsx (8.6 KB)

Xaml:
Sequence6.xaml (10.5 KB)

Regards

@vrdabberu
In output file along with column3, title column and account code should also be filled

i need to write these data in excel
note: here some data may not be present , in that case the cell should be left blank
sample format:
image

Hi @nisarga

Please check now:

Excel Ouput:
Output.xlsx (9.1 KB)

Xaml:
Sequence6.xaml (12.3 KB)

Regards

Hi @nisarga

Have your query resolved?

Regards

Nope ,can u help me if any data is missing in account code column it should be left empty but instead it is skipping entire row data and writing next row data
regards,

Hey @nisarga, Please check this solution and let me know it contains the output sheet and the input file in it

BlankProcess.zip (11.0 KB)