Hi All, I have a column which is a formula field and combination of a string and float field. The grouping based on Sl No does not work since the end field is a V_WString field. Sl NoColumn110 - 50 K20325042.08333000410 - 50 K410 - 50 K410 - 50 K5[Null]610 - 50 K7[Null]8No Above is the table and please guide how to group based on the SlNo since it does not work. Expected Sl NoColumn110 - 50 K20358042410 - 50 K5[Null]610 - 50 K7[Null]8No Thanks

Hi @JDong, here is the updated RegEx : REGEX_Match([Column], '.*[[:alpha:]]+.*') if I translate it in english it means : * .** 0 or more of any char type * [[:alpha:]]+* one or more letter * .* ending with 0 or more of any char

Column Grouping values

JDong

Hi All,

I have a column which is a formula field and combination of a string and float field.

The grouping based on Sl No does not work since the end field is a V_WString field.

Sl No	Column
1	10 - 50 K
2	0
3	25042.08
3	33000
4	10 - 50 K
4	10 - 50 K
4	10 - 50 K
5	[Null]
6	10 - 50 K
7	[Null]
8	No

Above is the table and please guide how to group based on the SlNo since it does not work.

Expected

Sl No	Column
1	10 - 50 K
2	0
3	58042
4	10 - 50 K
5	[Null]
6	10 - 50 K
7	[Null]
8	No

Thanks

Developer

Expression

Accepted answers

Ladarthure

Hi @JDong,

here is the updated RegEx : REGEX_Match([Column], '.*[[:alpha:]]+.*')

if I translate it in english it means :

.*
- 0 or more of any char type
[[:alpha:]]+
- one or more letter
.* ending with 0 or more of any char

All comments

Ladarthure

Hi @JDong,

could you show us what result would you expect?

Assaf_m

Attached is a quick solution.

Please let me know if it works for you

Grouping.yxmd

JDong

Updated question with expected ouput @Ladarthure @Assaf_m

grazitti_sapna

Hi @JDong,

Here is my take on your problem:

I hope it helps

regex_match.yxmd

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335