I have a table like below
select red highlighted data and replace at once without case sensitive
I need to change as like below table
Thanks in Advance.. _/\\_..
Question
Select by attributes with case sensitive and replacestring
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+40- Contributor
I would consider using the DateTimeConverter (formally DateFormatter). You may need to use conditionals and/or split your input data as you have multiple input formats.
See https://www.safe.com/blog/2017/08/yet-another-awesome-datetime-update-evangelist165/ for a blog post about it.
I would consider using the DateTimeConverter (formally DateFormatter). You may need to use conditionals and/or split your input data as you have multiple input formats.
See https://www.safe.com/blog/2017/08/yet-another-awesome-datetime-update-evangelist165/ for a blog post about it.
that data is not time formatting data it just mistake
some times we are getting other universal words like SUN MOON.....
+40- Contributor
that data is not time formatting data it just mistake
some times we are getting other universal words like SUN MOON.....
If you want to turn FEB into 2, that's date formatting.
I would consider using the DateTimeConverter (formally DateFormatter). You may need to use conditionals and/or split your input data as you have multiple input formats.
See https://www.safe.com/blog/2017/08/yet-another-awesome-datetime-update-evangelist165/ for a blog post about it.
SOME OTHER DATA LIKE
I would consider using the DateTimeConverter (formally DateFormatter). You may need to use conditionals and/or split your input data as you have multiple input formats.
See https://www.safe.com/blog/2017/08/yet-another-awesome-datetime-update-evangelist165/ for a blog post about it.
there is no specific table just we use replace
+40- Contributor
there is no specific table just we use replace
In that case have a look at the StringPairReplacer (Case Sensitive: No)
+12- Contributor
Hi,
There is no generic solution for this kind. Kindly find the workspace along with data used were attached to this thread. I have prepared based on the data you have presented.
For more data, you have to make sure the mapping because you are using JAN/jan/Raj=1
+15- Contributor
@rakeshreddy0996
@jdh
@pratap
Yes you can...as always ;)
You need to complete the dates first to get a valid date.
Then just read and write. In tcl we would say scan and format.
Here is a workspace.
You could replace the tcl by the fme datefunctions to achieve the same.
I mostly use this for info.
https://www.tcl.tk/man/tcl8.6/TclCmd/clock.htm#M26