Forum Discussion
selecting specific characters (3capital letters and 4numbers from a row field in a column
Dear, I have an renumbers only from a request how to split a specific combination of 3capital letters and 4numbers from a columns below written in red color: 2G/HUAWEI/Region5/Samawa/BSAMH01/Wark...
refer to regular expression
[A-Z]{3}\d{4}
as to 233 rows
try test regular expression here
http://e.anyoupin.cn/ceshi/jstest/pull_up_demo.php?s=extract_3
select *,regexp2('[A-Z]{3}\d{4}',F_A) Extract from extract_3capital_letters_and_4numbers
I use Charles Williams's FastExcel and his function rgx.MID worked well with your RegEx.
= Rgx.MID(Table1, "[A-Z]{3}\d{4}")
- good job👍
dear Peter i am using office 2019 and I need to to appreciated to send me a document how to write the proper query that i can write directly from A to Z because the last solution you sent me whenever i goto power query it's telling me that the i cannot use the solution within my excel power query because the reason above.
i am very appreciate yours efforts in advance.
