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

[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

[JDong]

Updated question with expected ouput @Ladarthure @Assaf_m 

[Ladarthure]

@JDong  here is a solution to do what you asked, I used a regex to find the one containing text so taht I sum everything which is not text, hope it answered your problem!

[grazitti_sapna]

Hi @JDong,

Here is my take on your problem:

 

I hope it helps

[JDong]

Hi @Ladarthure @grazitti_sapna 

Thanks.

What if data is in this format "50 - 100 Tsd."  instead of "50-100 K" in the cell.

How would the Regex expression change ?

Please advise

[Ladarthure]

@JDong it should still work if I am right! I am looking for any letter in the field

[JDong]

@Ladarthure  Can you please help !

Actually not getting the result. Tried updating the sample data.

6 10 - 50 K
8 No
1 10
2 0
3 58042.08
4 30
5 [Null]
7 [Null]

The Tsd. values are not getting populated.

Any thought please ? Attached the updated data in flow

[Ladarthure · Accepted solution]

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