Creating Excel column and row from notepad

Hi,
I have use case creating excel from notepad. Like converting row from left side to excel column and its value as row. Attaching notepad file for reference.

BL ENTITY       SOURCE                                   RULE CODE
----------------      -----------------                              ----------------------
SDM                 DJOFAC (ID:000000)                000
ADM                 DJUSDS (ID:000000)                000

sample.html (6.4 KB)

1 Like

Hi @khalid

Any chance you could attach the actual .txt file? :slight_smile:

Also, any chance you could tell us how the columns should look like after processing? Like so?

BL ENTITY  | SOURCE             | RULE CODE
SDM        | DJOFAC (ID:000000) | 000
ADM        | DJUSDS (ID:000000) | 000
1 Like

Hi @loginerror

Thanks for reply. I have achieved it by reading the txt file and through string operation. I add string value in datatable then population excel with data table.

1 Like