Power Platform Community Forum Thread Details

The functions are not doing anything on a string wit a lot of null (\u0000) carriage return (\r) and newline (\n) characters.

I'm trying to make a flow that is working with a .json file on an onprem server.

So in a nutshell:

1. Connector Filesystem (Get File content using path' over onprem datagateway working fine.

2.compose action with the output:

3. compose action with the base64ToString(outputs('Get_file_content_using_path')?['body']?['$content'])

4. no matter if I clean this content or not (removing ��) I need to replace the null bytes (\u0000) newline and other 'trash' values (\r, \n)

5. next expression does not do their job, no error but same value as output:

replace(outputs('DecodedContent'), '\u0000', '')
replace(outputs('DecodedContent'), '\x00', ''),
replace(outputs('DecodedContent'), '\0', ''),
replace(outputs('DecodedContent'), '\r', ''),
replace(string(outputs('DecodedContent')), '\n', '')

6. Splitting the string also does not work completely:

split(string(concat('{', first(split(last(split(outputs('DecodedContent'), '{')), '}')), '}')), ',')

output:

So the first split does not work, there is no split action based on the comma ',' but the concat function containing two working split functions based on the '{' and '}' character.

I do not have a clue anymore what I can possibly do to solve this issue.

Any ideas are welcome

Thank you

Categories:

General topics

Community site session details

Replace and split function not working on a string

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates