Hello, I have a table with 49 fields which basically looks like this: Field 1Field 2Field 3Field 4Field xField 49Field 1 string1##Field 2 string1##Field 3 string1##Field 4 string1##Field x string1##Field 49 string1Field 1 string2##Field 2 string2##Field 3 string2##Field 4 string2##Field x string2##Field 49 string2Field 1 string3##Field 2 string3##Field 3 string3##Field 4 string3##Field x string3##Field 49 string3 Is it possible to remove # from all of the fields at once? Thanks.

remove characters from all fields

Hello,

I have a table with 49 fields which basically looks like this:

Field 1	Field 2	Field 3	Field 4	Field x	Field 49
Field 1 string1#	#Field 2 string1#	#Field 3 string1#	#Field 4 string1#	#Field x string1#	#Field 49 string1
Field 1 string2#	#Field 2 string2#	#Field 3 string2#	#Field 4 string2#	#Field x string2#	#Field 49 string2
Field 1 string3#	#Field 2 string3#	#Field 3 string3#	#Field 4 string3#	#Field x string3#	#Field 49 string3

Is it possible to remove # from all of the fields at once?

Thanks.

Common Use Cases

Accepted answers

Thableaus

Hi @umidjon

You can use the ReplaceChar function in the Multi-Field Formula Tool.

Select all of your fields.

ReplaceChar([_CurrentField_], "#", "")

Cheers,

JosephSerpis

Hi @umidjon you can use a multi field tool to replace within the fields you select.

Multifield170919.yxmd

All comments

Thableaus

Hi @umidjon

You can use the ReplaceChar function in the Multi-Field Formula Tool.

Select all of your fields.

ReplaceChar([_CurrentField_], "#", "")

Cheers,

JosephSerpis

Hi @umidjon you can use a multi field tool to replace within the fields you select.

Multifield170919.yxmd

umidjon

Thanks it worked like a charm. I was overdoing in my google searches.

Bigmonki

Hi Joseph, @JosephSerpis

if in my field I have something like 00UTIL or IPWORKSHOP, how would I write the expression to remove the first 2 characters, so I want to remove the 00 or the IP?

Many thanks in advance for any help you can provide

JB0007

Hi All, I am struggling to remove the following from my field " A^ " , I have tried the the above formula in a multifield formula but no luck, any assistance? I think it may be due to the special character

sparksun

@JB0007

It seems you are trying to remove the character from multiple field names, Dynamic Rename tool will be the right tool for this case.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703