I would need to parse each line of .txt file. Actually I downloaded the Shared C

patrickp over 9 years ago

I would need to parse each line of .txt file. Actually I downloaded the Shared Component GetData and I'm using the Getdatafromdocument() function but unfortunately I'm not able to split each line. I already tried to catch the char(10) and char(13) but it didn't work properly.
I should apply some rules for each row and that's why it would be really important to save the content line by line in a pv!singleRow.
Is it possible to identify a row, analyze it and then proceed to the next row?
Thanks in advance!...

Discussion posts and replies are publicly visible

0 elizabeth.epstein over 9 years ago

Here is a plugin I wrote that reads text from various file types, with the option to preserve linebreaks. It might help you with what you need. Note that this hasn't been reviewed by the Cloud team (if you need it on Appian Cloud i can submit it) and probably hasn't been tested as extensively as the GetData component.

The expression function is readTextFromFile()
com.appiancorp.plugins.filereader-1.0.0.jar
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sanketh over 9 years ago

nice plugin Elizabeth thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 radhaa over 9 years ago

Hey Elizabeth, it works really nice for text files. If I use docx file it is giving attached output.
will this support docx files?
Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Michael Tan
Appian Employee
over 9 years ago

Radha, I don't believe this expression is expected to work with a docx. Docx (and xlsx) file extensions are simply zipped archives with directories of xml documents. It is a round about way to achieve your use case of reading the docx, but you can use the "Archive Utilities" shared component to unzip the docx and then read the document.xml file inside the word folder.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 patrickp over 9 years ago

I've just tried your plugin and worked fine.
Thanks Elizabeth!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 radhaa over 9 years ago

yes Michael. I think thats the only solution to parse docx file.
Any how thanks Lizzie and michel. :)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 lincolnf454 over 9 years ago

This plugin was exactly what I needed too, thanks Lizzie
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 manibabua over 8 years ago

Hi elizabeth.epstein .I could'nt find this plugin in shared components . (com.appiancorp.plugins.filereader-1.0.0) .Can you share me the link to download this?
Thanks in advance.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 lesliem over 8 years ago

I am unable to find the link for this plugin as well. Can you please share the link with me as well?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 elizabeth.epstein over 8 years ago

The filereader plugin is attached in this thread. See my first comment.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel