Hello ,
Trying to clean up below string using regex using expression (\w+) :
RE 001705 20004658.SE0008 VOLVO LOGISTICS AB ARHK-4, DEPT 5325, ARK 1 ...
While doing so the higlighted text is splitted into two strings 20004658 and SE0008 .
I would like to retain as 20004658.SE0008 . Any help .
Thanks
Solved! Go to Solution.
@Nandakishore is it please possible to have some more sample data - both input and output?
Hi @aatalai,
Below are the details :
Input | Output 1 | Output2 |
RE 001705 20004658.SE0008 VOLVO LOGISTICS AB ARHK-4, DEPT 5325, ARK 1 ... | RE 001705 | 20004658.SE0008 |
Hi @aatalai ,
Few more details :
Input | Output 1 | Output2 |
RE 001705 20004658.SE0008 VOLVO LOGISTICS AB ARHK-4, DEPT 5325, ARK 1 ... | RE 001705 | 20004658.SE0008 |
RE 001705 20004658/SE0008 VOLVO LOGISTICS AB ARHK-4, DEPT 5325, ARK 1 ... | RE 001705 | 20004658/SE0008
|
@Nandakishore does the attached workflow help?
@Nandakishore can you please provide some more examples? so I can adapt accordingly
Hi @aatalai ,
Some more examples :
Input | Output 1 | Output2 |
AB 001705 20004658.SE0008 XXX XXXX AB A1223445555 ... | RE 001705 | 20004658.SE0008 |
RE 001705 20004658/SE0008 YYYY AB dddddddd ... | RE 001705 | 20004658/SE0008 |
@Nandakishore this should do the trick, let me know how you get on