Insert/add additional space(white space) between every white space in a string.

Question

Hi - I'm trying to add additional white space between white space that is already present in my dataset. So for e.g. in row 1 in my below dataset, I'm trying to add additional whitespace between fjhdsfkljasn AND 123123 AND adlan AND f2131n AND sldkn. I know this looks like gibberish but im scrubbing a pdf and there isnt any real pattern to the data from row to row that i have noticed. Appreciate the help!

Field1fjhdsfkljasn 123123 adlan f2131n sldknaksdnal n12312 asldknad lkandskands asdasd a     asdlkasdn s             901329             aslkdnalskdn sl           aslkdnaskdn     aksdn123dasd183713 alsdn al 12312 3

davidskaife · Accepted Answer

Hi @jaiiracha

Two potential options for you:

First one will replace EVERY instance of whitespace with an extra whitespace - i.e if you already have a double whitespace between two words it will replace both with two, bringing the total whitespace to four.

Second option will only replace a single instance of whitespace, thus ignoring any double (or more) whitespace.