help me to grep list of coloumn numbers in csv file

%3CLINGO-SUB%20id%3D%22lingo-sub-2887652%22%20slang%3D%22en-US%22%3Ehelp%20me%20to%20grep%20list%20of%20coloumn%20numbers%20in%20csv%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2887652%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fstackoverflow.com%2Fquestions%2F69729027%2Fi-need-to-extract-datafor-a-set-of-particular-coloumn-number-of-a-csv-file%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fstackoverflow.com%2Fquestions%2F69729027%2Fi-need-to-extract-datafor-a-set-of-particular-coloumn-number-of-a-csv-file%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2887652%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2887883%22%20slang%3D%22en-US%22%3ERe%3A%20help%20me%20to%20grep%20list%20of%20coloumn%20numbers%20in%20csv%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2887883%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1196788%22%20target%3D%22_blank%22%3E%40deadshot1680%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20job%20for%20Power%20Query%3C%2FP%3E%0A%3CP%3E1)%20query%20the%20table%20with%20column%20numbers%2C%20in%20editor%20add%20prefix%20%22Column%22.%20Let%20say%20that%20is%20table%20Columns%20which%20has%20only%20one%20column%20Number%3C%2FP%3E%0A%3CP%3E2)%20query%20csv%20file%20and%20add%20step%20Table.SelectColumns(Source%2C%20Columns%5BNumber%5D)%3C%2FP%3E%0A%3CP%3E3)%20land%20result%20into%20Excel%20sheet%3C%2FP%3E%3C%2FLINGO-BODY%3E
1 Reply

@deadshot1680 

That's job for Power Query

1) query the table with column numbers, in editor add prefix "Column". Let say that is table Columns which has only one column Number

2) query csv file and add step Table.SelectColumns(Source, Columns[Number])

3) land result into Excel sheet