nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How can I replace character 14 - 20?

imarijan

Hi all,

I am new to Alteryx and struggling to do the following, trying to replace the characters 14 - 20 (marked below) in a column with 0000000.

Sample:

CA003.170024.1004167.80401.208.CA011
CA003.170017.1004167.80401.600.US085
CA003.170017.1001700.80401.208.FR012
CA003.170017.1001700.80401.208.FR012
CA003.170017.1003782.80401.208.CH051

Any help is very much appreciated.

Thank you all, Irena

Regex

Accepted answers

jdunkerley79

Probably the easiest way is:

Left([Field1],13)+'0000000'+Substring([Field1],20)

Have attached a quick sample

Replace14to20.yxmd

atcodedog05

Hi @imarijan ,

Here is a way to do it.

Using below in the formula

Left([Text],13)+'0000000'+Substring([Text],20)

Output

Another formula

Left([Text], 13)++'0000000'+Right([Text], Length([Text])-20)

Hope this helps : )

If this helps please mark this post as solution

replace.yxmd

vizAlter

Hi @imarijan — Try this solution... you can also solve like this:

1) Use "RegEx" tool for Replace output method:

(.{13})(.{1}[0-9]{6})(.*)

1st Group ( ) reads 1st to 13th position,

then 2nd Group ( ) reads from 14th position to 20th which is actually 1st to 6th position for this Group,

and 3rd Group ( ) is for remaining text, till end.

And, put this expression in the Replacement Text section of your RegEx tool:

$1$'0000000$3

If this solves your issue , if not let me know!

RegEx_replace position - vA.yxmd

All comments

jdunkerley79

Probably the easiest way is:

Left([Field1],13)+'0000000'+Substring([Field1],20)

Have attached a quick sample

Replace14to20.yxmd

atcodedog05

Hi @imarijan ,

Here is a way to do it.

Using below in the formula

Left([Text],13)+'0000000'+Substring([Text],20)

Output

Another formula

Left([Text], 13)++'0000000'+Right([Text], Length([Text])-20)

Hope this helps : )

If this helps please mark this post as solution

replace.yxmd

atcodedog05

Haha... looks like @jdunkerley79 already got here : )

vizAlter

Hi @imarijan — Try this solution... you can also solve like this:

1) Use "RegEx" tool for Replace output method:

(.{13})(.{1}[0-9]{6})(.*)

1st Group ( ) reads 1st to 13th position,

then 2nd Group ( ) reads from 14th position to 20th which is actually 1st to 6th position for this Group,

and 3rd Group ( ) is for remaining text, till end.

And, put this expression in the Replacement Text section of your RegEx tool:

$1$'0000000$3

If this solves your issue , if not let me know!

RegEx_replace position - vA.yxmd

imarijan

Thank you very much for the quick response! Amazing

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15905

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703