parse

[bh1789]

I am filtering data by a particular field that has different lengths:

VEsWRQ00cnvTZse4la0NYDzNrE=

M5wF51TW5UPOScmJWbqYpjVRAxw=

ElJzKc+9dh66LUctt8Sdpr53CMI=

and then every so many lines I receive data in error that looks like this:

1397=

Is there a way to remove the entire line of data when this particular field has only 5 characters?

Thank you,

[PanPP]

Hi @bh1789 

Can you provide an example of what the output would look like?

I have provided a sample WF that accomplishes this based on character length in a column.

Hope this helps, if it does please like this post and if it helps resolve your problem, mark it as a solution. If you have any other questions, please let us know.

[ShankerV]

Hi @bh1789    One way of doing this..

Input was:

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV]

Hi  @bh1789 

Could you please check and confirm whether it worked.

If yes, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[DenisZ]

You can use Length(String) != 5 to filter out all the lines that do not have a length of 5.