Unanswered

How to Convert comma seperated values to multiple raws

(0) Share

Report

Posted on by Ameer1

Hi,

I have created a flow which generated a word file from Excel sheet. I have dynamic fields in the word template which is filled by the data from the excel file. One of the columns in the excel file is comma separated values as below,

I have a new line after every value, But when i copy this value to the word file it gives me in one line. I tried using Strip function but doesn't work. The output shown below.

Any way better to procced?

Thank you

All responses (2)

Answers (0)

Ameer1 20 on at

Like (0)

Report

Re: How to Convert comma seperated values to multiple raws

Hi @v-jefferni,

That works perfectly. Thank you. Is there a way to coincide the Directives with Harmonised standards. For example, in the image you sent, the second line of Directive should be empty because the Harmonised standards is a continuation of the first line.

I have some order code in one column and if i want to make one document per one raw, is it possible to make a loop?

This is the Flow, where should i give the Loop?

Thank you.
v-jefferni on at

Like (0)

Report

Re: How to Convert comma seperated values to multiple raws

Hi @Ameer1 ,

Based on your description, I have made a simple test for your reference.

You cloud set the following property of Plain Text Properties to true.

Table:

Flow:

Result:

Best regards,