For each different email I would like to create a file.
It’s possible ?
whats the file format @mateo.drouillard
Excel file (.xlsx)
i mean how do you name each file?
name of file = email
yes if is possible is perfect
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
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
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 = email@example.com
TEST PUR05.xlsx (8.9 KB)
You are the best. Thank !
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.