I have a text file that includes a lot of rows. I want to filer out all the rows that begin with three letters. For example,
B12821392073
IPS 323231233
B31238920382
IPT 123289328
CES 31231232
I want to get "IPS 323231233", "IPT 123289328" and "CES 31231232".
Since this is a text file, I assume RegEx + Filter tool combination is needed.
Solved! Go to Solution.
You can use RegEx directly in a filter tool: REGEX_Match([Text], "\u{3}.*")
Thank you @atcodedog05 and @Christina_H for your prompt responses!
Happy to help : ) @45179902
If our response works please don't forget to mark it as solution.
Cheers and have a nice day!