HI All,
We need to read a formatted text file and then convert it to Excel sheet with headers and data.
We need to create a single row for each supplier details in excel sheet along with the data per headers.
Has anyone got such a requirement?
Can you please suggest a way?
Sample file is below
/cfs-file/__key/communityserver-discussions-components-files/11/ExpenseReport.txt
Discussion posts and replies are publicly visible
This file seems to be created for human consumption. Not to import it again.
Did you consider to use an LLM to extract the individual data values?
ohk. Will we have to write a Java Plugin or use Open AI services for it? Is there anything available in appian for the same?
The latest Appian version has the built-in Prompt Builder AI skill. But this might need additional licensing. But you could use any LLM AI service. I am not sure whether this works, but LLMs are pretty good in extracting structured data out of such a mess. Keep in mind that, even if it works, is no 100% solution. That's a risk you will have to discuss in your team.
ohk. Thanks. It seems there is no other way of parsing it.