Can someone help me out in finding regex for alphanumeric strings.

[Jazzy]

I need  help regarding these 2 mentioned questions.

1 - Create a macro that checks whether records of the single string input field, contain only
alphanumeric characters. Macro should create a new field ‘Alphanumeric’ which will have
values as follows:
True – if record is an alphanumeric string
False – if record is not an alphanumeric string.

2 -  Create an analytic app for question 1. Take input from user in a textbox and determine
whether it is an alphanumeric string or not.

[AngelosPachis · Accepted solution]

Hi @Jazzy ,

So in this new app, I've made the following changes:

1) Replaced the .txt input with a csv file

2) Included a generate rows tool, which every time the workflow runs will generate a single record to accommodate the new string inputted by the user

3) Then that new record will be stacked underneath the records coming from the input file (Union tool)

4) A summarize tool is used to make sure no duplicate records exist

5) Use a RegEx to check for the alphanumeric characters.

At the end of the workflow, I have added an output tool which will allow the user to replace the original input with the output of the workflow; that will contain the original records + the new record when the app was run.

In the apps interface there is a checkbox that asks the user if he/she wants to replace the original input file.

If that check box is checked, then the container will be enabled and the changes will be saved. If it is not checked (which might be good for testing purposes) the original input will remain untouched.

Let me know if that works for you.

Happy New Year

Angelos

[Jazzy]

TYSM...!