Sorting Data

[kirangottu]

empno

123,345,567

5666,789,8787

42,3345,46546

2,324234,35345,345456

234234234,3434,3434

I want to load first comma value in target.

expected:

empno

123

5666

42

2

234234234

CAn u pls send me the workflow.

[Kenda]

Hey @kirangottu! I was able tot get your expected values using this expression in a simple Formula tool:

REGEX_Replace([Field1], "(.*)\,?.*", "$1")

RegEx is awesome and comes in handy in many situations like this one. Hope this helps!

[jdunkerley79]

While I'd probably do something similar to @Kenda an alternate is to use Text to Columns:

Sample attached

[kirangottu]

REGEX_Replace([Field1], "(.*)\,?.*", "$1")

This is not working .the source Columni s having VW_String data type.

[Kenda · Accepted solution]

@kirangottu That's odd that it was working for me but now isn't. Try moving the question mark inside the parentheses like this:

REGEX_Replace([Field1], "(.*?)\,.*", "$1")

[kirangottu]

Ts working fine now

Thank you