Requierements Gateway Excel

[j_dodek]

Hello,

I am fighting against some regular expressions! in a dark environment. Because the excel file is

generated in an intermidiate textfile. 

Is there a way to turn on the light?

Is this file somewhere on the file drive?

Regards

Juergen

[Rohama_K · Accepted solution]

Hi j_dedek,

If you would like to retain the intermediate file, enable the Intermediate file option for your document. This will place the intermediate file in a folder called intermediate, which will be in the current project directory.

You can test expressions using the Regular expression tester. Directions on how to do that are below:

1. While in the Configuration window, click on the Expressions button on the left to get to the Expressions Pane.
2. Click on File » Import File or Import Directory, or Import Intermediate file, depending on what you are trying to test. At this point, you should see the text from the document in the Text analysis zone.
3. Enter a regular expression in the Regular expression control.
4. Click the Test button. If there are matches to the expression, the results will be displayed; otherwise it will say Text doesn't contain any correspondence with the regular expression. 

You can also use the regular expression tester to show all the groups (which are what are in the parentheses in the regular expression). You will notice in the screenshot below, there is a Text field that shows the entire line the match was found in.

 

Hope this helps!

[j_dodek]

Hi,

You turned on the light!

Excatly what i am looking for.

Thanks

Juergen