This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Situation: Strings that are 4 characters long are getting concatenated into one sting in a single column due to insufficient controls during data input. For example: 'ABCDwxyz' should instead be split into 'ABCD' and 'wxyz'
Sometimes 2 strings are concatenated, sometimes more. For example, 4 strings concatenated might look like this: 'ABCDwxyzLMNOefgh'
Using the following function (followed by a Text to Column tool, using a space as the delimiter) allows me tocorrect for this, but seems really crude:
IF [Site Len] = 8 THEN Substring([No 5th char],0, 4) + " " + Substring([No 5th char],4,4)