Refer to the post for detailed overview of the context where the replace is being used.

Bulk Import CSV to SharePoint with Power Automate

Options to Import Large tab delimited Data to SharePoint with Power Automate

Replace New lines

split(trim(body(‘Get_file_content’)), decodeUriComponent(’%0A’)) /r/n

Replace tab characters

split(item(), decodeURIComponent(’%09’)) /r

Replace carriage return

split(item(), decodeURIComponent(’%09’)) /t