How can I store the list variable in data table variable to read the number of columns.

Hi, good day! Can someone help me on how can I store the list variable in data table variable to read the number of columns? What I mean is that I wanted to read emails only with an email subject starts with “FLC” and contains invoice no. and receipt no. so I delimit it using space and assign output to list.

And if the email subject exceeds more than 2 sub strings I wanted to send a reply that the email is incorrect. Below is the sample correct and incorrect email subject from the vendors. Thanks in advance!

Page 1 / 1

Hi @Shusha321,

which package/action do you use for the email subject read?

Could you give more information what you are trying to do with the table please?

@Marc 1985 These are the actions I’m using.

@Shusha321 how should the data table look like?

Or what should the IF statement check? (need to understand why the table is needed)

You can split your string on the basis of delimiter, this will output into a list.
Check the size of this list, instead of trying to convert to data table.

@Shusha321

IF list size is equal “3” it is correct ELSE incorrect

What do you think?

Cheers

Marc

@Marc 1985 In if statement I wanted to get those email subject includes “FLC” and the email subject does not exceeds to 2 substrings. I was stuck on the second condition cause I don’t know what action should I used.

@Shusha321 have you seen my post above?