Delete lines which begin with "Sum"

[#1]

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

[danielrozental]

Look into the string functions part of the help, there are several you can use.

Something like

where index(field,'Sum') <> 1

[swuehl]

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