Hi Team,
I have column A and Column B.
I want in column A ( The filed should be in numeric only with lengths 6 else ''" or you can make it null.
I want Column B ( The filed should starts with Alphabet only else ''" or you can make it null.
A | B |
982345 | 123 |
982325 | J345 |
982325 | z34 |
982300 | d0 |
As0000 | 56j |
bs000 | s23 |
CD3340m | dd456 |
34564m | 12s |
Solved! Go to Solution.
formula tool - column a
if regex_match([A],"\d{6}") then [A] else "" endif
formula 2 for column B
if regex_match([B]."^\w.*") then [B} else "" endif
Thanks for your response however I am receiving error on Formula 2 " Parse error at character 18 Malformed function call expression 2"
Kindly help.
Hi
For column B
Please try this formula in Regex Tool >> ^[^a-zA-Z].*
this will select only data which starts with alphabets and remaining as null
output method >> Replace
replacement text >> null
Thanks for your response but I have never used regex tool. Could you please help me in setting
Did not work
in null place you can try with "" also
if this resolves your query please accept it as solution
please select only bold formula
no need for >>
Perfect
It worked now.
Hi, @mmustkee
1- Formula for [A]:
IIF(REGEX_Match([A], "^\d{6}$"),[A], Null())
2- Formula for [B]:
IIF(REGEX_Match([B], "^[[:alpha:]].*"),[B], Null())