Specific Data required

[mmustkee]

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

[apathetichell]

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

[mmustkee]

@apathetichell

Thanks for your response however I am receiving error on Formula 2 " Parse error at character 18 Malformed function call expression 2"

Kindly help.

[BRRLL99 · Accepted solution]

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

[mmustkee]

Thanks for your response but I have never used regex tool. Could you please help me in setting 

[mmustkee]

Did not work

[BRRLL99]

in null place you can try with "" also
if this resolves your query please accept it as solution

[BRRLL99 · Accepted solution]

please select only bold formula

no need for >>

[mmustkee]

Perfect

It worked now.

[flying008]

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())