Hi @Inactive User
Could you share a print of how you are applying the formula? I tryed here and it seems to be doing what you want to do (replacing spaces by _, right?). You can use just replace([Value],' ', '_') instead btw.
Hi @Inactive User
try this one. I think that what you have is not just spaces, but tabulations (\t):
Regex_Replace([Value], '\t', '_')
By default 1 tab is equal to 8 spaces, so if you want to keep the same number of spaces you could do:
Regex_Replace([Value], '\t', '________')
That does not work :(
I think the problem is that I have line break... but I don't know
@Inactive User
can you share a sample of your input file? Just with the first 10 rows or something like that.
@Felipe_Ribeir0
I can not share any data. I created an example with my problem.
The header is in the middle of the table and have the format like in the xlsx-data
@Inactive User I think Regex_Replace([Value],'\s','_') is what you're after. It will replace any whitespace with an underscore
Hope that helps,
Ollie