How to edit string and add dots?

[Joker_Hazard]

Hi all.

I am trying to take this string: 13374147000193 and edit to became like this: 13.374.147/0001-59

The one issue I encountered is that sometimes some strings come with less than 14 caracthers, so it needs to add zeros to the right side for example:

135576000142 -> needs to become: 00.135.576/0001-42

 Would regex be the best option here?

Thanks

[Amol_Telore · Accepted solution]

Hey @Joker_Hazard 

First, you will need to use the formula tool to add leading zeroes in the field.

Formula:- 

PadLeft(tostring([Field1]),14,"0")

 Then use the regex tool in Replace mode.

Regex expression:-

(^\d{2})(\d{3})(\d{3})(\d{4})(\d{2})

Replace Expression:-

$1.$2.$3/$4-$5

Hope I have answered your question.

[binu_acs · Accepted solution]

@Joker_Hazard One way of doing this, similar to @Amol_Telore method

[binu_acs]

@Joker_Hazard Another way of dong this with the string functions