Hi All, I have a file which is coming from an External system in .dat form

Hi Harsha,
Did you try this custom function 'getdatafromdocument'.
If not here is the link..
forum.appian.com/.../summary

Harsha, my personal choice would be to use an expression rule in fn!reduce() loop, instead of using a custom function. of course you have to write that specific expression rule to fetch first element, then pass the remaining string to next function in fn!reduce() loop.

Hi , can you please resent the link, as the above link is not working, to fetch data from .dat file extension

Hi Lokesh, You can try using ReadTextFromFile() available in File Reader Plugin (v1.0.1) . This function can help with reading the data within the file and pulling it in Appian.

hi
you can try providing file name as "filename.csv" as you are saving file in appian, rather then dat, then user excel to CDT smart service