Hi I trying to put together a Canadian postal code that come split in two lines, for example, input is coming from a text file: A1A 1W9 I want this in one line: A1A1W9 I'm using regex in the tReplace advance mode:
But is not working. What I'm doing wrong ? Thanks in advance Felix sample.txt.txtsample.txt_20150324-0312.txt
If you are trying to combine validated postal code, then why don't u just Concat both parts.
It's not so simple, the text is coming from a text file, and there are others values in addition to the Postal code, so I'm doing other replacements with the component (tReplace ->simple mode), for the postal code I decide to use regex, given the uniformity of the Canadian postal code.