Removing Characters from header fields
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Preparation
- Regex
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
it needs to be a numeric field.
i guess i can change it to text, do the regex, then change it back to numeric.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Correct @parria1 , hope that works!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
it's not practical in the long run as new fields will pop up that have this issue.
![](/skins/images/A29875142F332EEF75F19ED75711F41B/responsive_peak/images/icon_anonymous_message.png)