Removing Characters from header fields

parria1

I have a data set that includes headers formatted like this

WE
10/
24/
2020

WE
10/
17/
2020

WE
10/
10/
2020

WE
10/
03/
2020

Sep
2020

Aug
2020

Jul
2020

Jun
2020

May
2020

I have two issues keeping me from outputting this to a table in an Access Database:

1. Carriage return. I have this fixed with a regex formula in a multi field formula tool

2. the / character in the date fields. how do i replace this with a dash? i tired find and replace but the tool would not display the fields above that had the / symbol.

Regex

Preparation

Accepted answers

AngelosPachis

Hi @parria1 ,

If the "/" character is in your headers, you can use a dynamic rename tool, connect your stream to the L input anchor and use the following formula

Screenshot 2020-10-30 173642.jpg

Hope that helps.

Regards,

Angelos

All comments

AngelosPachis

Hi @parria1 ,

If the "/" character is in your headers, you can use a dynamic rename tool, connect your stream to the L input anchor and use the following formula

Screenshot 2020-10-30 173642.jpg

Hope that helps.

Regards,

Angelos

parria1

That works for the / fields.

my regex in the multiformula field toold for the carriage return actually is not working on the numeric fields. here is what i have

Regex_Replace( [_CurrentField_], "\r*\n*", "")

i receive the error below

Error: Multi-Field Formula (13): Parse Error at char(1): Formula: tried to apply string operator to numeric value (REGEX_REPLACE)

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703