How to filter from excel rows that contains letters

Learn Academy Feedback
1

Hello,
I’m trying to filter my rows to get only numbers. But I can’t find a solution for the letters. I need to filter all the letters from alphabet.

Thank you.
image

2

Hello @LucasCosta,
Welcome to the Community!
You can do this by extracting text (Substring or Regex) from particular cell. Can you explain why do you need to filter by letters?

1 Like
3

@LucasCosta

Could you please tell more details for better understanding and filtering in the sense ?

1 Like
4

Of couse!
I need to filter becouse my store data should have only numbers.
I need that all rows from the excel file which has a character to be removed. So i can only pass to the program that rows that contains numbers. I could create an condition for all letters, but it would take a loooong time. I’ve tried to use an array with all the letters inside, but it was unsuccessfully.

appreciate the fast reply, thank you all.

5

I see familiar things. Are you working with this on Level 3 training? If yes you have there very good written walkthrough document:
image
Look at page 10 where is Flow Decision activity described based on “double.Parse”. It’s a perfect solution for this.

1 Like
6

Thank you, was trying to do without looking the walkthrough.

I’ll come back if new doubt appear.

1 Like
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.