Hello, I am currently practicing the filtering of data in AE.
I currently have a csv file, and, in this file, I have a column named CurrentMoney.
Now this column contains data in a currency format like $123,456.78, $120.00, $0.80 and so on.
Now I do want to filter out and extract all user info wherein those who have greater than $100.00 will be moved to another newly created csv file.
So, it’s basically in a query it’s like SELECT * FROM tbl_users WHERE CurrentMoney > 100.00;
I am currently having difficulties with the validation of the data, since I want to preserve the currency format as well while performing the statement.
Well, I do understand the logic behind it. However, since I am still new, I do not know which plugin will help me to achieve this.