I have a record that has spaces as seperators, but unfortunately not just one space each time, any number of spaces.
1 2 3 4 5 6 7
Using " " as seperator does not work, so I either need a better seperator or to strip out any unrequired spaces before delimiting, the trouble here is that I still need a single space in order to delimit to stripping all spaces is no good.
Thanks for the response. The number of spaces is random, so this will not quite work. I did think of doing several tmap with a StringHandling.EREPLACE(row1.newColumn," "," ") for each number of spaces, but doing this 6/7 times would not be ideal.
Sorry, I didn't realize your problem. You can use tFileInputRegex to retrieve your columns , in your case the regular expression would be like this: "(+)"+"+"+"(+)" Here, I suppose that you have 2 columns. Regards, Youssef
In the end I decided to read the file as a one line column delimited by '\n', then using treplace I have set conditions to remove the various number of blank spaces possible and replace with a single space, then an extractdelimited using a single space as the delimiter.
Its now working.
As a product trial I am reworking a series of Ab Initio Graphs, so am probably going to post a few questions.