Hi Team,
Could you please advise how to achieve the below result using regex(Regular expression)
and spaces may not be constant always.
Raw data
Customer Name: Naseer Rahaman CUSTOMER NUMBER: 2010-1234567
22-DEC-15 RES asfdfsda 84723 15285282 RES CHECK 0 123456 23-DEC-15 5,219.55 0.00 0.00
Expected Result
Naseer Rahaman 2010-1234567 22-Dec-15 RES asfdfsda 84723 15285282 RES CHECK 0 123456 23-Dec-15 5,219.55 0.00 0.00
Please find the attached workbook for your reference and advise.
Thanks in advance for all your help and support.
Regards,
Rahaman
[TABLE="width: 156"]
[tr][td][/td][/tr]
[/TABLE]