Skip to main content
Solved

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

  • February 26, 2025
  • 9 replies
  • 77 views

Forum|alt.badge.img+5

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!

 

Correct Email Subject Format
Incorrect Email Subject

 

Best answer by Marc Mueller

@Shusha321 

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

What do you think?

 

Cheers

Marc

 

 

View original
Did this topic help answer your question?

9 replies

Marc Mueller
Pathfinder Advocate | Tier 6
Forum|alt.badge.img+13
  • Pathfinder Advocate | Tier 6
  • 134 replies
  • February 26, 2025

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?


Forum|alt.badge.img+5
  • Author
  • Navigator | Tier 3
  • 20 replies
  • February 26, 2025

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

 


Marc Mueller
Pathfinder Advocate | Tier 6
Forum|alt.badge.img+13
  • Pathfinder Advocate | Tier 6
  • 134 replies
  • February 26, 2025

@Shusha321 how should the data table look like?

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


Forum|alt.badge.img+8
  • Navigator | Tier 3
  • 53 replies
  • February 26, 2025

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.


Marc Mueller
Pathfinder Advocate | Tier 6
Forum|alt.badge.img+13
  • Pathfinder Advocate | Tier 6
  • 134 replies
  • Answer
  • February 26, 2025

@Shusha321 

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

What do you think?

 

Cheers

Marc

 

 


Forum|alt.badge.img+5
  • Author
  • Navigator | Tier 3
  • 20 replies
  • February 26, 2025

@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.


Marc Mueller
Pathfinder Advocate | Tier 6
Forum|alt.badge.img+13
  • Pathfinder Advocate | Tier 6
  • 134 replies
  • February 26, 2025

@Shusha321 have you seen my post above? ☝👀 😊

 

Like this you mean?

 


Forum|alt.badge.img+5
  • Author
  • Navigator | Tier 3
  • 20 replies
  • February 26, 2025

@Marc 1985 Thank you so much for the assistance! now it’s a success. I can now moved on to the next step :)

 


Marc Mueller
Pathfinder Advocate | Tier 6
Forum|alt.badge.img+13
  • Pathfinder Advocate | Tier 6
  • 134 replies
  • February 26, 2025

@Shusha321 

I am glad that your obstacle is gone now… 😊

 

Cheers

Marc


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings