Start a new topic

Bank Sortcodes

Hello,

I am very very new to the wonderful world of Importomatic, and am having a hard time getting to grips with the dictionaries. I have browsed through one or 2 topics in this forum that are helping me understand how they work. But there is one thing I cant get my head around, and thats Bank Sortcodes. I have yet to figure out the correct method of getting the Sortcodes into the correct 12-34-56 code. Is there a way to do it? 


1 person has this question

Hi Andrea,
Although it's very hard to see, the Replacement Value in this dictionary is "$1-$2-$3". Try modifying this in your dictionary and you should be good to go!
Let us know if you encounter any other issues!
Many thanks,
Stephanie Johnson
Omatic Support
Hi, when I attempted this I just got S1-S2-S3 as the Computed text; I definietly copied the correct (\d{2})(\d{2})(\d{2}) and had Regular Expressions ticked? Has anyone else managed this successfully please?
Thanks
Andrea


Hi Terry,

I found a regular expression that can do that in a dictionary. Hope this works for you as well as it does for me!

image


Sincerely, Allison B.

Login or Signup to post a comment