Extract records from csv file which match certain criteria

(0) Share

Report

Posted on by KarlNixon

163

Example below

6 321557 6 09302021 0 0 0 4.0 10025955 9 4 CCDRI
8 321557 6 09302021 5 0 0 4.0 10025955 9 4 CCDRI
4 4293173100281909 09292021 74278241272000019493353
4 4293173100870057 09292021 74375881271066520771401
4 4293173100256307 09292021 74564721272353312350489
4 4293173101096215 09292021 74363961272000074878489
4 4293173101488099 09292021 74557021272031035640089
4 4293173101188848 09292021 74611551271138452937194
9 321557 6 09302021 5 8 89643 4.0 10025955 9 4 CCDRI
8 321557 6 09302021 6 0 0 4.0 10025955 9 4 CCDRI
4 321557 ABC CORPORATION PTY LTD 179 GEORGES LANE MELBOURNE
9 321557 6 09302021 6 1 0 4.0 10025955 9 4 CCDRI

I'm sure one of the SELECT function may achieve this but need help with the syntax.

Any assistance gratefully received

All responses (2)

Answers (1)

KarlNixon 163 on at

Like (1)

Report

Re: Extract records from csv file which match certain criteria

Thanks Damien - perfect
Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (2)

Report

Re: Extract records from csv file which match certain criteria

Hi @KarlNixon

Filter array is the one you are looking for. Split the CSV by a return line to create an array and then filter on item() starts with .

FROM: split(outputs('CSV'),outputs('ReturnLine'))

This gives you an end result:

As it is returning an array, you can use join() on the return line again, to recreate your csv if needed.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉