Question

Select by attributes with case sensitive and replacestring

rakeshreddy0996
Badge

 

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.. _/\\_..

10 replies

jdh
Rank
Badge +22

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.
rakeshreddy0996
Badge

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.....

jdh
Rank
Badge +22

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.

rakeshreddy0996
Badge

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

 

jdh
Rank
Badge +22

SOME OTHER DATA LIKE

 

Do you have a lookup table to say RPR is 2 or hit is 3?

rakeshreddy0996
Badge

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

 

jdh
Rank
Badge +22

there is no specific table just we use replace

 

In that case have a look at the StringPairReplacer (Case Sensitive: No)

pratap
Rank
Badge +2

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

rakeshreddysafe.fmw

del.xlsx

G
Badge +3

@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.

datumvariantennaardigits.fmw

 

 

I mostly use this for info.

https://www.tcl.tk/man/tcl8.6/TclCmd/clock.htm#M26

 

G
Badge +3

addendum

@rakeshreddy0996

@jdh is correct. It boils down to date formatting

Reply


Community Stats

28,670
Posts
109,364
Replies
36,531
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.