I've built a couple of options for you.
I've used a variable called text that contains your data.
You can use the following expression to remove the first and last lines, including the new line characters.
replace(replace(variables('text'), concat('Base64ToString(', decodeUriComponent('%0A')), ''), concat(')', decodeUriComponent('%0A')), '')
However, it looks like you actually want to extract the data, so you could actually do the following.
See full flow below. I'll go into each of the actions.
Initialize variable is what we had before - string variable called text that contains your full string.
Compose splits the string by new line character to give you an array of strings. We also use skip to exclude the first two rows. The expression used is.
skip(split(variables('text'), decodeUriComponent('%0A')), 2)
Filter array then takes that data and removes any items that are ")" which is our last extra line. The expression used is:
item()
Finally, we have a Select that takes in the output from our Filter array and builds up each of the objects. Below are the expressions used:
//Title
split(item(), ',')?[0]
//Date
split(item(), ',')?[1]
//Department
split(item(), ',')?[2]
After running the flow, we would get the following output from our Select.
[
{
"Title": "Test 1",
"Date": "2022-12-30",
"Department": "NY"
},
{
"Title": "Test 3",
"Date": "2022-12-31",
"Department": "PARIS"
},
{
"Title": "Test 5",
"Date": "2023-03-04",
"Department": "NY"
},
{
"Title": "Test 6",
"Date": "2023-07-01",
"Department": "LONDON"
},
{
"Title": "Test 2",
"Date": "2023-01-21",
"Department": "PARIS"
}
]
----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.
