Hi How can I separate these first 9 digits in a column? I dont know exactly the formula using the regex tool.
Field | Expected Output |
105730408 CBCLH-/PUB() CA-IntB-JPY-000910021960 | 105730408 |
105730407 PRC-/PUB() CA-IntB-USD-000910021971 | 105730407 |
Can you help me with this one please?
Solved! Go to Solution.
Please use the below formula in Regex tool
(\d+)
Output method = Parse
Many thanks
Shanker V