Why is the 'not exists' filter not working with Text Parser

How To
,
1

What are you trying to achieve?

My goal is to use a Text Parser to notify me which of my spreadsheet rows have faulty postal codes. To do so, I’m doing a filter after the parser for “Value Exists” and correspondingly “Value Does Not Exist”. While the correct output appears for the cases where the postal code pattern is correct, the others do not return anything.

Steps taken so far

I have the data in the spreadsheet (similar to the postal code example in the Advanced Course Regex Chapter 4). I use the Switch module to make a case for each pattern (Japan, Italy, UK, France), and then feed it to the Advanced Match Pattern. I make a router have one route each for the pattern value existing and not existing. I want the row numbers of successful rows in the upper flow, the and others in the lower flow. The upper works, but not the lower one.

Screenshots: scenario setup, module configuration, errors

blueprint.json (37.2 KB)

2

Welcome to the Make community!

You have not yet provided sufficient information to demonstrate the problem that would allow us to reproduce the scenario and any error(s).

To allow others to assist you with your scenario, please provide the following:

1. Relevant Screenshots

Could you please share screenshots of your full scenario? Also include screenshots of any error messages, module settings (fields), relevant filter settings (conditions), and module output bundles. We need to see what you’re working with to give you the best advice.

You can upload images here using the Upload icon in the text editor:

3. Output Bundles of Modules

Please provide the output bundles of each of the relevant modules by running the scenario (you can also get this without re-running your scenario from the History tab).

Click on the white speech bubbles on the top-right of each module and select “Download input/output bundles”.

490×338 23.5 KB

A. Upload as a Text File

Save each bundle contents in a plain text editor (without formatting) as a bundle.txt file.

You can upload the file here by clicking on this button:

B. Insert as Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
These are the two ways to format text so that it won’t be modified by the forum:

  • Method 1: Type code block manually

    Add three backticks ``` before and after the content/bundle, like this:

    ```
    content goes here
    ```

  • Method 2. Highlight and click the format button in the editor

Providing the input/output bundles will allow others to replicate what is going on in the scenario, especially if there are complex data structures (nested arrays and collections) or if external services are involved.

Sharing these details will make it easier for others to assist you.