Expression for parsing a tab separated text/flat file, using Logic Apps
In an earlier post (https://www.blogger.com/blog/post/edit/2520883737187850604/6852187532033424242), we talked about parsing a CSV/Excel file to feed data into D365F&O, this post is a kinda corollary to that, here we'll be talking about parsing 'a tab separated' document, the necessary expression for the same. Suppose we have a file content like this: SalesPool Id Company Name Poo01122 USPM Pool 11222 Poo01123 USPM Pool 11223 Poo01124 USPM Pool 11224 Poo01125 USPM Pool 11225 Poo01126 USPM Pool 11226 As you've rightly guessed, its a tab separated file. In the control connecter where you are getting the content of the file >> you can use the following expression could help you to transform the incoming content into an array: split(decodeUriComponent(replace(replace(replace(uriComponent(body('Get_file_content_using_path')), '%0D', ''), '%09', ';'),'%0A', '#NEWLINE#')), '#NEWLINE#&