For each row create file

Hello everybody,

For each different email I would like to create a file.

It’s possible ?

Thank !

whats the file format @mateo.drouillard

Excel file (.xlsx)

sorry

i mean how do you name each file?

name of file = email

so its

test1.xlsx? …

yes if is possible is perfect

Hi!

Read the excel using read range, Output as DtOut.

Take one for each row in data table activity

take one assign activity Create one string variable File=CurrentRow(3).ToString.Trim
take one more assign Activity\

Assign FileName = System.Text.RegularExpressions.Regex.match(File,".*(?=@)").ToString

Take one write range in the file pass FileName+“.xlsx”

DataTable as DtOut

Regards,
NaNi

1 Like

@mateo.drouillard
just do this

in excel application scope set filename = system.Text.RegularExpressions.Regex.Match(CurrentRow("Émettur DA").ToString, "(.*?)\@").Groups(1).Value+".xlsx"

make sure create if not exist is ticked

1 Like

it works but the created files are empty. And is it possible to put the corresponding data ?

yes, where you want the data? give an example… @mateo.drouillard

for exemple in test1.xlsx the file contains all rows where Émetteur DA = test1@safrangroup.com

can you upload this excel

TEST PUR05.xlsx (8.9 KB)

Thank !

here

TEST.xaml (11.8 KB)
@mateo.drouillard

1 Like

You are the best. Thank !

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.