String trucation

[Nandakishore]

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

[aatalai]

@Nandakishore is it please possible to have some more sample data - both input and output?

[Nandakishore]

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

[Nandakishore]

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

[aatalai]

@Nandakishore does the attached workflow help?

[Nandakishore]

Hi @aatalai ,

I think this will fail if output1 and string after output 2 is changed .

[aatalai]

@Nandakishore can you please provide some more examples? so I can adapt accordingly

[Nandakishore]

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

[aatalai · Accepted solution]

@Nandakishore this should do the trick, let me know how you get on

[Nandakishore]

Hi @aatalai ,

It worked . THankyou .