Hi,
Column Result
Finance Desc 12345678 12345678 Finance Desc
12345678 Description 12345678 Description
des 12345678 12345678 des
Description Description
My Task is. first number should come and then desc has to come. See the result field for reference. if number is not vailable it should come only description in the result. Kindly suggest how to write regex for this. Thanks in advance
Regards,
DG
Solved! Go to Solution.
@Dg_Reddy You can use two parse text actions, One is to retrieve the Text and other is to Retrieve the number.
To retrieve text you need to use [A-Z,a-z,\s?]+ as regex in the parse text action and \d+ to retrieve the number.
I hope this helps you.
@Dg_Reddy You can use two parse text actions, One is to retrieve the Text and other is to Retrieve the number.
To retrieve text you need to use [A-Z,a-z,\s?]+ as regex in the parse text action and \d+ to retrieve the number.
I hope this helps you.
@Dg_Reddy You can use two parse text actions, One is to retrieve the Text and other is to Retrieve the number.
To retrieve text you need to use [A-Z,a-z,\s?]+ as regex in the parse text action and \d+ to retrieve the number.
I hope this helps you.
@Dg_Reddy You can use two parse text actions, One is to retrieve the Text and other is to Retrieve the number.
To retrieve text you need to use [A-Z,a-z,\s?]+ as regex in the parse text action and \d+ to retrieve the number.
I hope this helps you.
This is worked but some times description is having number. kindly provide regex for
ex:
Column: Result:
Finance 12345 12345678 12345678 Finance 12345
1) Find 8 Digit Number - 12345678
2) Find Rest of all apart from 8 Digit Number - Finance 12345
??
thanks in advance