Delete a certain part of a row

[Schnugru]

Hi,

I have a source file from which all rows need to be cleaned.

The strings in that column are composed as follows <string part a>|"<string part b>".

I need to seperate part b from all the rest. String part a are always 12 digits.

How can I remove the first part of the string, including the " character. Also I want to remove the second ". String part b also always has 12 digits.

Can this be solved with a certain RegEx - formula?

thanks for your time and assistance.

regards

Philip

Example:

282008472524|"749A4E235CA4"

[Kenda · Accepted solution]

Hey @Schnugru! You could use a Text to Columns tool with the pipe | as the delimiter. Split your field into 2 columns. Then, you will just have to apply the following formula to the second field that is generated:

REGEX_Replace([Field12], '"', "")

Hope this helps!

[Schnugru]

Thanks, that was the Tool I was looking for.

Chhers