Need Regex to get a number

Hi Team,

I wanted to pick all the 10 digit numbers which are next to line to the text “,OES,IQ,OES_CMP_READY” please help me to get the regex in matches activity.

SOURCE_SYSTEM_ORDER_ID,SOURCE_SYSTEM_CD,SERVICE_TYPE_CD,RECENT_STATUS_CD
239502821,OA,SHARED,IN_PROGRESS
614614216,OES,CPE,OES_CMP
182028607,SLS,CPE,COMPLETED
182029311,ENGG,PROV_EVENT
614614219,OES,CPE,OES_CMP
182028606,SLS,CPE,COMPLETED
182029240,ENGG,PROV_EVENT
614614220,OES,CPE,OES_CMP
182027625,SLS,CPE,COMPLETED
182029254,ENGG,PROV_EVENT
614614221,OES,CPE,OES_CMP
182028605,SLS,CPE,COMPLETED
182029258,ENGG,PROV_EVENT
614614222,OES,CPE,OES_CMP
182027624,SLS,CPE,COMPLETED
182029267,ENGG,PROV_EVENT
614614404,OES,MGDSVC,OES_CMP
182027376,SLS,COMPLETED
182029268,ENGG,PROV_EVENT
182029270,ENGG,PROV_EVENT
182029271,ENGG,PROV_EVENT
614614403,OES,SHARED,OES_CMP
182027375,SLS,COMPLETED
182029250,ENGG,PROV_EVENT
614614405,OES,IQ,OES_CMP
182027435,SLS,COMPLETED
182029279,ENGG,PROV_EVENT
614614406,OES,IQ,OES_CMP
182027377,SLS,COMPLETED
182029280,ENGG,PROV_EVENT
182029912,ENGG,PROV_EVENT
614614407,OES,IQ,OES_CMP
182027437,SLS,COMPLETED
182029303,ENGG,PROV_EVENT
614614408,OES,MGDSVC,OES_CMP_READY
182027576,SLS,PROV_EVENT
182029273,ENGG,PROV_EVENT
182029278,ENGG,PROV_EVENT
182029281,ENGG,PROV_EVENT
614614409,OES,IQ,IN_PROGRESS
182027604,SLS,PROV_EVENT
182029315,ENGG,PROV_EVENT
182029920,ENGG,PROV_EVENT
614614411,OES,IQ,OES_CMP_READY
182027616,SLS,PROV_EVENT
182029264,ENGG,PROV_EVENT
614614410,OES,IQ,IN_PROGRESS
182027612,SLS,PROV_EVENT
182029259,ENGG,PROV_EVENT
614614412,OES,MGDSVC,IN_PROGRESS
182028383,SLS,PROV_EVENT
182029301,ENGG,PROV_EVENT
182029302,ENGG,PROV_EVENT
182029305,ENGG,PROV_EVENT
614614413,OES,IQ,OES_CMP_READY
182028390,SLS,PROV_EVENT
182029307,ENGG,PROV_EVENT
182029905,ENGG,PROV_EVENT
614614415,OES,IQ,OES_CMP_READY
182028443,SLS,PROV_EVENT
182029257,ENGG,PROV_EVENT
614614414,OES,IQ,IN_PROGRESS
182028434,SLS,PROV_EVENT
182029276,ENGG,PROV_EVENT
614614416,OES,IQ,IN_PROGRESS
182028523,SLS,PROV_EVENT
182029261,ENGG,PROV_EVENT
614614417,OES,IQ,IN_PROGRESS
182028483,SLS,PROV_EVENT
182029246,ENGG,PROV_EVENT
182029890,ENGG,PROV_EVENT
614614418,OES,IQ,OES_CMP_READY
182028531,SLS,PROV_EVENT
182029269,ENGG,PROV_EVENT
614614419,OES,MGDSVC,OES_CMP_READY
182028478,SLS,PROV_EVENT
182029238,ENGG,PROV_EVENT
182029241,ENGG,PROV_EVENT
182029242,ENGG,PROV_EVENT
614614420,OES,MGDSVC,OES_CMP_READY
182028214,SLS,PROV_EVENT
182029339,ENGG,PROV_EVENT
182029340,ENGG,PROV_EVENT
182029342,ENGG,PROV_EVENT
614614421,OES,IQ,IN_PROGRESS
182028223,SLS,PROV_EVENT
182029308,ENGG,PROV_EVENT
182029898,ENGG,PROV_EVENT
614614423,OES,IQ,IN_PROGRESS
182028262,SLS,PROV_EVENT
182029237,ENGG,PROV_EVENT
614614422,OES,IQ,OES_CMP_READY
182028270,SLS,PROV_EVENT
182029260,ENGG,PROV_EVENT

@Shaik.Yezdani - Here you go…

Regex Pattern : \d+(?=,)

@prasath17 Thanks for quick response not all the numbers the 10 digit number which comes after the text “OES,IQ,OES_CMP_READY”

@Shaik.Yezdani - There are 5 OES,IQ,OES_CMP_READY are there in the above given text…you are 10 digits #s only after this…

Sorry not clear…

@prasath17 Yes I need all three 10 digit numbers which are in next line to the text “OES,IQ,OES_CMP_READY” which are 182027616,182028390 and 182028443

@Shaik.Yezdani - yup got it…

1 Like

@prasath17 not working for me in matches activity, can you put the screenshot of matched result.

I removed \r now it is working :slightly_smiling_face:

@prasath17 Thank you so much :slightly_smiling_face:

@Shaik.Yezdani - Glad it worked…

1 Like

@Shaik.Yezdani - Just curious… I used with \r\n and it worked perfectly…

image

image

what activity you used ?

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.