Regex for the following word

Help
1

Hi everyone,

Can anyone help me in this
INPUT:
JE10-2120-1-9100 78-2125-3-0001 2 YES
78-2100-3-0112 10 NO

JE10-2126-1-3800 78-2100-3-0113 1 NO

EXPECTED OUTPUT
78-2125-3-0001 2 YES
78-2100-3-0112 10 NO
(For the first two line)

78-2100-3-0113 1 NO

Please help me on this
@Susana @lakshman @vvaidya

Thanks
Srikanth

2

Give this RegEx a shot : [0-9]{2}-[0-9]{4}-[0-9]-[0-9]{4} [0-9]* [a-zA-Z]+

3

Hi @Srikanth_prem

Use regex as (?<=JE10-2120-1-9100).*

Thanks
Ashwin.S

5

@Srikanth_prem, you can simply use split function and extract the text on the basis of Spaces.

6

@Srikanth_prem
You can try this pattern (\d{2})-(\d{4})-(\d)-(\d{4})\s(\d+)\s(\w{2,3})

1 Like