SOLVED
Need to count words and put /
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
mmustkee
10 - Fireball
‎07-14-2023
08:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team,
I have data in which we need to place "/" after each 3 letter. We have "/" in many of the field but sometimes it is 6 letters together without "/". Please refer table below
Date | Result |
ssn/ssd/fdcdcf/cdf/klnsdn | ssn/ssd/fdc/dcf/cdf/kln/sdn |
ssn/ssd/fdcdcf/cdf/kln/dfc | ssn/ssd/fdc/dcf/cdf/kln/dfc |
ssd/dfrsdr/dsr | ssd/dfr/sdr/dsr |
dfrssn/sdf/dfrtgy/kly | dfr/ssn/sdf/dfr/tgy/kly |
Solved! Go to Solution.
Labels:
- Labels:
- Regex
3 REPLIES 3
FrederikE
13 - Pulsar
‎07-14-2023
08:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @mmustkee,
You can achive this using RegEx in a Formula tool:
REGEX_Replace(Replace([Date], "/", ""), "(...)", "$1/")
See the attached WF.
‎07-14-2023
08:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for your solution.
We can not replace "/" with "" as we have huge data and sometimes we have incorrect data. so only thing I want is to place "/" where ever we have 6 letters together without space and without "/"
FrederikE
13 - Pulsar
‎07-14-2023
08:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
