Unfortunately, nongreedy (?


Is your text entirely semi-colon delimited? Does it have a Key column? If so, I would recommend trying out the Data Compare session type. You can define the ; characters as the delimiter, and the Data Compare will then place your text into columns and align by the Key column (default: Column 1). You must have at least 1 key column, and the key column must match exactly. You can define multiple key columns (such as First Name and Last Name) to create a unique identifier. If you need to "move" the key column from column 1, define another column as the Key column first, then remove it.
Leave a comment: