Forum Discussion

divumj's avatar
divumj
Helper I
1 year ago
Solved

Data filtering and deleting basis tect

GM All

 

I am looking for a solution where I would like to find specific text in one column that to first occurence as I have multiple values in same column.

 

Once it identified we need to delete all the data above that. For e.g. I am looking for text having abc and I have first occurence on row 5000 having field 123abc.

 

 

Tips and Tricks

6 Replies

  • AlienSx's avatar
    AlienSx
    Super User
    1 year ago
    Table.Skip(your_table, (x) => not Text.Contains(x[column_name], "specific_text"))
  • divumj's avatar
    divumj
    Helper I
    1 year ago

    AlienSx 

     

    This will remove entire data... requirment is to find it and remove all data above that , that to for first occurence...

     

    As my data had multiple text having that data and we don't want to remove all data...only for the first one from the top

      • divumj's avatar
        divumj
        Helper I
        1 year ago

        AlienSx not able to apply that...could you please gave me excel working examples...ask is that first need to check the first occurence for text with contain function and then delete the above all data only...