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)
Apologies if I'm not doing this right - my first post. My issue seems similar here, but I'm trying to do something very basic.
I have a string that outputs " 17'4.5" " with no space between the feet and inches. I would like to add a space between the apostrophe and the 4.5 in the string so that it reads " 17' 4.5" ". A slight change, but it's pretty important when looked at among thousands of records. Any help with Regex in doing this?