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.
I'm trying with no success to replace te string "john wick" for the string "john wick"
The difference between the two strings is that one have a tab and the other have a space between the words.
This string are in a csv file separated by tabs, and that misplaced tab in the record causes a error "Too Many Fields in record"
I tried to solve it using:
Replace([Field], "john wick", "john wick")
but the formula does not find the string with the embeded tab
Maybe this can be acomplished using REGEX_Replace, but I'm not shure about the sintax.
Other option wold be to ignore delimiters between "john" and "wick" when parsing to columns, but I don't know the sintax either
Go to Solution.
Go to Solution.
Hi @mauricio - I suggest you to try a Data Cleansing tool first:
Unfortunately I can't because it will remove all other tabs that are used to parse the data into columns.
I need to surgically remove only the tabs that are between "John" and "Wick"
if you are looking to do a regex replace for a tab (and you are sure it's a tab) it's something like:
regex_replace([field1],"(\w+)\t(\w+)","$1 $2") or you can do regex_replace([field1],"(\w+)\t(\w+)","$2, $1") and "Wick, John"
Sure. Then use this: REGEX_Replace([Col1], "john\twick", "John Wick")
That worked perfectly thanks.