Add characters into the Middle of the string

Hi i want to add a character in middle of the string please help

input string as below
|| Shriharsha H N || INR 12345.25 Value Date : 03/10/2018 1.0000 INR 12345.25|to A/C No. 01234567890123456

i need to add from to A/C No.01234567890123456 to the next to Value date : 03/10/2018

i want output like this below:
|| Shriharsha H N || INR 12345.25 Value Date : 03/10/2018 to A/C No. 01234567890123456 1.0000 INR 12345.25|

Thanks in advance

Hi,

You can get it using Replace activity with the following settings.

Pattern : "(Value Date : \d{2}/\d{2}/\d{4}\s)(.*?)(to A/C No. \d+)$"
Replacement : "$1$3$2"

The result will be what you need.

Regards,

1 Like

@Yoichi Thanks a lot it works fine :slight_smile:

1 Like

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