Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello !
I have an excel file and I want to delete every lines which begin by "Sum". How can I do that ?
Thank you 😃
Annie
Look into the string functions part of the help, there are several you can use.
Something like
where index(field,'Sum') <> 1
Hi Annie,
you might use the load filter in the script.
It probably looks like:
filters(
Remove(Row, RowCnd(CellValue, 1, StrCnd(start, 'Sum')))
)
(i.e. snippet from
LOAD *
FROM
[Data.xlsx]
(ooxml, embedded labels, table is Quota, filters(
Remove(Row, RowCnd(CellValue, 1, StrCnd(start, 'Sum')))
));
If you use the table wizard in the script editor, there is a dialog for transformation steps, use conditional delete and set your requirements.
Stefan