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.
Solved! Go to Solution.
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
Hope that helps.
Regards,
Angelos
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)
Hey @parria1 , apparently the field you are applying your regex is a numeric data field and regex can only be applied into string fields. Can you make sure the field you are applying regex to in your multi-field formula tool is a string field please?
it needs to be a numeric field.
i guess i can change it to text, do the regex, then change it back to numeric.
Correct @parria1 , hope that works!
it's not practical in the long run as new fields will pop up that have this issue.