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.
Solved! Go to Solution.
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!
While I'd probably do something similar to @Kenda an alternate is to use Text to Columns:
Sample attached
REGEX_Replace([Field1], "(.*)\,?.*", "$1")
This is not working .the source Columni s having VW_String data type.
@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")
Ts working fine now
Thank you