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

[jaiiracha]

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!

Field1

fjhdsfkljasn 123123 adlan f2131n sldkn

aksdnal n12312 asldknad

lkandskands asdasd a     asdlkasdn s             901329

aslkdnalskdn sl           aslkdnaskdn     aksdn123

dasd183713 alsdn al 12312 3

[DavidSkaife · Accepted solution]

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.