How to strip digits from the middle of a string - if string has a certain length?

[Carlos77]

Dear all,

I have a fieldname 'Reference', V_WString, where I have multiple different length values, actual examples below;

23660620210301100

BI501120210901100

1940790MKTF63

(null)

04703710103700

10276495740403

I would need a way to remove digits from string positions 7, 8 and 9, IF the string length = 17. For any other strings, no manipulation is needed.

Anyone able to solve this?

Cheers,

Carlos77

[Sebastiaandb · Accepted solution]

@Carlos77 

This might just work 🙂

Just take the string from char 1 -6 and 10-17 and combine them whenever the length is 17.

Greetings,

Seb

[Carlos77]

Excellent, it works, many thanks Sebastiaandb! 🙂

Best regards,

Carlos77

[Sebastiaandb]

@Carlos77 Glad to be of help! Cheers!

Seb

[HomesickSurfer · Accepted solution]

Hi @Carlos77 

A variation of the solution offered by @Sebastiaandb instead of joining remainder beginning and end strings:

IF Length([Reference])=17 THEN REGEX_Replace([Reference], Substring([Reference],6,3), "") ELSE [Reference] ENDIF

[Carlos77]

Hi @HomesickSurfer,

this solution also works perfectly (just tested it), many thanks for your help! 🙂

Best regards,

Carlos77