Importing Log to Dataverse

(0) Share

Report

Posted on by KDR

Hi,

I'm getting a text-file like

Oct 17 00:44:08 Information1|Information2|Information3<CR>
Oct 17 00:44:08 Information1|Information2|Information3<CR>

....

which I would like to get into dataverse. I already found the trick to split it into an array using

split(outputs('Compose_-_Read_in_File'), decodeUriComponent('%0D%0A'))

but I would like to have it like

Date: Oct 17 00:44:08

Variable1:Information1

Variable2:Information2

Variable3:Information3

But when I created this array, I did not come forward. Either I expect a string (but how to import multiple lines) or the array split did not work when I nest the logic.

thanks for the help

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

v-liwei-msft on at

Like (0)

Report
Re: Importing Log to Dataverse

Hi @KDR

Could you please tell me:

Do you want to split the text into an array with newlines as delimiters?

I have made a test for your referecne:

1.

split(outputs('Compose'),decodeUriComponent('%0A'))

2.

join(take(split(first(split(item(),'|')),' '),3),' ') last(split(first(split(item(),'|')),' ')) split(item(),'|')[1] replace(last(split(item(),'|')),'<CR>','')

3.

Best Regards,

Levi

Was this reply helpful? Yes No
KDR 2 on at

Like (0)

Report

Re: Importing Log to Dataverse

Dear Levi

Thanks for this really good help and content. Just for my understanding - regarding join(take(split(first(split(item(),'|')),' '),3),' ')

Is the Logic starting from inner to outer? So we have

Oct 17 00:44:08 Information1|Information2|Information3<CR>

First split(item(),'|' to have

Oct 17 00:44:08 Information1

then
(first(....
Does it take the Space (X) from the right of Oct 17 00:44:08X ?
but was does
(split(...),3)
do?
I assume it split to
Oct
17
00:44:08
And the join(...) then put them "together" again?

Was this reply helpful? Yes No